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 Edit(decimal Id = 0)
{
ViewBag.tit = "Edit";
ViewBag.Id = Id;
SWI.AirView.Common.SelectedList sl = new SWI.AirView.Common.SelectedList();
var Clienttypes = sl.Definations("byDefinationType", "Profile Type");
ViewBag.SelectedClientTypes = Clienttypes;
ViewBag.SelectedPClient = sl.Clients("AllVendors");
ClientsBL ud = new ClientsBL();
AD_Clients Company = ud.Single1("ById", Id.ToString());
if (Company == null)
{
TempData["msg_error"] = "Record Not Exist or You Are Not Authorize to access !";
return(RedirectToAction("All", "Client"));
}
foreach (var item in Clienttypes)
{
if (item.Text != "Company" && (item.Value == Company.ClientTypeId.ToString()))
{
return(RedirectToAction("Edit", "Client", new { Id = Id }));
}
}
return(View("Edit", Company));
}
public AD_Clients Single1(string filter, string value = null)
{
try
{
DataTable dt = cd.Get(filter, value);
AD_Clients Client = new AD_Clients();
if (dt != null && dt.Rows.Count > 0)
{
int i = 0;
Client.ClientId = int.Parse(dt.Rows[i]["ClientId"].ToString());
Client.ClientName = dt.Rows[i]["ClientName"].ToString();
Client.IsActive = bool.Parse(dt.Rows[i]["IsActive"].ToString());
// Client.Logo = dt.Rows[i]["Logo"].ToString();
Client.ClientTypeId = (dt.Columns.Contains("ClientTypeId")) == true?int.Parse(dt.Rows[i]["ClientTypeId"].ToString()) : 0;
// Client.PClientId = (dt.Columns.Contains("PClientId")) == true ? Int64.Parse(dt.Rows[i]["PClientId"].ToString()) : 0;
Client.ClientPrefix = dt.Rows[i]["ClientPrefix"].ToString();
return(Client);
}
return(null);
}
catch (Exception ex) {
return(null);
}
}
public AD_Clients Single(string filter, string value = null)
{
DataTable dt = cd.Get(filter, value);
AD_Clients Client = new AD_Clients();
if (dt.Rows.Count > 0)
{
Client.ClientId = int.Parse(dt.Rows[0]["ClientId"].ToString());
Client.ClientName = dt.Rows[0]["ClientName"].ToString();
Client.IsActive = bool.Parse(dt.Rows[0]["IsActive"].ToString());
}
return(Client);
}
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 ActionResult Edit(AD_Clients cl, List <AD_ClientContacts> con, List <AD_ClientAddress> add)
{
Response res = new Response();
string fname = string.Empty;
try
{
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = cl.ClientPrefix;
}
fname = Path.Combine(Server.MapPath("~/Content/Images/ClientLogo"), fname + "_logo." + Path.GetExtension(file.FileName));
file.SaveAs(fname);
}
}
int Id = 0;
ClientsBL rb = new ClientsBL();
cl.Logo = fname;
Id = rb.Manage("Update", cl);
dbDataTable ddt = new dbDataTable();
//DataTable dtcon = ddt.List();
//foreach (var item in con)
//{
// myDataTable.AddRow(dtcon, "Value1", item.ContactPerson, "Value2", item.Designation, "Value3", item.Gender, "Value4", item.Title, "Value5", item.ContactNo,
// "Value6", item.ContactType, "Value7", item.IsPrimary, "Value8", Id, "Value9", item.UserId, "Value10", item.RegionId, "Value11", item.CityId, "Value12", item.IsActive, "Value13", item.ReportToId, "Value14",item.ContactId);
//}
//AD_ClientContactsDL ccb = new AD_ClientContactsDL();
//AD_ClientContacts clobj = new AD_ClientContacts();
//ccb.Manage("UpdateBulk", dtcon);
DataTable dt = ddt.List();
foreach (var item in add)
{
if (item.Address != null || item.Address != "")
{
myDataTable.AddRow(dt, "Value1", item.Address, "Value2", item.Street, "Value3", item.CityId, "Value4", item.StateId, "Value5", item.CountryId,
"Value6", item.ZipCode, "Value7", item.IsHeadOffice, "Value8", Id, "Value9", item.IsActive, "Value10", item.AddressId);
}
}
AD_ClientAddressDL classaddress = new AD_ClientAddressDL();
classaddress.Manage("UpdateBulk", dt);
//res.Status = "success";
// res.Message = "save successfully";
TempData["msg_success"] = "Update successfully";
}
catch (Exception ex)
{
// res.Status = "danger";
// res.Message = ex.Message;
TempData["msg_error"] = ex.Message;
}
return(RedirectToAction("Edit", new { @Id = cl.ClientId }));
//Json(res, JsonRequestBehavior.AllowGet);
}
public ActionResult New(AD_Clients cl, List <AD_ClientContacts> con, List <AD_ClientAddress> add)
{
decimal Id = 0;
Response res = new Response();
string fname = string.Empty;
try
{
ClientsBL rb = new ClientsBL();
var List = rb.ToList("Company");
if (List.Count > 0)
{
res.Status = "danger";
res.Message = "Company Already Exist !";
return(Json(res, JsonRequestBehavior.AllowGet));
}
string Extension = "";
if (Request.Files.Count > 0)
{
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
// Checking for Internet Explorer
if (Request.Browser.Browser.ToUpper() == "IE" || Request.Browser.Browser.ToUpper() == "INTERNETEXPLORER")
{
string[] testfiles = file.FileName.Split(new char[] { '\\' });
fname = testfiles[testfiles.Length - 1];
}
else
{
fname = cl.ClientPrefix;
}
fname = Path.Combine(Server.MapPath("~/Content/Images/ClientLogo"), fname + "_logo" + Path.GetExtension(file.FileName));
file.SaveAs(fname);
Extension = Path.GetExtension(file.FileName);
}
}
cl.Logo = "/Content/Images/ClientLogo/" + cl.ClientPrefix + "_logo" + Extension;
Id = rb.Manage("Insert", cl);
dbDataTable ddt = new dbDataTable();
DataTable dtcon = ddt.List();
DataTable dt = ddt.List();
foreach (var item in add)
{
myDataTable.AddRow(dt, "Value1", item.Address, "Value2", item.Street, "Value3", item.CityId, "Value4", item.StateId, "Value5", item.CountryId,
"Value6", item.ZipCode, "Value7", item.IsHeadOffice, "Value8", Id, "Value9", item.IsActive);
}
AD_ClientAddressDL claddress = new AD_ClientAddressDL();
claddress.Manage("Insert", dt);
res.Status = "success";
res.Value = Id;
res.Message = "Save successfully";
res.Value = Id.ToString();
}
catch (Exception ex)
{
res.Status = "danger";
res.Message = ex.Message;
}
if (res.Status == "success")
{
return(Json(res, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(res, JsonRequestBehavior.AllowGet));
}
}
public int Manage(string filter, AD_Clients cl)
{
return(cd.Manage(filter, cl.ClientId, cl.ClientName, cl.IsActive, cl.Logo, cl.ClientTypeId, cl.PClientId, cl.ClientPrefix));
}
