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 HttpResponseMessage GetAcCode(string name, string Type)
{
if ((new Global()).CheckStarterService())
{
try
{
List <ACPMST> list_acpmst;
if (String.IsNullOrEmpty(name))
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == Type).Take(20).ToList();
}
else
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == Type && p.PNAME.StartsWith(name)).Take(20).ToList();
}
return(Request.CreateResponse(HttpStatusCode.OK, list_acpmst));
}
catch (Exception ex)
{
List <ACPMST> list_item = new List <ACPMST>();
ACPMST im_ = new ACPMST();
im_.PNAME = "$" + ex.Message;
list_item.Add(im_);
return(Request.CreateResponse(HttpStatusCode.OK, list_item));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ""));
}
}
public HttpResponseMessage GetParty(string name, string area)
{
bool isno = false;
if ((new Global()).CheckStarterService())
{
try
{
try
{
Int64 i = Convert.ToInt64(name.Trim());
isno = true;
}
catch
{
isno = false;
}
List <ACPMST> list_acpmst;
if (area != null)
{
if (isno)
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == "C" && p.ConsumerMob.StartsWith(name) && p.areacode == area).Take(10).ToList();
}
else
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == "C" && p.PNAME.StartsWith(name) && p.areacode == area).Take(10).ToList();
}
}
else
{
if (isno)
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == "C" && p.ConsumerMob.StartsWith(name)).Take(10).ToList();
}
else
{
list_acpmst = gbc_con.Db_acpmst.Where(p => p.PTYPE == "C" && p.PNAME.StartsWith(name)).Take(10).ToList();
}
}
return(Request.CreateResponse(HttpStatusCode.OK, list_acpmst));
}
catch (Exception ex)
{
List <ACPMST> list_item = new List <ACPMST>();
ACPMST im_ = new ACPMST();
im_.PNAME = "$" + ex.Message;
list_item.Add(im_);
return(Request.CreateResponse(HttpStatusCode.OK, list_item));
}
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ""));
}
}
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);
}
}
