public virtual ResponseBase Delete(DbConnect con, TKey id) { ResponseBase resp = new ResponseBase(false, string.Empty); if (CrudRepo.SoftDelete(con, id)) { resp.success = true; resp.message = "Data Deleted successfully."; } else { ModelBase mdl = new ModelBase(); if (CrudRepo.Is_Child_Records_Exists) { resp.errors.Add("Parent_child", mdl.GetLang("parent_delete_error")); } resp.message = "System Error :: DB"; } if (resp.success == false) { resp.PushErrors(CrudRepo.Errors); resp.PushErrors(Errors); resp.PushErrors(ValidationErrors); } return(resp); }
public virtual TModel GetAsModel(DbConnect con, TKey id) { TModel item = CrudRepo.GetAsModel(con, id); if (CrudRepo.Errors.Count > 0) { Errors.AddRange(CrudRepo.Errors); return(null); } return(item); }
public virtual DynamicDictionary GetAsDictionary(DbConnect con, TKey id) { DynamicDictionary item = CrudRepo.Get(con, id); if (CrudRepo.Errors.Count > 0) { Errors.AddRange(CrudRepo.Errors); return(null); } return(item); }
public ActionResult CrudAdd(string mode, int id = 0) { if (!string.IsNullOrEmpty(mode) && mode == "edit") { CrudRepo db = new CrudRepo(); return(View(db.GetCrudById(Convert.ToInt32(id)))); } else { return(View()); } }
/// <summary> /// Inserts the data into the database. /// </summary> /// <param name="db">The database connection to be used</param> /// <param name="item">Data which need to be inserted</param> /// <returns>Returns null if insert fails else returns data in DynamicDictionary</returns> public virtual ResponseModel Insert(DbConnect con, DynamicDictionary item) { ResponseModel resp = new ResponseModel(false, string.Empty); TModel model = new TModel(); try { //validate data before saving if (!IsValid((DynamicDictionary)item.Clone(), false, con)) { resp.message = "Validation failed."; resp.PushValidationErrors(ValidationErrors); return(resp); } //save if (CrudRepo.Insert(con, item)) { if (LoadItemAfterSave) { //PropertyInfo key = Models.ModelService.GetKeyPropertyInfo(item); //TKey id = Models.ModelService.ChangeType<TKey>(key.GetValue(item)); //CrudSrvc.get //item = CrudSrvc.GetItemAsModel(id); resp.data = item; } resp.success = true; resp.message = "Data added successfully."; } else { resp.message = "System Error :: DB"; } } catch (Exception ex) { Errors.Add(ex.Message); } if (resp.success == false) { resp.PushErrors(CrudRepo.Errors); resp.PushErrors(Errors); resp.PushValidationErrors(ValidationErrors); } return(resp); }
/// <summary> /// Updates the data into the database. /// </summary> /// <param name="db">The database connection to be used</param> /// <param name="id">The key value of which the data need to be updated.</param> /// <param name="item">Returns null if update fails else returns data in DynamicDictionary</returns> public virtual ResponseModel Update(DbConnect con, TKey id, DynamicDictionary item) { ResponseModel resp = new ResponseModel(false, string.Empty); PropertyInfo key = model.GetKeyPropertyInfo(); if (key == null) { throw new Exception("Primary key not defined in business object(model)."); } //validate data before saving if (!IsValid(item, true, con)) { resp.message = "Validation failed."; resp.PushValidationErrors(ValidationErrors); return(resp); } //save if (CrudRepo.Update(con, id, item)) { if (LoadItemAfterSave) { //PropertyInfo key = Models.ModelService.GetKeyPropertyInfo(item); //TKey id = Models.ModelService.ChangeType<TKey>(key.GetValue(item)); //CrudSrvc.get //item = CrudSrvc.GetItemAsModel(id); resp.data = item; } resp.success = true; resp.message = "Data updated successfully."; } else { resp.message = "Error while saving data"; } if (resp.success == false) { resp.PushErrors(CrudRepo.Errors); resp.PushErrors(Errors); resp.PushValidationErrors(ValidationErrors); } return(resp); }
public override ResponseBase Delete(DbConnect con, int?id) { ResponseBase resp = new ResponseBase(false, string.Empty); if (CrudRepo.HardDelete(con, id)) { resp.success = true; resp.message = "Data Deleted successfully."; } else { resp.message = "System Error :: DB"; } if (resp.success == false) { resp.PushErrors(Errors); resp.PushErrors(ValidationErrors); } return(resp); //return base.Delete(con, id); }
public ActionResult DeleteCrud(int Id) { try { CrudRepo db = new CrudRepo(); if (db.DeleteCrud(Id)) { TempData["success"] = "Deleted Successfully"; return(RedirectToAction("Crud", "Home")); } else { TempData["error"] = "Record Deletion Unsuccessfull"; return(RedirectToAction("Crud", "Home")); } } catch (Exception ee) { TempData["error"] = "Record Not Found or Deleted by Another user"; return(RedirectToAction("Quiz", "Home")); } }
public ActionResult CrudAdd(FilterWordModel model) { try { CrudRepo db = new CrudRepo(); bool result = db.CrudAdd(model); if (result) { TempData["success"] = "Saved Successfully"; return(RedirectToAction("Crud", "Home")); } else { TempData["error"] = "Record Added & Updated Unsuccessfully"; } } catch (Exception ex) { TempData["error"] = "Record Added & Updated Unsuccessfully"; } return(View()); }
public ActionResult CrudPartialView() { CrudRepo crud = new CrudRepo(); return(PartialView(crud.GetCrud())); }
public bool ProcessAllWholesaler() { bool status = false; try { //Console.WriteLine(@"********************************* // 1 Amerisource // 2 Anda // 3 ASD // 4 BioCARE // 5 Cardinal // 6 CardinalSPD // 7 Curascript // 8 Dakota // 9 HDSmith // 10 Kinray // 11 McKesson // 12 MckessonSP // 13 Metro Medical Supply // 14 MorrisDickson // 15 NC Mutual // 16 R & S Pharma // 17 RDC // 18 SmithDrug // 19 Valley Wholesale // 20 ValueDrug"); // //Console.WriteLine("*********************************"); Console.WriteLine(@"************ wrpid ********************** 7 Amerisource 143 Anda 116 ASD 14821 BioCARE 9 Cardinal 14695 CardinalSPD 27039 Curascript 147 Dakota 11 HDSmith 10 Kinray 8 McKesson 15945 MckessonSP 135 Metro Medical Supply 29 MorrisDickson 80 NC Mutual 14691 R & S Pharma 6 RDC 36 SmithDrug 57 Valley Wholesale 77 ValueDrug"); Console.WriteLine("*********************************"); ConfigurationManager.AppSettings["reportlogfile"] = ConfigurationManager.AppSettings["reportlogfile"].Replace("Date", DateTime.Now.ToString("yyyyMMdd")); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + " ******************* Parsing Started : " + DateTime.Now.ToShortDateString() + "***************************"); for (int i = 0; i <= wrpid_array.Length - 1; i++) { importFileRows = 0; int wrpid = wrpid_array[i]; string ParserFile_wrpid = ConfigurationManager.AppSettings["ParserFile_wrpid"]; try { if (int.Parse(ParserFile_wrpid) > 0) { wrpid = int.Parse(ParserFile_wrpid); // i=wrpid_array.Length - 1; } } catch { Console.WriteLine("ParserFile_wrpid = " + ParserFile_wrpid + " Invalid"); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + "ParserFileID = " + ParserFile_wrpid + " Invalid"); return(false); } Console.WriteLine(GetwholesalerNameBy_wrpid(wrpid) + " - Searching File "); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + GetwholesalerNameBy_wrpid(wrpid) + " - Searching File : " + DateTime.Now); // truncate temp table before insert data int importTypeId = Getwholesaler_ID_By_wrpid(wrpid); _crudRepo = new CrudRepo(); _crudRepo.PreParsingProcess(importTypeId); FileInfo[] filesInDir = GetwholesalerPathBy_wrpid(wrpid); Console.WriteLine(" "); Console.WriteLine("***** " + filesInDir.Length + " - Files ***** "); Console.WriteLine(" "); foreach (FileInfo foundFile in filesInDir) { Console.WriteLine("*********************************"); Console.WriteLine(foundFile.Name); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + foundFile.Name + " Parsing Started : " + DateTime.Now); try { status = ProcessWholesaler(wrpid, foundFile.FullName); } catch (Exception ex) { bool send_mail = SendEmail_error(ex.ToString()); } File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + GetwholesalerNameBy_wrpid(wrpid) + " Parsing status : " + status + " : " + DateTime.Now); } if (status) { ListImportFileRows[i] = importFileRows; } if (int.Parse(ParserFile_wrpid) > 0) { i = wrpid_array.Length - 1; } } bool send = SendEmail_success(ListImportFileRows); } catch (Exception ex) { Console.WriteLine("error = " + ex.ToString()); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + ex.ToString()); bool send = SendEmail_error(ex.ToString()); // Console.ReadLine(); } return(status); }
public bool ProcessWholesaler(int wrpid, string _filepath) { var result = false; importFileRows = 0; // Console.WriteLine("Enter wrpid : " + wrpid); /// Console.Write("Enter wrpid : "); //int wrpid = int.Parse(Console.ReadLine()); // int importTypeId = Getwholesaler_ID_By_wrpid(wrpid); //Console.WriteLine("Enter import File Name of -> "+ GetwholesalerNameByID(importTypeId)); //string _fileName = Console.ReadLine(); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + _filepath); if (!File.Exists(_filepath)) { Console.WriteLine("\nFile not Exists"); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + "File not Exists "); // Console.ReadLine(); return(false); } else { File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + "File Exists "); // return false; } FileInfo fi = new FileInfo(_filepath); string _fileName = Path.GetFileNameWithoutExtension(fi.FullName); // Create backup Folder if (!System.IO.Directory.Exists(fi.DirectoryName + @"\backup")) { System.IO.Directory.CreateDirectory(fi.DirectoryName + @"\backup"); } string wholesalerFile_backup = fi.DirectoryName + @"\backup\" + _fileName + "_" + DateTime.Now.ToString("dd-MMM-yyyy hh:mm:ss ").Replace("-", "_").Replace(":", "_") + fi.Extension; // string wholesalerFile_backup = fi.DirectoryName + @"\backup\" + _fileName + fi.Extension; // Delete from backup Folder if file Exists if (File.Exists(wholesalerFile_backup)) { File.Delete(wholesalerFile_backup); } _crudRepo = new CrudRepo(); if (_crudRepo.FileParsed(_filepath, fi.LastWriteTime)) { Console.WriteLine("\n Already Parsed this File"); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + "Already Parsed this File"); //// Move file in backup Folder File.Move(_filepath, wholesalerFile_backup); // Console.ReadLine(); return(false); } if (wrpid == 7) { Console.WriteLine("Start Parsing :" + " - amerisource"); var amerisource = new AmerisourceProcessor(); var amerisourceEntries = amerisource.ProcessAmerisource(_filepath); importFileRows = amerisourceEntries.Count; if (amerisourceEntries.Any()) { result = _crudRepo.BulkAddAmerisource(amerisourceEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 143) { Console.WriteLine("Start Parsing :" + " - Anda"); var Anda = new AndaProcesor(); var AndaEntries = Anda.ProcessAnda(_filepath); importFileRows = AndaEntries.Count; if (AndaEntries.Any()) { result = _crudRepo.BulkAddAnda(AndaEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 116) { Console.WriteLine("Start Parsing :" + " - ASD"); var ASD = new ASDProcesor(); var ASDEntries = ASD.ProcessASD(_filepath); importFileRows = ASDEntries.Count; if (ASDEntries.Any()) { result = _crudRepo.BulkAddASD(ASDEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 14821) { Console.WriteLine("Start Parsing :" + " - biocare"); var biocare = new BioCareProcessor(); var biocareEntries = biocare.ProcessBioCare(_filepath); importFileRows = biocareEntries.Count; if (biocareEntries.Any()) { result = _crudRepo.BulkAddBioCare(biocareEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 9) { Console.WriteLine("Start Parsing :" + " - cardinal"); string filename = Path.GetFileName(_filepath); if (filename.Substring(0, 4) == "CSWJ") { var cardinal = new CardinalProcesor(); var cardinalEntries = cardinal.ProcessCardinal(_filepath); importFileRows = cardinalEntries.Count; if (cardinalEntries.Any()) { result = _crudRepo.BulkAddCardinal(cardinalEntries); } } else { var cardinal = new CardinalProcesorW(); var cardinalEntries = cardinal.ProcesorCardinalW(_filepath); importFileRows = cardinalEntries.Count; if (cardinalEntries.Any()) { result = _crudRepo.BulkAddCardinal_W(cardinalEntries); } } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 14695) { Console.WriteLine("Start Parsing :" + " - CardinalSPD"); var card = new CardinalSPDProcessor(); var cardEntries = card.ProcessCardinalSPD(_filepath); importFileRows = cardEntries.Count; if (cardEntries.Any()) { result = _crudRepo.BulkAddCardinalSPD(cardEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 27039) { Console.WriteLine("Start Parsing :" + " - CuraScript"); var cscr = new CuraScriptProcessor(); var cscrEntries = cscr.ProcessCuraScript(_filepath); importFileRows = cscrEntries.Count; if (cscrEntries.Any()) { result = _crudRepo.BulkAddCuraScript(cscrEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 147) { Console.WriteLine("Start Parsing :" + " - dakota"); var dakota = new DakotaProcessor(); var dakotaEntries = dakota.ProcessDakota(_filepath); importFileRows = dakotaEntries.Count; if (dakotaEntries.Any()) { result = _crudRepo.BulkAddDakota(dakotaEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 11) { Console.WriteLine("Start Parsing :" + " - HdSmith"); var hds = new HDSmithProcessor(); var hdsEntries = hds.ProcessHDSmith(_filepath); importFileRows = hdsEntries.Count; if (hdsEntries.Any()) { result = _crudRepo.BulkAddHdSmith(hdsEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 10) { Console.WriteLine("Start Parsing :" + " - Kinray"); var kinray = new KinrayProcessor(); var kinrayEntries = kinray.ProcessKinray(_filepath); importFileRows = kinrayEntries.Count; if (kinrayEntries.Any()) { result = _crudRepo.BulkAddKinray(kinrayEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 8) { Console.WriteLine("Start Parsing :" + " - Mckesson"); var mcKesson = new MckessonProcessor(); var mcKessonEntries = mcKesson.ProcessMckessons(_filepath); importFileRows = mcKessonEntries.Count; if (mcKessonEntries.Any()) { result = _crudRepo.BulkAddMCkesson(mcKessonEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 15945) { Console.WriteLine("Start Parsing :" + " - MckessonSP"); var mckp = new McKessonSPProcessor(); var mckpEntries = mckp.ProcessMcKessonSP(_filepath); importFileRows = mckpEntries.Count; if (mckpEntries.Any()) { result = _crudRepo.BulkAddMcKessonSP(mckpEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 29) { Console.WriteLine("Start Parsing :" + " - MorrisDickson"); var MorrisDickson = new MorrisDicksonProcesor(); var MorrisDicksonEntries = MorrisDickson.ProcessMorrisDickson(_filepath); importFileRows = MorrisDicksonEntries.Count; if (MorrisDicksonEntries.Any()) { result = _crudRepo.BulkAddMorrisDickson(MorrisDicksonEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 80) { Console.WriteLine("Start Parsing :" + " - NcMutual"); var ncmutual = new NcMutualProcessor(); var ncmutualEntries = ncmutual.ProcessNcMutual(_filepath); importFileRows = ncmutualEntries.Count; if (ncmutualEntries.Any()) { result = _crudRepo.BulkAddNcMutual(ncmutualEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 14691) { Console.WriteLine("Start Parsing :" + " - R&S Pharma"); var rns = new RnSProcessor(); var rnsEntries = rns.ProcessRnS(_filepath); importFileRows = rnsEntries.Count; if (rnsEntries.Any()) { result = _crudRepo.BulkAddRnS(rnsEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 6) { Console.WriteLine("Start Parsing :" + " - RDC"); var RDC = new RDCProcesor(); var RDCEntries = RDC.ProcessRDC(_filepath); importFileRows = RDCEntries.Count; if (RDCEntries.Any()) { result = _crudRepo.BulkAddRDC(RDCEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 36) { Console.WriteLine("Start Parsing :" + " - SmithDrugs"); var smiths = new SmithDrugsProcessor(); var smithDrugEntries = smiths.ProcessSmithDrugs(_filepath); importFileRows = smithDrugEntries.Count; if (smithDrugEntries.Any()) { result = _crudRepo.BulkAddSmithDrugs(smithDrugEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 57) { Console.WriteLine("Start Parsing :" + " - ValleyWholesale"); var ValleyWholesale = new ValleyWholesaleProcesor(); var ValleyWholesaleEntries = ValleyWholesale.ProcessValleyWholesale(_filepath); importFileRows = ValleyWholesaleEntries.Count; if (ValleyWholesaleEntries.Any()) { result = _crudRepo.BulkAddValleyWholesale(ValleyWholesaleEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (wrpid == 77) { Console.WriteLine("Start Parsing :" + " - ValueDrugs"); var vd = new ValueDrugsProcessor(); var valueDrugsEntries = vd.ProcessValueDrugs(_filepath); importFileRows = valueDrugsEntries.Count; if (valueDrugsEntries.Any()) { result = _crudRepo.BulkAddValueDrugs(valueDrugsEntries); } if (result) { InsertImportLog(wrpid, _filepath, importFileRows); } } if (result) { // Move file in backup Folder File.Move(_filepath, wholesalerFile_backup); Console.WriteLine("Parsing Completed Successfully"); //Console.WriteLine(importFileRows + " Rows Inserted "); File.AppendAllText(@"" + ConfigurationManager.AppSettings["reportlogfile"], Environment.NewLine + "Parsing Completed Successfully --- " + importFileRows + " Rows Inserted "); } else { Console.WriteLine("Parsing Failed"); } return(result); }
public CrudRepoTest(CrudRepo <DummyA> rep) { this.repo = rep; }
public EmployeeController() { repo = new CrudRepo(); }