public ActionResult Edit(FormCollection frm, int?id)
{
A_Depreciation updateDepre = new A_Depreciation();
updateDepre.DepreciationName = frm["DepreciationName"];
updateDepre.DepreciationRate = Convert.ToDecimal(frm["DepreciationRate"]);
updateDepre.Description = frm["Description"];
updateDepre.LastUpdatedDate = DateTime.Now;
updateDepre.LastUpdatedBy = Convert.ToInt32(Session["UserId"]);
db.UpdateDepreciation(updateDepre, (int)id);
return(RedirectToAction("Index"));
}
public int AddDepreciation(A_Depreciation saveDepre)
{
string sql = "insert into A_Depreciation(DepreciationName,DepreciationRate,Description,EnteredBy,EnteredDate,LastUpdatedBy,LastUpdatedDate,DepartmentId," +
"IsDeleted,DeletedBy,DeletedDate)" +
" values(@DepreciationName,@DepreciationRate,@Description,@EnteredBy,@EnteredDate,0,null,@DepartmentId," +
"0,0,null)";
using (var db = DbHelper.GetDBConnection())
{
int id = db.Query <int>(sql, saveDepre).SingleOrDefault();
db.Close();
return(id);
}
}
public ActionResult Create(FormCollection frm)
{
A_Depreciation saveDepre = new A_Depreciation();
saveDepre.DepreciationName = frm["DepreciationName"];
saveDepre.DepreciationRate = Convert.ToDecimal(frm["DepreciationRate"]);
saveDepre.Description = frm["Description"];
saveDepre.EnteredDate = DateTime.Now;
saveDepre.EnteredBy = Convert.ToInt32(Session["UserId"]);
saveDepre.DepartmentId = Convert.ToInt32(frm["DepartmentId"]);
db.AddDepreciation(saveDepre);
return(RedirectToAction("Index"));
}
public bool UpdateDepreciation(A_Depreciation updateDepre, int Id)
{
string sql = " Update A_Depreciation set DepreciationName=@DepreciationName, DepreciationRate=@DepreciationRate, Description=@Description," +
"LastUpdatedDate=@LastUpdatedDate, LastUpdatedBy=@LastUpdatedBy where IsDeleted=0 and DepreciationId= " + Id;
using (var db = DbHelper.GetDBConnection())
{
var lst = db.Execute(sql, updateDepre);
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
