public ActionResult AddAsset(Addasset add)
{
if (ModelState.IsValid)
{
var items = db.addasset.Where(x => x.asset.Equals(add.asset)).SingleOrDefault();
if (items == null)
{
add.state = "Active";
//int a = add.capacity;
//add.assetid = "s" + a;
//for(int i=1;i<=a;i++)
//{
//add.capacity = i;
db.addasset.Add(add);
db.SaveChanges();
//}
}
else
{
ViewBag.message = "Following asset is already added";
}
}
var model = db.addasset.ToList();
return(View(model));
}
public ActionResult Active(int id, Addasset bm)
{
var items = db.addasset.Where(x => x.id == id).FirstOrDefault();
items.state = "Active";
db.SaveChanges();
var updation = db.addasset.ToList();
return(View("AddAsset", updation));
}
public ActionResult DeleteAsset(int id, Addasset asset, BookModel model)
{
asset = db.addasset.Find(id);
try
{
var check = (from a in db.bookm
where a.asset == asset.asset
select new
{
a.date
}).SingleOrDefault();
DateTime booked_date = Convert.ToDateTime(check.date);
if (booked_date <= DateTime.Today.Date && check == null)
{
db.addasset.Remove(asset);
db.SaveChanges();
}
else
{
ViewBag.booked = "Items are booked";
}
}
catch
{
db.addasset.Remove(asset);
db.SaveChanges();
}
var updation = db.addasset.ToList();
return(View("AddAsset", updation));
}
public bool AddAsset([FromBody] Addasset A)
{
try
{
Addasset ast = new Addasset();
List <Addasset> last = new List <Addasset>();
SqlParameter pt = new SqlParameter();
List <SqlParameter> lpt = new List <SqlParameter>();
var query = "INSERT INTO tb_asset (Asset_Name,Asset_Serial,Type_ID,Asset_Datebuy,Asset_Waranty,Asset_Price,Asset_Supply,User_ID,Admin_ID,Asset_Number,Asset_Modify) " +
"VALUES (@Asset_Name,@Asset_Serial,@Type_ID,@Asset_Datebuy,@Asset_Waranty,@Asset_Price,@Asset_Supply,@User_ID,@Admin_ID,@Asset_Number,@Asset_Modify)";
SqlConnection con = new SqlConnection(Startup.ConnectionString);
SqlCommand cmd = new SqlCommand(query, con);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Name";
pt.Value = A.Asset_Name;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Serial";
pt.Value = A.Asset_Serial;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Type_ID";
pt.Value = A.Type_ID;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Datebuy";
pt.Value = A.Asset_Datebuy;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Waranty";
pt.Value = A.Asset_Waranty;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Price";
pt.Value = A.Asset_Price;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Supply";
pt.Value = A.Asset_Supply;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@User_ID";
pt.Value = A.User_ID;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Admin_ID";
pt.Value = A.Admin_ID;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Number";
pt.Value = A.Asset_Number;
lpt.Add(pt);
pt = new SqlParameter();
pt.ParameterName = "@Asset_Modify";
pt.Value = A.Asset_Modify;
lpt.Add(pt);
foreach (var item in lpt)
{
cmd.Parameters.Add(item);
}
con.Open();
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
