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();
}
