public ActionResult Edit(int?Id)
{
FillDropDowns();
ServiceExpense model = repo.GetServiceExpense(Id ?? 0);
return(View(model));
}
public ActionResult Create()
{
ServiceExpense model = new ServiceExpense();
FillDropDowns();
return(View(model));
}
public int Edit(ServiceExpense model)
{
using (IDbConnection connection = OpenConnection(sqlConnString))
{
string query = @"UPDATE ServiceExpense SET
SerSAC = @SerSAC
,SerName = @SerName
,gstId = @gstId
,SerOrExp = @SerOrExp
,SerRemarks = @SerRemarks
WHERE SerId=@SerId";
int rowsAffected = connection.Execute(query, model);
return(rowsAffected);
}
}
public ActionResult Edit(ServiceExpense model)
{
if (ModelState.IsValid)
{
int rowsAffected = repo.Edit(model);
if (rowsAffected > 0)
{
TempData["message"] = "Successfully Updated";
return(RedirectToAction("Index"));
}
else
{
FillDropDowns();
return(View(model));
}
}
return(View(model));
}
public ActionResult Create(ServiceExpense model)
{
if (ModelState.IsValid)
{
int rowsAffected = repo.Create(model);
if (rowsAffected > 0)
{
TempData["message"] = "Successfully Saved";
return(RedirectToAction("Create"));
}
else
{
FillDropDowns();
return(View(model));
}
}
FillDropDowns();
return(View(model));
}
public int Create(ServiceExpense model)
{
using (IDbConnection connection = OpenConnection(sqlConnString))
{
string query = @"INSERT INTO ServiceExpense(
SerSAC
,SerName
,gstId
,SerOrExp
,SerRemarks
)
select
@SerSAC
,@SerName
,@gstId
,@SerOrExp
,@SerRemarks";
int rowsAffected = connection.Execute(query, model);
SetIdentity <int>(connection, id => model.SerId = id);
return(rowsAffected);
}
}
