public JsonResult GetShiftDetails(string SubGroupCode, string SubGroup_ShiftCode, string SubGroupMethod) { SqlConnection con = DBConnection.getConnection(); Jct_Asset_Dep_Asset model = new Jct_Asset_Dep_Asset(); string sql = "Jct_Asset_Dep_CompanyActRate_Join_Subgroup"; SqlCommand cmd = new SqlCommand(sql, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SubGroupCode", SubGroupCode); cmd.Parameters.AddWithValue("@SubGroup_ShiftCode", SubGroup_ShiftCode); cmd.Parameters.AddWithValue("@SubGroupMethod", SubGroupMethod); SqlDataReader read = cmd.ExecuteReader(); if (read.HasRows) { while (read.Read()) { model.GroupLife = float.Parse(read["Group_life"].ToString()); model.EstimatedLife = float.Parse(read["SubGroup_EstimatedLife"].ToString()); } } read.Close(); con.Close(); return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult AssetList(int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { SqlConnection con = DBConnection.getConnection(); string sql = "Jct_Asset_Dep_Acquisition_Asset_Fetch"; SqlCommand cmd = new SqlCommand(sql, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; List <Jct_Asset_Dep_Asset> list = new List <Jct_Asset_Dep_Asset>(); SqlDataReader read = cmd.ExecuteReader(); if (read.HasRows) { while (read.Read()) { Jct_Asset_Dep_Asset model = new Jct_Asset_Dep_Asset(); model.TransNo = Convert.ToInt32(read["TransNo"].ToString()); model.AssetCode = read["AssetCode"].ToString(); model.AssetName = read["AssetName"].ToString(); model.GroupCode = read["GroupCode"].ToString(); model.AcquiredAs = read["AcquiredAs"].ToString(); model.Put_In_Use_Date = Convert.ToDateTime(read["Put_In_Use_Date"].ToString()); model.Quantity = Convert.ToInt32(read["Quantity"].ToString()); list.Add(model); } var querableList = list.AsQueryable(); int temp = querableList.Count(); if (string.IsNullOrEmpty(jtSorting) || jtSorting.Equals("AssetCode ASC")) { querableList = querableList.OrderBy(p => p.AssetCode); } querableList = querableList.Skip(jtStartIndex).Take(jtPageSize); list = querableList.ToList(); return(Json(new { Result = "OK", Records = list, TotalRecordCount = temp }, JsonRequestBehavior.AllowGet)); } return(Json(new { Result = "OK", Records = list, TotalRecordCount = list.Count }, JsonRequestBehavior.AllowGet)); }
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(); }
public ActionResult AssetMaster(ParentViewModel model) { Jct_Asset_Dep_Asset obj = new Jct_Asset_Dep_Asset(); Jct_Asset_Dep_Sub_Asset obj1 = new Jct_Asset_Dep_Sub_Asset(); if (model.Jct_Asset_Dep_Asset.AcquiredType == "Dependent-Child" || model.Jct_Asset_Dep_Asset.AcquiredType == "Independent-Child") { obj1.CompanyCode = model.Jct_Asset_Dep_Asset.CompanyCode; obj1.UnitCode = model.Jct_Asset_Dep_Asset.UnitCode; obj1.SubUnitCode = model.Jct_Asset_Dep_Asset.SubUnitCode; obj1.SectionCode = model.Jct_Asset_Dep_Asset.SectionCode; obj1.SubSectionCode = model.Jct_Asset_Dep_Asset.SubSectionCode; obj1.GroupCode = model.Jct_Asset_Dep_Asset.SubGroup_Code; obj1.SubGroup_Code = model.Jct_Asset_Dep_Asset.SubGroup_Code; obj1.AcquiredAs = model.Jct_Asset_Dep_Asset.AcquiredAs; obj1.AcquiredType = model.Jct_Asset_Dep_Asset.AcquiredType; obj1.Quantity = model.Jct_Asset_Dep_Asset.Quantity; obj1.SalvageValue = model.Jct_Asset_Dep_Asset.SalvageValue; obj1.SubArea = model.Jct_Asset_Dep_Asset.SubArea; obj1.ITBook = model.Jct_Asset_Dep_Asset.ITBook; obj1.COMBook = model.Jct_Asset_Dep_Asset.COMBook; obj1.Tangiable = model.Jct_Asset_Dep_Asset.Tangiable; obj1.AssetCode = model.Jct_Asset_Dep_Asset.AssetCode; obj1.Sub_AssetCode = model.Jct_Asset_Dep_Sub_Asset.Sub_AssetCode; obj1.Sub_AssetName = model.Jct_Asset_Dep_Sub_Asset.Sub_AssetName; obj1.PurchaseDate = model.Jct_Asset_Dep_Asset.PurchaseDate; obj1.Put_In_Use_Date = model.Jct_Asset_Dep_Asset.Put_In_Use_Date; obj1.Amount = model.Jct_Asset_Dep_Asset.Amount; obj1.Asset_Life = model.Jct_Asset_Dep_Asset.Asset_Life; obj.SubGroup_ShiftCode = model.Jct_Asset_Dep_Asset.SubGroup_ShiftCode; obj1.Method_Code = model.Jct_Asset_Dep_Asset.Method_Code; obj1.Effe_From = model.Jct_Asset_Dep_Asset.Effe_From; obj1.Effe_To = model.Jct_Asset_Dep_Asset.Effe_To; obj1.Created_By = model.Jct_Asset_Dep_Asset.Created_By; obj1.Created_On = model.Jct_Asset_Dep_Asset.Created_On; obj1.Created_Hostname = model.Jct_Asset_Dep_Asset.Created_Hostname; obj1.Ip_Address = model.Jct_Asset_Dep_Asset.Tangiable; obj1.Effe_From = System.DateTime.Today; obj1.Effe_To = model.Jct_Asset_Dep_Asset.Effe_To; obj1.Created_By = HttpContext.User.Identity.Name; obj1.Created_On = System.DateTime.Now; obj1.Created_Hostname = System.Environment.MachineName; obj1.Ip_Address = ("::1" == System.Web.HttpContext.Current.Request.UserHostAddress) ? "localhost" : System.Web.HttpContext.Current.Request.UserHostAddress; SqlConnection con1 = DBConnection.getConnection(); string sql1 = "Jct_Asset_Dep_SubAsset_Insert"; SqlCommand cmd1 = new SqlCommand(sql1, con1); cmd1.CommandType = System.Data.CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@CompanyCode", obj1.CompanyCode); cmd1.Parameters.AddWithValue("@UnitCode", obj1.UnitCode); cmd1.Parameters.AddWithValue("@SubUnitCode", obj1.SubUnitCode); cmd1.Parameters.AddWithValue("@SectionCode", obj1.SectionCode); cmd1.Parameters.AddWithValue("@SubSectionCode", obj1.SubSectionCode); cmd1.Parameters.AddWithValue("@Group_Code", obj1.GroupCode); cmd1.Parameters.AddWithValue("@SubGroup_Code ", obj1.SubGroup_Code); cmd1.Parameters.AddWithValue("@AcquiredAs", obj1.AcquiredAs); cmd1.Parameters.AddWithValue("@AcquiredType", obj1.AcquiredType); cmd1.Parameters.AddWithValue("@Quantity", obj1.Quantity); cmd1.Parameters.AddWithValue("@SalvageValue", obj1.SalvageValue); cmd1.Parameters.AddWithValue("@SubArea", obj1.SubArea); cmd1.Parameters.AddWithValue("@ITBook", "ITB-1"); cmd1.Parameters.AddWithValue("@COMBook", "COM-0"); cmd1.Parameters.AddWithValue("@AssetCode", obj1.AssetCode); cmd1.Parameters.AddWithValue("@Sub_AssetCode", obj1.AssetCode); cmd1.Parameters.AddWithValue("@Sub_AssetName", obj1.AssetCode); cmd1.Parameters.AddWithValue("@PurchaseDate", obj1.PurchaseDate); cmd1.Parameters.AddWithValue("@Put_In_Use_Date", obj1.Put_In_Use_Date); cmd1.Parameters.AddWithValue("@Amount", obj1.Amount); cmd1.Parameters.AddWithValue("@Asset_Life", obj1.Asset_Life); cmd1.Parameters.AddWithValue("@Method_Code", obj1.Method_Code); cmd1.Parameters.AddWithValue("@SubGroup_ShiftCode", obj.SubGroup_ShiftCode); cmd1.Parameters.AddWithValue("@Effe_From", obj1.Effe_From); cmd1.Parameters.AddWithValue("@Effe_To", obj1.Effe_To); cmd1.Parameters.AddWithValue("@Created_By", obj1.Created_By); cmd1.Parameters.AddWithValue("@Created_On", obj1.Created_On); cmd1.Parameters.AddWithValue("@Created_Hostname", obj1.Created_Hostname); cmd1.Parameters.AddWithValue("@Ip_Address", obj1.Ip_Address); cmd1.ExecuteNonQuery(); con1.Close(); } if (model.Jct_Asset_Dep_Asset.AcquiredType == "Independent") { obj.CompanyCode = model.Jct_Asset_Dep_Asset.CompanyCode; obj.UnitCode = model.Jct_Asset_Dep_Asset.UnitCode; obj.AcquiredAs = model.Jct_Asset_Dep_Asset.AcquiredAs; obj.AcquiredType = model.Jct_Asset_Dep_Asset.AcquiredType; obj.SubUnitCode = model.Jct_Asset_Dep_Asset.SubUnitCode; obj.SectionCode = model.Jct_Asset_Dep_Asset.SectionCode; obj.SubSectionCode = model.Jct_Asset_Dep_Asset.SubSectionCode; obj.GroupCode = model.Jct_Asset_Dep_Asset.GroupCode; obj.SubGroup_Code = model.Jct_Asset_Dep_Asset.SubGroup_Code; obj.AssetCode = model.Jct_Asset_Dep_Asset.AssetCode; obj.AssetName = model.Jct_Asset_Dep_Asset.AssetName; obj.SubArea = model.Jct_Asset_Dep_Asset.SubArea; obj.PurchaseDate = model.Jct_Asset_Dep_Asset.PurchaseDate; obj.Put_In_Use_Date = model.Jct_Asset_Dep_Asset.Put_In_Use_Date; obj.Quantity = model.Jct_Asset_Dep_Asset.Quantity; obj.SalvageValue = model.Jct_Asset_Dep_Asset.SalvageValue; obj.Amount = model.Jct_Asset_Dep_Asset.Amount; obj.Asset_Life = model.Jct_Asset_Dep_Asset.Asset_Life; obj.Method_Code = model.Jct_Asset_Dep_Asset.Method_Code; obj.SubGroup_ShiftCode = model.Jct_Asset_Dep_Asset.SubGroup_ShiftCode; obj.Depriciation_Rate_Com = model.Jct_Asset_Dep_Asset.Depriciation_Rate_Com; obj.Tangiable = model.Jct_Asset_Dep_Asset.Tangiable; obj.Insurer_Name = model.Jct_Asset_Dep_Asset.Insurer_Name; obj.Policy_No = model.Jct_Asset_Dep_Asset.Policy_No; obj.Effe_From = System.DateTime.Today; obj.Effe_To = model.Jct_Asset_Dep_Asset.Effe_To; obj.Created_By = User.Identity.Name; obj.Created_On = System.DateTime.Now; obj.Created_Hostname = System.Environment.MachineName; //obj.Tangiable = ("::1" == System.Web.HttpContext.Current.Request.UserHostAddress) ? "localhost" : System.Web.HttpContext.Current.Request.UserHostAddress; SqlConnection con = DBConnection.getConnection(); string sql = "Jct_Asset_Dep_Asset_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("@SubSectionCode", obj.SubSectionCode); cmd.Parameters.AddWithValue("@Group_Code", obj.GroupCode); cmd.Parameters.AddWithValue("@SubGroup_Code ", obj.SubGroup_Code); cmd.Parameters.AddWithValue("@AcquiredAs", obj.AcquiredAs); cmd.Parameters.AddWithValue("@AcquiredType", obj.AcquiredType); cmd.Parameters.AddWithValue("@Quantity", obj.Quantity); cmd.Parameters.AddWithValue("@SalvageValue", obj.SalvageValue); cmd.Parameters.AddWithValue("@AssetCode", obj.AssetCode); cmd.Parameters.AddWithValue("@AssetName", obj.AssetName); cmd.Parameters.AddWithValue("@PurchaseDate", obj.PurchaseDate); cmd.Parameters.AddWithValue("@Put_In_Use_Date", obj.Put_In_Use_Date); cmd.Parameters.AddWithValue("@Amount", obj.Amount); cmd.Parameters.AddWithValue("@Asset_Life", obj.Asset_Life); cmd.Parameters.AddWithValue("@SubArea", obj.SubArea); cmd.Parameters.AddWithValue("@Method_Code", obj.Method_Code); cmd.Parameters.AddWithValue("@SubGroup_ShiftCode", obj.SubGroup_ShiftCode); cmd.Parameters.AddWithValue("@ITBook", "ITB-1"); cmd.Parameters.AddWithValue("@COMBook", "COM-0"); cmd.Parameters.AddWithValue("@Policy_No", obj.Policy_No); cmd.Parameters.AddWithValue("@Insurer_Name", obj.Insurer_Name); cmd.Parameters.AddWithValue("@Tangiable", obj.Tangiable); 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("@Created_On", obj.Created_On); cmd.Parameters.AddWithValue("@Created_Hostname", obj.Created_Hostname); cmd.Parameters.AddWithValue("@Ip_Address", obj.Tangiable); cmd.ExecuteNonQuery(); con.Close(); } return(RedirectToAction("AssetMaster", "Asset", null)); }
public ActionResult UpdateAssetInfo(ParentViewModel model) { try { Jct_Asset_Dep_Asset asset = new Jct_Asset_Dep_Asset(); Jct_Asset_Dep_Bill_Info info = new Jct_Asset_Dep_Bill_Info(); //--------------------------------------------------------// asset.CompanyCode = model.Jct_Asset_Dep_Asset.CompanyCode; asset.UnitCode = model.Jct_Asset_Dep_Asset.UnitCode; asset.SubUnitCode = model.Jct_Asset_Dep_Asset.SubUnitCode; asset.SectionCode = model.Jct_Asset_Dep_Asset.SectionCode; asset.SubSectionCode = model.Jct_Asset_Dep_Asset.SubSectionCode; asset.GroupCode = model.Jct_Asset_Dep_Asset.GroupCode; asset.SubGroup_Code = model.Jct_Asset_Dep_Asset.SubGroup_Code; asset.AcquiredAs = model.Jct_Asset_Dep_Asset.AcquiredAs; asset.AcquiredType = model.Jct_Asset_Dep_Asset.AcquiredType; asset.Quantity = model.Jct_Asset_Dep_Asset.Quantity; asset.SalvageValue = model.Jct_Asset_Dep_Asset.SalvageValue; asset.AssetCode = model.Jct_Asset_Dep_Asset.AssetCode; asset.AssetName = model.Jct_Asset_Dep_Asset.AssetName; asset.SubGroup_ShiftCode = model.Jct_Asset_Dep_Asset.SubGroup_ShiftCode; asset.PurchaseDate = model.Jct_Asset_Dep_Asset.PurchaseDate; asset.Put_In_Use_Date = model.Jct_Asset_Dep_Asset.Put_In_Use_Date; asset.Amount = model.Jct_Asset_Dep_Asset.Amount; asset.Asset_Life = model.Jct_Asset_Dep_Asset.Asset_Life; asset.Asset_Life_Year = model.Jct_Asset_Dep_Asset.Asset_Life_Year; asset.SubArea = model.Jct_Asset_Dep_Asset.SubArea; asset.Method_Code = model.Jct_Asset_Dep_Asset.Method_Code; asset.Insurer_Name = model.Jct_Asset_Dep_Asset.Insurer_Name; asset.Policy_No = model.Jct_Asset_Dep_Asset.Policy_No; asset.NetBook_Value = model.Jct_Asset_Dep_Asset.Amount; asset.Depriciation_Rate_Com = float.Parse(Convert.ToString(model.Jct_Asset_Dep_Asset.Depriciation_Rate_Com)); asset.Depriciation_Rate_IT = float.Parse(Convert.ToString(model.Jct_Asset_Dep_Asset.Depriciation_Rate_IT)); asset.Life_In_Days = model.Jct_Asset_Dep_Asset.Life_In_Days; asset.Effe_From = System.DateTime.Today; asset.Effe_To = model.Jct_Asset_Dep_Asset.Effe_To; asset.Created_By = HttpContext.User.Identity.Name; asset.Created_On = System.DateTime.Now; asset.Created_Hostname = System.Environment.MachineName; asset.Tangiable = ("::1" == System.Web.HttpContext.Current.Request.UserHostAddress) ? "localhost" : System.Web.HttpContext.Current.Request.UserHostAddress; //--------------------------------------------------------------------------------// //-----------------------------------------------------------------------------// //info.Bill_Date=model info.AssetCode = model.Jct_Asset_Dep_Asset.AssetCode; info.Insurance_Name = model.Jct_Asset_Dep_Bill_Info.Insurance_Name; info.Insurance_Date = model.Jct_Asset_Dep_Bill_Info.Insurance_Date; info.Insurance_Type = model.Jct_Asset_Dep_Bill_Info.Insurance_Type; info.Invoice_NO = model.Jct_Asset_Dep_Bill_Info.Invoice_NO; info.Invoice_Attachment = model.Jct_Asset_Dep_Bill_Info.Invoice_Attachment; info.PO_No = model.Jct_Asset_Dep_Bill_Info.PO_No; info.PO_Date = model.Jct_Asset_Dep_Asset.PurchaseDate; info.Bill_No = model.Jct_Asset_Dep_Bill_Info.Bill_No; info.Bill_Date = model.Jct_Asset_Dep_Bill_Info.Bill_Date; info.Manufacture = model.Jct_Asset_Dep_Bill_Info.Manufacture; info.Modal = model.Jct_Asset_Dep_Bill_Info.Modal; info.Supplier = model.Jct_Asset_Dep_Bill_Info.Supplier; info.Imported_Indegeneous = model.Jct_Asset_Dep_Bill_Info.Imported_Indegeneous; info.Cenvat = model.Jct_Asset_Dep_Bill_Info.Cenvat; info.Custom_Duty = model.Jct_Asset_Dep_Bill_Info.Custom_Duty; //-----------------------------------------------------------------------------// SqlConnection con = DBConnection.getConnection(); string sql = "Jct_Asset_Dep_Asset_Update"; SqlCommand cmd = new SqlCommand(sql, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CompanyCode", asset.CompanyCode); cmd.Parameters.AddWithValue("@UnitCode", asset.UnitCode); cmd.Parameters.AddWithValue("@SubUnitCode", asset.SubUnitCode); cmd.Parameters.AddWithValue("@SectionCode", asset.SectionCode); cmd.Parameters.AddWithValue("@SubSectionCode", asset.SubSectionCode); cmd.Parameters.AddWithValue("@Group_Code", asset.GroupCode); cmd.Parameters.AddWithValue("@SubGroup_Code ", asset.SubGroup_Code); cmd.Parameters.AddWithValue("@AcquiredAs", asset.AcquiredAs); cmd.Parameters.AddWithValue("@AcquiredType", asset.AcquiredType); cmd.Parameters.AddWithValue("@Quantity", asset.Quantity); cmd.Parameters.AddWithValue("@SalvageValue", asset.SalvageValue); cmd.Parameters.AddWithValue("@AssetCode", asset.AssetCode); cmd.Parameters.AddWithValue("@AssetName", asset.AssetName); cmd.Parameters.AddWithValue("@PurchaseDate", asset.PurchaseDate); cmd.Parameters.AddWithValue("@Put_In_Use_Date", asset.Put_In_Use_Date); cmd.Parameters.AddWithValue("@Amount", asset.Amount); cmd.Parameters.AddWithValue("@Asset_Life", asset.Asset_Life); cmd.Parameters.AddWithValue("@Asset_Life_Year", asset.Asset_Life_Year); cmd.Parameters.AddWithValue("@SubArea", asset.SubArea); cmd.Parameters.AddWithValue("@Method_Code", asset.Method_Code); cmd.Parameters.AddWithValue("@ITBook", "ITB-1"); cmd.Parameters.AddWithValue("@COMBook", "COM-0"); cmd.Parameters.AddWithValue("@SubGroup_ShiftCode", asset.SubGroup_ShiftCode); cmd.Parameters.AddWithValue("@Depriciation_Rate_IT", asset.Depriciation_Rate_IT); cmd.Parameters.AddWithValue("@Depriciation_Rate_Com", asset.Depriciation_Rate_Com); cmd.Parameters.AddWithValue("@Life_In_Days", asset.Life_In_Days); cmd.Parameters.AddWithValue("@Insurance_Name", info.Insurance_Name); cmd.Parameters.AddWithValue("@Insurance_Date", info.Insurance_Date); cmd.Parameters.AddWithValue("@Insurance_Type", info.Insurance_Type); cmd.Parameters.AddWithValue("@Invoice_NO", info.Invoice_NO); cmd.Parameters.AddWithValue("@Invoice_Attachment", info.Invoice_Attachment); cmd.Parameters.AddWithValue("@PO_No", info.PO_No); cmd.Parameters.AddWithValue("@PO_Date", info.PO_Date); cmd.Parameters.AddWithValue("@Bill_No", info.Bill_No); cmd.Parameters.AddWithValue("@Bill_Date", info.Bill_Date); cmd.Parameters.AddWithValue("@Manufacture", info.Manufacture); cmd.Parameters.AddWithValue("@Modal", info.Modal); cmd.Parameters.AddWithValue("@Supplier", info.Supplier); cmd.Parameters.AddWithValue("@Imported_Indegeneous", info.Imported_Indegeneous); cmd.Parameters.AddWithValue("@Insurer_Name", asset.Insurer_Name); cmd.Parameters.AddWithValue("@Policy_No", asset.Policy_No); cmd.Parameters.AddWithValue("@Cenvat", info.Cenvat); cmd.Parameters.AddWithValue("@Custom_Duty", info.Custom_Duty); cmd.Parameters.AddWithValue("@Effe_From", asset.Effe_From); cmd.Parameters.AddWithValue("@Effe_To", asset.Effe_To); cmd.Parameters.AddWithValue("@Created_By", asset.Created_By); cmd.Parameters.AddWithValue("@Created_On", asset.Created_On); cmd.Parameters.AddWithValue("@Created_Hostname", asset.Created_Hostname); cmd.Parameters.AddWithValue("@Ip_Address", asset.Tangiable); cmd.Parameters.AddWithValue("@NetBook_Value", asset.NetBook_Value); cmd.Parameters.AddWithValue("@BookCode", User.book); cmd.ExecuteNonQuery(); con.Close(); return(RedirectToAction("AssetEditInfo", "AssetAcquisition", new { Id = asset.AssetCode })); } catch (Exception ex) { ex.Message.ToString(); return(View()); } }