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