public ActionResult GetBranchById(int ID)
{
string operation = Session["Operation"].ToString();
ButtonVisiblity(operation);
Mst_Branch tblBranch = dd._context.Mst_Branch.Where(x => x.ID == ID && x.Status == 1).FirstOrDefault();
BranchViewModel branch = new BranchViewModel();
branch.BranchName = tblBranch.BranchName;
branch.BranchCode = tblBranch.BranchCode;
branch.BranchType = tblBranch.BranchType;
branch.DateInception = tblBranch.InceptionDate.ToShortDateString();
branch.RentPeriodAgreed = Convert.ToDateTime(tblBranch.RentPeriodAgreed).ToShortDateString();
branch.DateWEF = Convert.ToDateTime(tblBranch.DateWEF).ToShortDateString();
branch.Address = tblBranch.Address;
branch.Pincode = tblBranch.Pincode;
branch.ContactPerson = tblBranch.ContactPerson;
branch.MobileNo = tblBranch.MobileNo;
branch.InTime = tblBranch.InTime;
branch.OutTime = tblBranch.OutTime;
branch.operation = operation;
branch.Status = (short)tblBranch.Status;
//ViewBag.PincodeList = new SelectList(dd._context.Mst_PinCode.ToList(), "Pc_Id", "Pc_Desc");
var pincodelist = dd._context.Mst_PinCode.Select(x => new
{
PcId = x.Pc_Id,
PincodeWithArea = x.Pc_Desc + "(" + x.Pc_AreaName + ")"
}).ToList();
ViewBag.PincodeList = new SelectList(pincodelist, "PcId", "PincodeWithArea");
var pincodemodel = dd._context.Mst_PinCode.Where(x => x.Pc_Id == branch.Pincode).Select(x => new PincodeViewModel {
CityId = x.Pc_CityId, ZoneId = x.Pc_ZoneId, AreaName = x.Pc_AreaName
}).FirstOrDefault();
var ZoneName = dd._context.Mst_Zone.Where(x => x.Zne_No == pincodemodel.ZoneId).Select(x => x.Zne_Desc).FirstOrDefault();
var cityname = dd._context.Mst_City.Where(x => x.Ct_Id == pincodemodel.CityId).Select(x => new CityViewModel {
CityName = x.Ct_Desc, StateId = (int)x.Ct_StateId
}).FirstOrDefault();
var statename = dd._context.Mst_State.Where(x => x.St_Id == cityname.StateId).Select(x => x.St_Desc).FirstOrDefault();
branch.AreaName = pincodemodel.AreaName;
branch.ZoneName = ZoneName;
branch.CityName = cityname.CityName;
branch.StateName = statename;
return(View("Branch", branch));
}
//[ValidateAntiForgeryToken]
public JsonResult CreateEdit(BranchViewModel branch)
{
branch.CreatedBy = Convert.ToInt32(Session["UserLoginId"]);
branch.UpdatedBy = Convert.ToInt32(Session["UserLoginId"]);
Mst_Branch tblBranch = new Mst_Branch();
try
{
if (branch.ID <= 0)
{
var data = dd._context.Mst_Branch.Where(u => u.BranchName == branch.BranchName && u.Status == 1).Select(x => x.BranchName).FirstOrDefault();
if (data != null)
{
ModelState.AddModelError("BranchName", "Branch Name Already Exists");
return(Json(branch));
}
tblBranch.BranchName = branch.BranchName;
tblBranch.BranchCode = branch.BranchCode;
tblBranch.BranchType = branch.BranchType;
tblBranch.InceptionDate = Convert.ToDateTime(branch.DateInception);
if (tblBranch.BranchType == 2)
{
tblBranch.RentPeriodAgreed = null;
}
else
{
tblBranch.RentPeriodAgreed = Convert.ToDateTime(branch.RentPeriodAgreed);
}
tblBranch.DateWEF = Convert.ToDateTime(branch.DateWEF);
tblBranch.Address = branch.Address;
tblBranch.Pincode = branch.Pincode;
tblBranch.ContactPerson = branch.ContactPerson;
tblBranch.MobileNo = branch.MobileNo;
tblBranch.InTime = branch.InTime;
tblBranch.OutTime = branch.OutTime;
tblBranch.Status = branch.Status;
tblBranch.RecordCreated = DateTime.Now;
tblBranch.RecordCreatedBy = branch.CreatedBy;
tblBranch.RecordUpdated = DateTime.Now;
tblBranch.RecordUpdatedBy = branch.UpdatedBy;
dd._context.Mst_Branch.Add(tblBranch);
}
else
{
tblBranch = dd._context.Mst_Branch.Where(x => x.ID == branch.ID && x.Status == 1).FirstOrDefault();
// first inactive record then insert active record
if (tblBranch.InceptionDate != Convert.ToDateTime(branch.DateInception))
{
tblBranch.Status = 2;
dd._context.SaveChanges();
tblBranch = new Mst_Branch();
tblBranch.BranchName = branch.BranchName;
tblBranch.BranchCode = branch.BranchCode;
tblBranch.BranchType = branch.BranchType;
tblBranch.InceptionDate = Convert.ToDateTime(branch.DateInception);
if (tblBranch.BranchType == 2)
{
tblBranch.RentPeriodAgreed = null;
}
else
{
tblBranch.RentPeriodAgreed = Convert.ToDateTime(branch.RentPeriodAgreed);
}
//tblBranch.DateWEF = Convert.ToDateTime(branch.DateWEF);
tblBranch.Address = branch.Address;
tblBranch.Pincode = branch.Pincode;
tblBranch.ContactPerson = branch.ContactPerson;
tblBranch.MobileNo = branch.MobileNo;
tblBranch.InTime = branch.InTime;
tblBranch.OutTime = branch.OutTime;
tblBranch.Status = branch.Status;
tblBranch.RecordUpdated = DateTime.Now;
tblBranch.RecordUpdatedBy = branch.UpdatedBy;
tblBranch.RecordCreated = DateTime.Now;
tblBranch.RecordCreatedBy = branch.CreatedBy;
dd._context.Mst_Branch.Add(tblBranch);
}
else
{
tblBranch.BranchName = branch.BranchName;
tblBranch.BranchCode = branch.BranchCode;
tblBranch.BranchType = branch.BranchType;
tblBranch.InceptionDate = Convert.ToDateTime(branch.DateInception);
if (tblBranch.BranchType == 2)
{
tblBranch.RentPeriodAgreed = null;
}
else
{
tblBranch.RentPeriodAgreed = Convert.ToDateTime(branch.RentPeriodAgreed);
}
//tblBranch.DateWEF = Convert.ToDateTime(branch.DateWEF);
tblBranch.Address = branch.Address;
tblBranch.Pincode = branch.Pincode;
tblBranch.ContactPerson = branch.ContactPerson;
tblBranch.MobileNo = branch.MobileNo;
tblBranch.InTime = branch.InTime;
tblBranch.OutTime = branch.OutTime;
tblBranch.Status = branch.Status;
tblBranch.RecordUpdated = DateTime.Now;
tblBranch.RecordUpdatedBy = branch.UpdatedBy;
}
}
dd._context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(Json(branch));
}