public static void InsertCompProfIntoDb(CompanyProfile pro,string pathToDatabase) { using (var db = new SQLite.SQLiteConnection(pathToDatabase)) { var list2 = db.Table<CompanyInfo>().ToList<CompanyInfo>(); var list3 = db.Table<AdPara>().ToList<AdPara>(); var list4 = db.Table<AdNumDate> ().Where (x => x.Year == DateTime.Now.Year && x.Month == DateTime.Now.Month).ToList<AdNumDate> (); CompanyInfo cprof = null; if (list2.Count > 0) { cprof = list2 [0]; } else { cprof = new CompanyInfo (); } cprof.Addr1 = pro.Addr1; cprof.Addr2= pro.Addr2; cprof.Addr3 = pro.Addr3; cprof.Addr4 = pro.Addr4; cprof.CompanyName = pro.CompanyName; cprof.Fax = pro.Fax; cprof.GSTNo = pro.GSTNo; cprof.HomeCurr = pro.HomeCurr; cprof.IsInclusive = pro.IsInclusive; cprof.RegNo = pro.RegNo; cprof.SalesTaxDec = pro.SalesTaxDec; cprof.AllowDelete = pro.AllowDelete; cprof.AllowEdit = pro.AllowEdit; cprof.WCFUrl = pro.WCFUrl; cprof.SupportContat = pro.SupportContat; cprof.ShowTime = pro.ShowPrintTime; cprof.AllowClrTrxHis = pro.AllowClrTrxHis; cprof.NotEditAfterPrint = pro.NoEditAfterPrint; cprof.Tel = pro.Tel; if (list2.Count==0) db.Insert (cprof); else db.Update (cprof); AdPara apara=null; if (list3.Count == 0) { apara= new AdPara (); } else { apara = list3 [0]; } apara.Prefix = pro.Prefix; apara.RunNo = pro.RunNo; apara.Warehouse = pro.WareHouse; //new added V2 apara.CNPrefix = pro.CNPrefix; apara.CNRunNo = pro.CNRunNo; apara.DOPrefix = pro.DOPrefix; apara.DORunNo = pro.DORunNo; apara.SOPrefix = pro.SOPrefix; apara.SORunNo = pro.SORunNo; if (list3.Count == 0) { apara.ReceiptTitle = "TAX INVOICE"; db.Insert (apara); } else { db.Update (apara); } AdNumDate info = null; if (list4.Count == 0) { info = new AdNumDate (); info.Year = DateTime.Now.Year; info.Month = DateTime.Now.Month; info.RunNo = pro.RunNo; info.TrxType = "INV"; db.Insert (info); } } }
private void InsertRunoIntoDb(List<RunnoInfo> list) { string pathToDatabase = ((GlobalvarsApp)CallingActivity.Application).DATABASE_PATH; string comp =((GlobalvarsApp)CallingActivity.Application).COMPANY_CODE; string brn =((GlobalvarsApp)CallingActivity.Application).BRANCH_CODE; using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { var list2 = db.Table<AdNumDate> ().ToList<AdNumDate> (); foreach (var runinfo in list) { var found = list2.Where (x => x.Month == runinfo.Month && x.Year == runinfo.Year && x.TrxType == runinfo.Trxtype).ToList (); if (found.Count > 0) { found [0].RunNo = runinfo.RunNo; db.Update (found [0]); } else { AdNumDate num = new AdNumDate (); num.ID = -1; num.Month = runinfo.Month; num.Year = runinfo.Year; num.RunNo = runinfo.RunNo; num.TrxType = runinfo.Trxtype; num.BranchCode = brn; num.CompCode = comp; db.Insert (num); } } } if (_downloadAll) { _downloadPro = true; DownloadAllhandle.Invoke (CallingActivity, 0, "Successfully downloaded runing no."); FireEvent (EventID.DOWNLOADED_RUNNO); } else if (CallingActivity!=null) Downloadhandle.Invoke (CallingActivity, 0, "Successfully downloaded runing no."); }
public static AdNumDate GetNumDate(string pathToDatabase,DateTime trxdate,string trxtype) { AdNumDate info = null; using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { var list = db.Table<AdNumDate> ().Where (x =>x.TrxType==trxtype && x.Year == trxdate.Year && x.Month == trxdate.Month).ToList<AdNumDate> (); if (list.Count > 0) info = list [0]; else { info = new AdNumDate (); info.Year = trxdate.Year; info.Month = trxdate.Month; info.RunNo = 0; info.TrxType = trxtype; info.ID = -1; } } return info; }
// public static AdPara GetAdPara(string pathToDatabase) // { // AdPara info = null; // using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { // info = db.Table<AdPara> ().FirstOrDefault (); // } // if (info == null) { // info = new AdPara (); // } // if (string.IsNullOrEmpty (info.Prefix)) // info.Prefix = "CS"; // if (string.IsNullOrEmpty (info.PrinterName)) // info.PrinterName = "PT-II"; // return info; // } public static AdNumDate GetNumDate(string pathToDatabase,DateTime trxdate,string comp,string bran) { AdNumDate info = null; using (var db = new SQLite.SQLiteConnection (pathToDatabase)) { var list = db.Table<AdNumDate> (). Where (x =>x.TrxType=="INV" && x.Year == trxdate.Year && x.Month == trxdate.Month&&x.CompCode==comp&&x.BranchCode==bran) .ToList<AdNumDate> (); if (list.Count > 0) info = list [0]; else { info = new AdNumDate (); info.Year = trxdate.Year; info.Month = trxdate.Month; info.RunNo = 0; info.TrxType = "INV"; info.ID = -1; info.BranchCode = bran; info.CompCode = comp; } } return info; }