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());
}
}
