public AD_ClientContacts Single(string filter, string value = null) { try { DataTable dt = cd.Get(filter, value); AD_ClientContacts Contact = new AD_ClientContacts(); if (dt != null && dt.Rows.Count > 0) { int i = 0; Contact.ContactId = int.Parse(dt.Rows[i]["ContactId"].ToString()); Contact.ContactPerson = dt.Rows[i]["ContactPerson"].ToString(); Contact.Designation = dt.Rows[i]["Designation"].ToString(); Contact.Gender = dt.Rows[i]["Gender"].ToString(); Contact.Title = dt.Rows[i]["Title"].ToString(); Contact.ContactNo = int.Parse(dt.Rows[i]["ContactNo"].ToString()); Contact.ContactType = dt.Rows[i]["ContactType"].ToString(); Contact.IsPrimary = bool.Parse(dt.Rows[i]["IsPrimary"].ToString()); Contact.ClientId = int.Parse(dt.Rows[i]["ClientId"].ToString()); Contact.UserId = int.Parse(dt.Rows[i]["UserId"].ToString()); Contact.RegionId = int.Parse(dt.Rows[i]["RegionId"].ToString()); Contact.ContactCityId = int.Parse(dt.Rows[i]["CityId"].ToString()); Contact.IsActive = bool.Parse(dt.Rows[i]["IsActive"].ToString()); Contact.ReportToId = int.TryParse(dt.Rows[i]["ReportToId"].ToString(), out i) ? (int?)i : null; return(Contact); } return(null); } catch (Exception ex) { return(null); } }
public ActionResult Contact(int Id) { try { ViewBag.Count = 0; SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList(); ViewBag.SelectedPClient = sl.Clients("All"); ViewBag.Users = sl.Users("UserAll"); ViewBag.Regions = sl.RegionWithParent("RegionParent"); ViewBag.Cities = sl.Definations("Cities"); ViewBag.Reports = sl.ClientContacts("AllActive"); AD_ClientContactsBL con = new AD_ClientContactsBL(); AD_ClientContacts Contact = con.Single("ById", Id.ToString()); if (Id != 0) { List <AD_ClientContacts> Contacts = con.ToList("ById", Id.ToString()); if (Contacts.Count > 0) { Contact.Client = Contacts; ViewBag.Count = Contacts.Count; } } return(PartialView("~/Views/Client/_ClientContact.cshtml", Contact)); } catch (Exception ex) { return(PartialView("~/Views/Client/_ClientContact.cshtml", null)); } }
public ActionResult NewSingle(AD_Clients cl, AD_ClientContacts con, AD_ClientAddress claddress) { Response res = new Response(); try { AD_ClientContactsBL clcon = new AD_ClientContactsBL(); AD_ClientAddressBL addressbl = new AD_ClientAddressBL(); int ClientId = 0; int ContactId = 0; int AddressId = 0; if (cl.ClientId > 0 || con.ContactId > 0 || claddress.AddressId > 0) { ClientId = BL.Manage("Update", cl); ContactId = clcon.Manage("Update", con, null); AddressId = addressbl.Manage("Update", claddress); res.Status = "success"; res.Message = "update successfully"; return(Json(res, JsonRequestBehavior.AllowGet)); } else { //if (Request.Files != null && Request.Files.Count > 0) //{ // foreach (string f in Request.Files) // { // HttpPostedFileBase file = Request.Files[f]; // if (file.FileName == "") // { // cl.Logo = ""; // } // else // { // string webpath = "/Content/Images/ClientLogo/"+ cl.ClientName + file.FileName.Substring(file.FileName.LastIndexOf(".")); // file.SaveAs(Request.MapPath(webpath)); // cl.Logo = webpath; // } // } //} ClientId = BL.Manage("Insert", cl); con.ClientId = ClientId; ContactId = clcon.Manage("Insert", con, null); claddress.ClientId = ClientId; AddressId = addressbl.Manage("Insert", claddress); res.Status = "success"; res.Message = "save successfully"; return(Json(res, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { res.Status = "danger"; res.Message = ex.Message; return(Json(res, JsonRequestBehavior.AllowGet)); } }
public ActionResult NewSingle(AD_Clients cl, AD_ClientContacts con, AD_ClientAddress claddress) { Response res = new Response(); try { ClientsBL rb = new ClientsBL(); AD_ClientContactsBL clcon = new AD_ClientContactsBL(); AD_ClientAddressBL addressbl = new AD_ClientAddressBL(); int ClientId = 0; int ContactId = 0; int AddressId = 0; if (cl.ClientId > 0 || con.ContactId > 0 || claddress.AddressId > 0) { ClientId = rb.Manage("Update", cl); ContactId = clcon.Manage("Update", con, null); AddressId = addressbl.Manage("Update", claddress); res.Status = "success"; res.Message = "update successfully"; return(Json(res, JsonRequestBehavior.AllowGet)); } else { ClientId = rb.Manage("Insert", cl); con.ClientId = ClientId; ContactId = clcon.Manage("Insert", con, null); claddress.ClientId = ClientId; AddressId = addressbl.Manage("Insert", claddress); res.Status = "success"; res.Message = "save successfully"; return(Json(res, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { res.Status = "danger"; res.Message = ex.Message; return(Json(res, JsonRequestBehavior.AllowGet)); } }
public int Manage(string filter, AD_ClientContacts cl, DataTable Table) { return(cd.Manage(filter, cl.ContactId, cl.ContactPerson, cl.Designation, cl.Gender, cl.Title, cl.ContactNo, cl.ContactType, cl.IsPrimary, cl.ClientId, cl.UserId, cl.RegionId, cl.ContactCityId, cl.IsActive, cl.ReportToId, Table)); }