ext cxv import controller - Hightechrobo bin

TEXT 6

Ext cxv import controller Guest on 14th July 2025 05:50:35 AM

[HttpPost]
public async Task<ActionResult> UploadExtentionCsv(HttpPostedFileBase file)
{
if (file == null || file.ContentLength == 0)
return Json(new { status = "No file" }, JsonRequestBehavior.AllowGet);
SettingDataHandler dal = new SettingDataHandler();
try
{
var ExtentionList = new List<Extention>();
var already_exists = new List<string> { };
using (var reader = new StreamReader(file.InputStream))
using (var csv = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture)))
{
var records = csv.GetRecords<Extention>();
foreach (var ext in records)
{
if (await dal.ExtensionExistenceCheck(ext.ExtensionId))
{
already_exists.Add(ext.ExtensionId);
}
ExtentionList.Add(ext);
}
}
Task.Run(async () =>
{
await add_csv_to_db(ExtentionList);
});
if (already_exists == null)
return Json(new { status = "ok" }, JsonRequestBehavior.AllowGet);
else
return Json(new { status = $"Thease already Exists " , extention = already_exists } , JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(new { status = ex.Message }, JsonRequestBehavior.AllowGet);
}
}
public async Task add_csv_to_db(List<Extention> ExtentionList)
{
SettingDataHandler dal = new SettingDataHandler();
GroupController g = new GroupController();
try
{
foreach (var data in ExtentionList)
{
await dal.CreateExtention(data);
await dal.AddExtionToGroup(data.GroupId.ToString(), data.ExtensionId);
}
}
catch (Exception ex)
{
}
}

Advertise here

Recent Pastes

Raw Paste

[HttpPost]
        public async Task<ActionResult> UploadExtentionCsv(HttpPostedFileBase file)
        {

if (file == null || file.ContentLength == 0)
                return Json(new { status = "No file" }, JsonRequestBehavior.AllowGet);

SettingDataHandler dal = new SettingDataHandler();
            try
            {
                
                var ExtentionList = new List<Extention>();
                var already_exists = new List<string> { };

using (var reader = new StreamReader(file.InputStream))
                using (var csv = new CsvReader(reader, new CsvConfiguration(CultureInfo.InvariantCulture)))
                {
                    var records = csv.GetRecords<Extention>();

foreach (var ext in records)
                    {
                        if (await dal.ExtensionExistenceCheck(ext.ExtensionId))
                        {
                             already_exists.Add(ext.ExtensionId);
                        }

ExtentionList.Add(ext);
                    }
                }

Task.Run(async () =>
                {
                    await add_csv_to_db(ExtentionList);
                });

if (already_exists == null) 
                return Json(new { status = "ok" }, JsonRequestBehavior.AllowGet);
                else
                    return Json(new { status = $"Thease already Exists " , extention = already_exists  } , JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                return Json(new { status = ex.Message }, JsonRequestBehavior.AllowGet);
            }
        }

public async Task add_csv_to_db(List<Extention> ExtentionList)
        {
            SettingDataHandler dal = new SettingDataHandler();
            GroupController g = new GroupController();
            try
            {
                foreach (var data in ExtentionList)
                {
                    await dal.CreateExtention(data);
                    await dal.AddExtionToGroup(data.GroupId.ToString(), data.ExtensionId);
                } 
            }
            catch (Exception ex)
            {
            }

}