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