public ActionResult saveAsset(warehouseViewModel warehouse)
{
bool result = warehouseservice.setwarehouse(warehouse);
if (result)
{
return(View());
}
else
{
return(View());
}
}
public bool setwarehouse(warehouseViewModel warehouse)
{
warehouse asset = new warehouse();
asset.Device_ID = warehouse.Device_ID;
asset.Device_Name = warehouse.Device_Name;
asset.Device_Type = warehouse.Device_Type;
asset.Processor = warehouse.Processor;
asset.Purchase_Date = warehouse.Purchase_Date;
asset.Remarks = warehouse.Remarks;
asset.Serial_No = warehouse.Serial_No;
asset.Status = warehouse.Status;
employeecontext.warehouses.Add(asset);
employeecontext.SaveChanges();
return(true);
}
public int editasset(warehouseViewModel warehouseviewmodel)
{
string connectionString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("updateWarehouse", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramS_No = new SqlParameter();
paramS_No.ParameterName = "@serial";
paramS_No.Value = warehouseviewmodel.S_No;
cmd.Parameters.Add(paramS_No);
SqlParameter paramId = new SqlParameter();
paramId.ParameterName = "@device_name";
paramId.Value = warehouseviewmodel.Device_Name;
cmd.Parameters.Add(paramId);
SqlParameter paramName = new SqlParameter();
paramName.ParameterName = "@device_type";
paramName.Value = warehouseviewmodel.Device_Type;
cmd.Parameters.Add(paramName);
SqlParameter paramdes = new SqlParameter();
paramdes.ParameterName = "@pro";
paramdes.Value = warehouseviewmodel.Processor;
cmd.Parameters.Add(paramdes);
SqlParameter paramemail = new SqlParameter();
paramemail.ParameterName = "@rem";
paramemail.Value = warehouseviewmodel.Remarks;
cmd.Parameters.Add(paramemail);
SqlParameter paramstat = new SqlParameter();
paramstat.ParameterName = "@stat";
paramstat.Value = warehouseviewmodel.Status;
cmd.Parameters.Add(paramstat);
con.Open();
int res = cmd.ExecuteNonQuery();
return(res);
}
}
public ActionResult Edit(warehouseViewModel warehouseviewmodel)
{
int res = warehouseservice.editasset(warehouseviewmodel);
if (res == 1)
{
if (warehouseviewmodel.Device_Type == "Laptop")
{
return(RedirectToAction("Index2"));
}
else if (warehouseviewmodel.Device_Type == "Desktop")
{
return(RedirectToAction("Index1"));
}
}
return(View());
}
public ActionResult Add(warehouseViewModel warehouseviewmodel)
{
if (ModelState.IsValid)
{
if (warehouseservice.getdevice_id(warehouseviewmodel.Device_ID))
{
bool res = warehouseservice.setwarehouse(warehouseviewmodel);
if (res)
{
if (warehouseviewmodel.Device_Type.Replace(" ", String.Empty) == "Laptop")
{
return(RedirectToAction("Index2"));
}
else if (warehouseviewmodel.Device_Type.Replace(" ", String.Empty) == "Desktop")
{
return(RedirectToAction("Index1"));
}
else
{
return(RedirectToAction("Index1"));
}
}
else
{
var errorList = (from item in ModelState
where item.Value.Errors.Any()
select item.Value.Errors[0].ErrorMessage).ToList();
return(Json(errorList, JsonRequestBehavior.AllowGet));
}
}
else
{
ModelState.AddModelError("Device_ID", "This Device Id is already inserted ");
return(RedirectToAction("Index1"));
}
}
else
{
return(RedirectToAction("Index1"));
}
}
