public ActionResult Create(BranchMaster branchmaster, BranchFinnancialYearVm branchVM) { if (ModelState.IsValid) { var query = (from t in db.BranchMasters where t.BranchName == branchmaster.BranchName select t).ToList(); if (query.Count > 0) { ViewBag.SuccessMsg = "Branch name is already exist"; return(View()); } branchmaster.BranchID = objectSourceMaster.GetMaxNumberBranch(); branchmaster.BranchName = branchVM.BranchName; branchmaster.Address1 = branchVM.Address; branchmaster.AcCompanyID = branchVM.CompanyId; branchmaster.CurrencyID = branchVM.currencyId; branchmaster.CountryID = branchVM.CountryID; branchmaster.EMail = branchVM.Email; branchmaster.Website = branchVM.Website; branchmaster.City = branchVM.City; branchmaster.ContactPerson = branchVM.ContactPerson; branchmaster.Phone = branchVM.phone; db.BranchMasters.Add(branchmaster); db.SaveChanges(); AcFinancialYear acFinnancialYear = new AcFinancialYear(); acFinnancialYear.AcCompanyID = branchVM.CompanyId; acFinnancialYear.BranchID = branchmaster.BranchID; acFinnancialYear.AcFYearFrom = branchVM.FromDate; acFinnancialYear.AcFYearTo = branchVM.ToDate; var getfinancialyr = ""; if (branchVM.FromDate.Year == branchVM.ToDate.Year) { getfinancialyr = branchVM.FromDate.Year.ToString(); } else { getfinancialyr = branchVM.FromDate.Year + "-" + branchVM.ToDate.Year; } acFinnancialYear.ReferenceName = getfinancialyr; acFinnancialYear.StatusClose = false; acFinnancialYear.Lock = false; acFinnancialYear.AcFinancialYearID = objectSourceMaster.GetMaxNumberAcFinancialYear(); acFinnancialYear.UserID = Convert.ToInt32(Session["UserID"]); db.AcFinancialYears.Add(acFinnancialYear); TempData["SuccessMsg"] = "You have successfully added Branch."; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Company = new SelectList(db.AcCompanies, "AcCompanyID", "AcCompany1", branchmaster.AcCompanyID); ViewBag.CountryID = new SelectList(db.CountryMasters, "CountryID", "CountryName", branchmaster.CountryID); ViewBag.CurrencyID = new SelectList(db.CurrencyMasters, "CurrencyID", "CurrencyName", branchmaster.CurrencyID); ViewBag.DesignationID = new SelectList(db.Designations, "DesignationID", "Designation1", branchmaster.DesignationID); ViewBag.LocationID = new SelectList(db.Locations, "LocationID", "Location1", branchmaster.LocationID); return(View(branchmaster)); }