public ActionResult SectionMaster(ParentViewModel model)
{
Jct_Asset_Dep_Section obj = new Jct_Asset_Dep_Section();
obj.CompanyCode = model.Jct_Asset_Dep_Section.CompanyCode;
obj.Created_By = "A-00251";
obj.Created_Hostname = System.Environment.MachineName;
obj.Created_On = System.DateTime.Now;
obj.Effe_From = System.DateTime.Today;
obj.Effe_To = System.DateTime.MaxValue;
obj.Ip_Address = ("::1" == System.Web.HttpContext.Current.Request.UserHostAddress) ? "localhost" : System.Web.HttpContext.Current.Request.UserHostAddress;
obj.SectionCode = model.Jct_Asset_Dep_Section.SectionName.Substring(0, 3);
obj.SectionName = model.Jct_Asset_Dep_Section.SectionName;
obj.Sub_SectionCode = model.Jct_Asset_Dep_Section.Sub_SectionName.Substring(0, 3);
obj.Sub_SectionName = model.Jct_Asset_Dep_Section.Sub_SectionName;
obj.SubUnitCode = model.Jct_Asset_Dep_Section.SubUnitCode;
obj.UnitCode = model.Jct_Asset_Dep_Section.UnitCode;
SqlConnection con = DBConnection.getConnection();
string sql = "Jct_Asset_Dep_Section_Insert";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CompanyCode", obj.CompanyCode);
cmd.Parameters.AddWithValue("@UnitCode", obj.UnitCode);
cmd.Parameters.AddWithValue("@SubUnitCode", obj.SubUnitCode);
cmd.Parameters.AddWithValue("@SectionCode", obj.SectionCode);
cmd.Parameters.AddWithValue("@SectionName", obj.SectionName);
cmd.Parameters.AddWithValue("@Sub_SectionCode", obj.Sub_SectionCode);
cmd.Parameters.AddWithValue("@Sub_SectionName", obj.Sub_SectionName);
cmd.Parameters.AddWithValue("@Effe_From", obj.Effe_From);
cmd.Parameters.AddWithValue("@Effe_To", obj.Effe_To);
cmd.Parameters.AddWithValue("@Created_By", obj.Created_By);
//cmd.Parameters.AddWithValue("@11", obj.Created_On);
cmd.Parameters.AddWithValue("@Created_Hostname", obj.Created_Hostname);
cmd.Parameters.AddWithValue("@Ip_Address", obj.Ip_Address);
cmd.ExecuteNonQuery();
con.Close();
return(RedirectToAction("SectionMaster", "SectionMaster", null));
}
public ParentViewModel()
{
Jct_Asset_Dep_Unit = new Jct_Asset_Dep_Unit();
Jct_Asset_Dep_Company = new Jct_Asset_Dep_Company();
Jct_Asset_Dep_SubUnit = new Jct_Asset_Dep_SubUnit();
Jct_Asset_Dep_Book = new Jct_Asset_Dep_Book();
Jct_Asset_Dep_Group = new Jct_Asset_Dep_Group();
Jct_Asset_Dep_SubGroup = new Jct_Asset_Dep_SubGroup();
Jct_Asset_Dep_CompanyActRate = new Jct_Asset_Dep_CompanyActRate();
Jct_Asset_Dep_Bill_Info = new Jct_Asset_Dep_Bill_Info();
Jct_Asset_Dep_Asset = new Jct_Asset_Dep_Asset();
Jct_Asset_Dep_Book_AccountingYear = new Jct_Asset_Dep_Book_AccountingYear();
Jct_Asset_Dep_Section = new Jct_Asset_Dep_Section();
FinancialYearMasterModel = new FinancialYearMasterModel();
Jct_Asset_Dep_Method = new Jct_Asset_Dep_Method();
Jct_Asset_Dep_Insurance = new Jct_Asset_Dep_Insurance();
Jct_Asset_Dep_Sub_Asset = new Jct_Asset_Dep_Sub_Asset();
Jct_Asset_Dep_Shift = new Jct_Asset_Dep_Shift();
SLMProspectiveCalculatorModel = new SLMProspectiveCalculatorModel();
DropDownViewModel = new DropDownViewModel();
ReportViewModel = new ReportViewModel();
}
