public AD_ClientAddress Single(string filter, string value = null) { try { DataTable dt = cd.Get(filter, value); AD_ClientAddress Addres = new AD_ClientAddress(); if (dt != null && dt.Rows.Count > 0) { int i = 0; Addres.AddressId = int.Parse(dt.Rows[i]["AddressId"].ToString()); Addres.Address = dt.Rows[i]["Address"].ToString(); Addres.Street = dt.Rows[i]["Street"].ToString(); Addres.AddressCityId = int.Parse(dt.Rows[i]["CityId"].ToString()); Addres.StateId = int.Parse(dt.Rows[i]["StateId"].ToString()); Addres.CountryId = int.Parse(dt.Rows[i]["CountryId"].ToString()); Addres.ZipCode = int.Parse(dt.Rows[i]["ZipCode"].ToString()); Addres.IsHeadOffice = bool.Parse(dt.Rows[i]["IsHeadOffice"].ToString()); Addres.ClientId = int.Parse(dt.Rows[i]["ClientId"].ToString()); Addres.IsActive = bool.Parse(dt.Rows[i]["IsActive"].ToString()); return(Addres); } return(null); } catch (Exception) { return(null); } }
public ActionResult Address(int Id) { try { ViewBag.Count = 0; SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList(); ViewBag.SelectedCountry = sl.Definations("Countries"); ViewBag.SelectedState = sl.Definations("States"); ViewBag.Cities = sl.Definations("Cities"); ViewBag.SelectedPClient = sl.Clients("All"); AD_ClientAddressBL adress = new AD_ClientAddressBL(); AD_ClientAddress Address = adress.Single("ById", Id.ToString()); if (Id != 0) { List <AD_ClientAddress> Addresses = adress.ToList("ById", Id.ToString()); if (Addresses.Count > 0) { Address.Addresses = Addresses; ViewBag.Count = Addresses.Count; } } return(PartialView("~/Views/Client/_ClientAddress.cshtml", Address)); } catch (Exception ex) { return(PartialView("~/Views/Client/_ClientAddress.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_ClientAddress cl) { return(cd.Manage(filter, cl.AddressId, cl.Address, cl.Street, cl.AddressCityId, cl.StateId, cl.CountryId, cl.ZipCode, cl.IsHeadOffice, cl.ClientId, cl.IsActive)); }