protected void Page_Load(object sender, EventArgs e) { string userId = HttpContext.Current.User.Identity.GetUserId(); string strFileName = string.Empty; string strPath = string.Empty; int totalCount = 0; Base64BinarySrtingToFile save = new Base64BinarySrtingToFile { FilePrefix = userId }; save.SaveFileNew("FileUpload"); bool issave = false; if (save.IsSaved) { issave = true; strFileName = save.FileName; strPath = save.Path; switch (save.Format) { case "csv": totalCount = new GsCsvReader(strPath, strFileName).ResultDataTable.Rows.Count; break; case "excel": totalCount = new ExcelReader(strPath, strFileName).GetDataSetCreatecolumn().Tables[0].Rows.Count; break; } Model_SubscriberImportTemp temp = new Model_SubscriberImportTemp { FileName = save.FileName, Path = save.Path, TotalRecord = totalCount }; SubScriberImportController.ImportTemp(temp); } string res = (new BaseWebMethodAJax { success = issave, msg = "formet:" + save.Format + " filename:" + save.FileName + save.Error + save.ErrorDetail, Totalrecord = totalCount.ToString(), KeyID = userId }).ObjectToJSON(); AppTools.SendResponse(HttpContext.Current.Response, res); }
public static int ImportNow(Model_SubscriberParamImport param) { int ret = 0; Model_SubscriberImportTemp import = new Model_SubscriberImportTemp(); import = import.GetImportTemp(); DataTable data = null; if (import != null) { try { FileInfo file = new FileInfo(HttpContext.Current.Server.MapPath(import.Path + import.FileName)); if (file.Exists) { string extension = file.Extension; switch (extension) { case ".csv": data = new GsCsvReader(import.Path, import.FileName).ResultDataTable; break; default: data = new ExcelReader(import.Path, import.FileName).GetDataSetCreatecolumn().Tables[0]; break; } if (data.Rows.Count > 0) { Lock.AcquireWriterLock(Timeout.Infinite); SubScriberImportController.TotalCompleted = 0; SubScriberImportController.PercentCompleted = 0.0M; SubScriberImportController.Onprocess = true; Lock.ReleaseWriterLock(); API_ThreadPool cpool = new API_ThreadPool(); object[] parameters = new object[] { data, param }; cpool.QueueWork(parameters, ImportSubscriber); } } ret = 1; } catch { } } return(ret); }
public static Model_SubscriberImportTemp GetTempImprt() { Model_SubscriberImportTemp import = new Model_SubscriberImportTemp(); return(import.GetImportTemp()); }
public static int ImportTemp(Model_SubscriberImportTemp param) { Model_SubscriberImportTemp import = new Model_SubscriberImportTemp(); return(import.InsertDataImport(param)); }