public HttpResponseMessage GetSaleRpt(DateTime fromdate, DateTime Todate, string pcode, string ptcode, string vrtype)
{
if ((new Global()).CheckStarterService())
{
try
{
DbConn con = new DbConn();
GBCDbConn gbc_con = new GBCDbConn();
List <VC> list_vc = gbc_con.Db_vc.ToList();
list_vc = gbc_con.Db_vc.Where(p => p.FDNAME == "SALE").ToList();
string series = "";
string name = gbc_con.Database.Connection.Database + ".dbo.";
foreach (var item in list_vc)
{
series = series + ",'" + item.SER + "'";
}
series = series.Substring(1, series.Length - 1);
series = "(" + series + ")";
List <SaleReport> list_sale = new List <SaleReport>();
list_sale = con.Database.SqlQuery <SaleReport>("EXEC Sp_PartyWiseSaleBill @FromDate={0},@ToDate={1},@IsAllSer={2},@Series={3},@PCode={4},@PtCode={5},@RegdId={6},@VrType={7},@Less={8},@GdnCode={9},@OrderBy={10},@Summary={11},@ChkDr={12},@DrCode={13},@TSelectedNode={14},@FromVr={15},@ToVr={16},@GBCDBName={17}", fromdate, Todate, true, series, pcode, ptcode, "", vrtype, false, "", "Vrdate", false, false, "", "ACC070", "", "", name).Take(30).ToList();
list_sale = list_sale.OrderByDescending(p => p.Vrdate).OrderByDescending(p => p.Vrno).Take(30).ToList();
double crTotal = 0, cashTotal = 0;
foreach (var item in list_sale)
{
item.Vrdt = item.Vrdate.ToString("dd/MM/yyyy");
if (item.VrType == "C")
{
item.cashAmt = item.NetAmt.ToString("0.00");
item.crAmt = "0.00";
cashTotal = cashTotal + item.NetAmt;
}
else
{
item.crAmt = item.NetAmt.ToString("0.00");
item.cashAmt = "0.00";
crTotal = crTotal + item.NetAmt;
}
}
SaleReport obj = new SaleReport();
obj.Vrno = "Total";
obj.cashAmt = cashTotal.ToString("0.00");
obj.crAmt = crTotal.ToString("0.00");
list_sale.Add(obj);
return(Request.CreateResponse(HttpStatusCode.OK, list_sale));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is some problem while getting information from server. Please try after some time." + ex.Message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ""));
}
}
public string UpdatePartyData(string PtCode, string Ptname, string MoNo, string Email, string Add, string Stcode = "", string CtCode = "", string area = "", string DrName = "", string DrCode = "")
{
try
{
using (GBCDbConn con = new GBCDbConn())
{
//string pcode = GenrateCode(name);
//ACPMST_temp obj = new ACPMST_temp();
ACPMST_temp obj = con.ACPMST_temp.SingleOrDefault(p => p.PtCode == PtCode);
obj.Address = Add;
obj.Email = Email;
obj.PhNo = MoNo;
obj.PtName = Ptname;
//obj.PtCode = pcode;
//obj.RegDate = DateTime.Now.Date;
//obj.DeviceId = deviceId;
obj.StCode = Stcode;
obj.CtCode = CtCode;
obj.Area = area;
// obj.FDocCode = DrCode;
//obj.FDocName = DrName;
// con.DB_Acc_Temp.Add(obj);
con.SaveChanges();
return("");
}
}
catch (Exception ex)
{
return("$" + ex.Message + ex.InnerException.Message);
}
}
public HttpResponseMessage GetMISReport(DateTime TDate)
{
if ((new Global()).CheckStarterService())
{
try
{
DbConn con = new DbConn();
GBCDbConn gbc_con = new GBCDbConn();
string name = gbc_con.Database.Connection.Database + ".dbo.";
string CurDate;
string ToDate;
if (TDate == null)
{
ToDate = DateTime.Now.Date.ToString("yyyy-MM-dd");
CurDate = DateTime.Now.Date.ToString("yyyy-MM");
}
else
{
ToDate = TDate.ToString("yyyy-MM-dd");
CurDate = TDate.ToString("yyyy-MM");
}
List <MISReport> li_MIS = con.Database.SqlQuery <MISReport>("EXEC Sp_MISReport @Curdate={0},@TDate={1},@GBCDbName={2}", CurDate, ToDate, name).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, li_MIS));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "There is some problem while getting information from server. Please try after some time." + ex.Message));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ""));
}
}
public List <OB> OrderVrNOList(string PtCode)
{
GBCDbConn gbc_con = new GBCDbConn();
List <OB> list_ord = gbc_con.Db_ob.Where(p => p.PCODE == PtCode).OrderByDescending(p => p.VRDATE).OrderByDescending(p => p.VRNO).ToList();
return(list_ord);
}
public HttpResponseMessage SaveAcpmst(string Ptype, string Pname, string area, string MobNo, string add)
{
try
{
GBCDbConn gbc_con = new GBCDbConn();
ACPMST obj = new ACPMST();
obj.PCODE = GEtPCOde(Pname);
if (Ptype == "C")
{
obj.SCODE = "AB";
}
else
{
obj.SCODE = "LB";
}
obj.PNAME = Pname;
obj.PTYPE = Ptype;
obj.areacode = area;
obj.Add1 = add;
obj.ConsumerMob = MobNo;
gbc_con.Db_acpmst.Add(obj);
gbc_con.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, obj.PCODE));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "$Error occurred while saving data " + ex.Message));
}
}
public string get_discount(string ptcode)
{
// bool isno = false;
try
{
List <ACPMST> list_acpmst;
{
ACPMST list = new ACPMST();
GBCDbConn gbc_con = new GBCDbConn();
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PCODE == ptcode).ToList();
ACPMST o = list_acpmst.Take(1).SingleOrDefault();
string discount = (o.discount).ToString();
string ConsumerMob = list.ConsumerMob;
return(discount);
}
}
}
catch (Exception ex)
{
List <ACPMST> list_item = new List <ACPMST>();
ACPMST im_ = new ACPMST();
im_.PNAME = "$" + ex.Message;
list_item.Add(im_);
// returnist_item);
}
return(" ConsumerMob");
}
public string Getallparty()
{
// bool isno = false;
try
{
List <ACPMST> list_acpmst;
{
ACPMST list = new ACPMST();
GBCDbConn gbc_con = new GBCDbConn();
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == "C").ToList();
string PNAME = list.PNAME;
string PCODE = list.PCODE;
string Add1 = list.Add1;
string ConsumerMob = list.ConsumerMob;
return(PNAME + "|" + PCODE + "|" + Add1 + "|" + ConsumerMob);
}
}
}
catch (Exception ex)
{
List <ACPMST> list_item = new List <ACPMST>();
ACPMST im_ = new ACPMST();
im_.PNAME = "$" + ex.Message;
list_item.Add(im_);
// returnist_item);
}
return(" ConsumerMob");
}
public async Task <HttpResponseMessage> Post()
{
// Check whether the POST operation is MultiPart?
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
// Prepare CustomMultipartFormDataStreamProvider in which our multipart form
// data will be loaded.
// string fileSaveLocation = HttpContext.Current.Server.MapPath("~/UploadedImage");
string fileSaveLocation = System.IO.Path.Combine(Directory.GetParent(Directory.GetParent(HttpContext.Current.Server.MapPath("")).FullName).FullName, "VrImg");
bool exists = System.IO.Directory.Exists(fileSaveLocation);
if (!exists)
{
System.IO.Directory.CreateDirectory(fileSaveLocation);
}
CustomMultipartFormDataStreamProvider provider = new CustomMultipartFormDataStreamProvider(fileSaveLocation);
List <string> files = new List <string>();
try
{
// Read all contents of multipart message into CustomMultipartFormDataStreamProvider.
await Request.Content.ReadAsMultipartAsync(provider);
string name = "";
foreach (MultipartFileData file in provider.FileData)
{
files.Add(Path.GetFileName(file.LocalFileName));
name = file.LocalFileName;
}
if (name != "" && name.Contains("."))
{
string vrno = Path.GetFileName(name).Split('.')[0];
GBCDbConn gbc_con = new GBCDbConn();
OB obj = gbc_con.Db_ob.SingleOrDefault(p => p.VRNO == vrno);
obj.PresImg = Path.GetFileName(name);
gbc_con.SaveChanges();
}
// Send OK Response along with saved file names to the client.
return(Request.CreateResponse(HttpStatusCode.OK, files));
}
catch (System.Exception e)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e));
}
}
public HttpResponseMessage Getallparty(string Stcode, string name)
{
GBCDbConn con = new GBCDbConn();
try
{
List <ACPMST> list_party = con.Db_acpmst.Where(p => p.PTYPE == "C").ToList();
return(Request.CreateResponse(HttpStatusCode.OK, list_party));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, ex.Message));
}
}
public string checkparty(string PtCode)
{
try
{
GBCDbConn con = new GBCDbConn();
ACPMST obj1 = con.Db_acpmst.SingleOrDefault(p => p.PCODE == PtCode);
ACPMST_temp obj_C = con.ACPMST_temp.SingleOrDefault(p => p.PtCode == PtCode);
if (obj1 == null)
{
if (obj_C == null)
{
return("0");
}
else
{
GBCCon con1 = new GBCCon();
ServiceReg obj = con1.db_SerReg.SingleOrDefault(p => p.Pcode == obj_C.PCODE);
if (obj == null)
{
return(obj_C.ServicePath + "|" + "" + "|" + "" + "|" + obj_C.PtName + "|" + obj_C.PtCode + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + "|" + obj_C.PREPTCODE + "|");
}
else
{
return(obj_C.ServicePath + "|" + obj.Name + "|" + obj.Pcode + "|" + obj_C.PtName + "|" + obj_C.PtCode + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + "|" + obj_C.PREPTCODE + "|");
}
}
}
else
{
GBCCon con1 = new GBCCon();
ServiceReg obj = con1.db_SerReg.SingleOrDefault(p => p.Pcode == obj_C.PCODE);
if (obj == null)
{
return(obj_C.ServicePath + "|" + "" + "|" + "" + "|" + obj_C.PtName + "|" + obj1.PCODE + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + "|" + "|" + obj_C.PREPTCODE + "|");
}
else
{
return(obj_C.ServicePath + "|" + obj.Name + "|" + obj.Pcode + "|" + obj_C.PtName + "|" + obj1.PCODE + "|" + obj_C.PhNo + "|" + obj_C.Email + "|" + obj_C.Address + "|" + obj_C.DeviceId + "|" + obj_C.StCode + "|" + obj_C.CtCode + "|" + obj_C.Area + "|" + "|" + "|" + obj_C.PREPTCODE + "|");
//return obj_C.ServicePath + "|" + obj.Name + "|" + obj.Pcode + "|" + obj1.ConsumerMob + "|";
}
}
}
catch (Exception ex)
{
return("$" + ex.Message);
}
}
public string getDataFromRegCode1(string code)
{
GBCDbConn gbc_con = new GBCDbConn();
List <ACPMST_temp> obj = gbc_con.ACPMST_temp.Where(p => p.PtCode == code).ToList();
if (obj.Count != 0)
{
ACPMST_temp o = obj.Take(1).SingleOrDefault();
return(o.PtName + "<|>" + o.Address + "<|>" + o.PtCode + "<|>" + o.PhNo);
}
else
{
return("");
}
}
public string getDataFromMobno(string MobNo)
{
//GBCCon gbc_con = new GBCCon();
GBCDbConn gbc_con = new GBCDbConn();
List <ACPMST_temp> obj = gbc_con.ACPMST_temp.Where(p => p.PhNo == MobNo).ToList();
if (obj.Count != 0)
{
ACPMST_temp o = obj.Take(1).SingleOrDefault();
return(o.PtName + "<|>" + o.Address + "<|>" + o.PtCode);
}
else
{
return("");
}
}
public string CheckNo(string Mo)
{
try
{
using (GBCDbConn con = new GBCDbConn())
{
List <ACPMST_temp> obj = con.ACPMST_temp.Where(p => p.PhNo == Mo).ToList();
if (obj.Count == 0)
{
return("OK");
}
return("@");
}
}
catch (Exception ex)
{
return("$" + ex.Message + ex.InnerException.Message);;
}
}
public string Getldgbal(string pcode)
{
try
{
Global obj_global = new Global();
List <string> ldgBal = gbc_con.Database.SqlQuery <string>("select dbo.ufnGetLdgBal({0})", pcode).ToList();
GBCDbConn GbcCon = new GBCDbConn();
string name = GbcCon.Database.Connection.Database + ".dbo.";
//string opBal = GetOpBal(pcode, obj_global.ACYR_START_DATE(DateTime.Now.Date), name).ToString().Trim().Replace("Dr","").Replace("Cr","");
string ldgBAl = ldgBal[0].Trim().Replace("Dr", "").Replace("Cr", "");
ldgBAl = (ldgBAl == "Nil") ? "0" : ldgBAl;
double val = Math.Abs(Convert.ToDouble(ldgBAl));
string result = (val > 0) ? val + "Dr" : val + "Cr";
return(result);
}
catch
{
return("0.00");
}
}
public string RegisterCustmoer(string name, string Add, string email, string phone, string Pass, string AppType, string PCODE, string Stcode = "", string CtCode = "", string area = "", string deviceId = "", string DrName = "", string DrCode = "")
{
try
{
using (GBCDbConn con = new GBCDbConn())
{
string pcode = GenrateCode(name);
ACPMST_temp obj = new ACPMST_temp();
obj.Address = Add;
obj.Email = email;
obj.PhNo = phone;
obj.PtName = name;
obj.PtCode = pcode;
obj.RegDate = DateTime.Now.Date;
obj.DeviceId = deviceId;
obj.StCode = Stcode;
obj.CtCode = CtCode;
obj.Area = area;
obj.PCODE = PCODE;
// obj.FDocCode = DrCode;
//obj.FDocName = DrName;
con.ACPMST_temp.Add(obj);
con.SaveChanges();
string msg = "Welcome To TiaER@App!\n Your UserId/Registration Code :" + pcode;
if (AppType == "$")
{
msg = "Welcome!\n Your UserId/Registration Code :" + pcode;
}
// GetSMSUrl(phone, msg, AppType, PCODE);
return(pcode);
}
}
catch (Exception ex)
{
return("$" + ex.Message + ex.InnerException.Message);
}
}
public List <PartyLdgr> GetPartyLedger(string pcode, DateTime frmdate, DateTime todate, bool IsOPBalInclude, bool IsSummary)
{
if ((new Global()).CheckStarterService())
{
try
{
Global obj_global = new Global();
if (frmdate == null)
{
frmdate = obj_global.ACYR_START_DATE(DateTime.Now.Date);
}
if (todate == null)
{
todate = obj_global.ACYR_END_DATE(DateTime.Now.Date);
}
double? opBal;
double? TDrAmt = 0;
double? TCrAmt = 0;
double? DrAmt = 0;
double? CrAmt = 0;
double? Bal = 0;
GBCDbConn GbcCon = new GBCDbConn();
string name = GbcCon.Database.Connection.Database + ".dbo.";
//PartyLdgr obj_Party = new PartyLdgr();
////get op balance
name = name.Replace(obj_global.ACYR_START_DATE(DateTime.Now.Date).Year.ToString().Trim(), obj_global.ACYR_START_DATE(Convert.ToDateTime(frmdate)).Year.ToString().Trim());
if (IsOPBalInclude)
{
opBal = GetOpBal(pcode, frmdate, name);
if (opBal < 0)
{
TCrAmt = opBal * -1;
}
else
{
TDrAmt = opBal;
}
}
else
{
opBal = 0;
TCrAmt = 0;
TDrAmt = 0;
}
//get party ledger
string SQL = objRpt.ShowLedgerSummary_Query(false, true, 0, 0, "", false, "", "General Ledger", "", "", "'" + pcode + "'", name, frmdate.ToString("dd/MM/yyyy"), todate.ToString("dd/MM/yyyy"), "All", "");
List <PartyLdgr> list_partyLdgr = new List <PartyLdgr>();
List <PartyLedger> list_partyLdgr1;
list_partyLdgr1 = gbc_con.Database.SqlQuery <PartyLedger>(SQL).ToList();
double?Opbal = 0;
double?balance = 0;
string AmtType;
for (int i = 0; i <= list_partyLdgr1.Count - 1; i++)
{
if (i == 0)
{
Opbal = list_partyLdgr1[i].OPBalance;
}
if (i != 0)
{
PartyLdgr obj = new PartyLdgr();
obj.Description = "";
string dt = (list_partyLdgr1[i].Mdate == null) ? "" : list_partyLdgr1[i].Mdate;
string Line1 = "";
if (dt != "")
{
string[] SplStr = dt.Split('-');
dt = dt.Substring(0, 3) + "-" + SplStr[1].ToString();
}
string InsStr = (list_partyLdgr1[i].Insno == "") ? "" : list_partyLdgr1[i].InsType + " No." + list_partyLdgr1[i].Insno + " Dt." + list_partyLdgr1[i].InsDate;
Line1 = list_partyLdgr1[i].Name;
Line1 = Line1 + " " + list_partyLdgr1[i].Narr1 + " " + list_partyLdgr1[i].Narr2 + " " + InsStr;
obj.Description = Line1;
obj.dramt = (list_partyLdgr1[i].Debit == null) ? 0 : list_partyLdgr1[i].Debit;
DrAmt = obj.dramt;
TDrAmt = TDrAmt + DrAmt;
obj.cramt = (list_partyLdgr1[i].Credit == null) ? 0 : list_partyLdgr1[i].Credit;
CrAmt = obj.cramt;
TCrAmt = TCrAmt + CrAmt;
if (TCrAmt < TDrAmt)
{
Bal = TDrAmt - TCrAmt;
AmtType = " Dr";
}
else
{
Bal = TCrAmt - TDrAmt;
AmtType = " Cr";
}
obj.Dt = dt;
obj.Balance = Bal;
balance = obj.Balance;
list_partyLdgr.Add(obj);
}
}
PartyLdgr obj_last = new PartyLdgr();
obj_last.Description = "Total";
obj_last.cramt = TCrAmt;
obj_last.dramt = TDrAmt;
obj_last.Balance = balance;
obj_last.OPBalance = Opbal;
list_partyLdgr.Add(obj_last);
return(list_partyLdgr);
}
catch (Exception ex)
{
List <PartyLdgr> list_partyLdgr = new List <PartyLdgr>();
PartyLdgr obj = new PartyLdgr();
obj.Error = "1";
obj.Description = ex.Message;
list_partyLdgr.Add(obj);
return(list_partyLdgr);
}
}
else
{
return(null);
}
}
public HttpResponseMessage GetOrdDataOnVrno(string VrNo)
{
try
{
GBCDbConn GbcCon = new GBCDbConn();
string GBCDBname = GbcCon.Database.Connection.Database + ".dbo.";
Global objGBL = new Global();
OB ordObj = gbc_con.Db_ob.SingleOrDefault(p => p.VRNO == VrNo);
Order obj_ord = new Order();
if (ordObj != null)
{
obj_ord.NameP = ordObj.NameP;
obj_ord.TotalAmt = ordObj.ORAMT.ToString();
obj_ord.vrdate = Convert.ToDateTime(ordObj.VRDATE).ToString("dd/MM/yyyy");
obj_ord.vrno = ordObj.VRNO;
obj_ord.imgName = ordObj.PresImg;
List <ItemMaster> li_Oi = new List <ItemMaster>();
List <OI> OI = gbc_con.Db_OI.Where(p => p.VRNO == VrNo).ToList();
foreach (var oi_item in OI)
{
try
{
ItemMaster obj_oi = new ItemMaster();
try
{
IM IMObj = gbc_con.Db_itm.SingleOrDefault(p => p.ICODE == oi_item.ICODE);
if (IMObj != null)
{
obj_oi.INAME = IMObj.INAME;
obj_oi.packing = IMObj.packing;
obj_oi.WRate = (oi_item.ORDRATE * IMObj.PURSIZE).ToString();
DataRow dr = objGBL.getDataRow(false, "SELECT GNAME FROM " + GBCDBname + "GM WHERE isnull( GCODE,'')='" + (IMObj.GCODE == null ? "" : IMObj.GCODE) + "' ");
if (dr != null)
{
obj_oi.GNAme = dr["GNAME"].ToString();
}
}
}
catch
{
obj_oi.INAME = oi_item.ICODE;
}
obj_oi.Qty = oi_item.ORDERQTY.ToString();
obj_oi.free = oi_item.FREEQTY.ToString();
obj_oi.WQty = oi_item.ORDERWQTY.ToString();
obj_oi.Wfree = oi_item.FREEWQTY.ToString();
obj_oi.Rate = oi_item.ORDRATE.ToString();
obj_oi.ICODE = oi_item.ICODE;
obj_oi.Mrp = oi_item.ORDMRP.ToString();
li_Oi.Add(obj_oi);
}
catch
{
}
}
obj_ord.items = li_Oi;
}
return(Request.CreateResponse(HttpStatusCode.OK, obj_ord));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.NotFound, "Error Occurred While Getting Data. " + ex.Message));
}
}
