//To Update Daily Expences details
/// <summary>
///
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool UpdateExpence(DailyExpences obj)
{
connection();
SqlCommand com = new SqlCommand("USP_UpdateDailyExpenceDetails", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Amount", obj.expencesAmount);
com.Parameters.AddWithValue("@Description", obj.expenceDescription);
com.Parameters.AddWithValue("@Date", obj.expenceDate);
com.Parameters.AddWithValue("@Remark", obj.remark);
com.Parameters.AddWithValue("@ExpenceId", obj.DailyExpencesId);
com.Parameters.AddWithValue("@UpdateCondition", "1=1");
con.Open();
int i = com.ExecuteNonQuery();
con.Close();
if (i >= 1)
{
return(true);
}
else
{
return(false);
}
}
//To Get specific Daily Expences details
/// <summary>
///
/// </summary>
/// <param name="expenceId"></param>
/// <returns></returns>
public DailyExpences GetExpence(int expenceId)
{
connection();
DailyExpences expences = new DailyExpences();
SqlCommand com = new SqlCommand("GetDailyExpencesById", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Id", expenceId);
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
con.Open();
da.Fill(dt);
con.Close();
if (dt.Rows.Count > 0)
{
//Bind expences generic list using LINQ
expences.DailyExpencesId = Convert.ToInt32(dt.Rows[0]["DailyExpencesId"]);
expences.expencesAmount = Convert.ToDouble(dt.Rows[0]["ExpencesAmount"]);
expences.expenceDescription = Convert.ToString(dt.Rows[0]["ExpenceDescription"]);
expences.expenceDate = Convert.ToDateTime(dt.Rows[0]["ExpenceDate"]);
expences.remark = Convert.ToString(dt.Rows[0]["Remark"]);
}
return(expences);
}
public ActionResult Edit(int id, FormCollection collection)
{
try
{
DailyExpences de = new DailyExpences();
de.expenceDate = DateTime.Parse(Convert.ToString(Request.Form["expenceDate"]));
de.expenceDescription = Convert.ToString(Request.Form["expenceDescription"]);
de.expencesAmount = Convert.ToDouble(Request.Form["expencesAmount"]);
de.remark = Convert.ToString(Request.Form["remark"]);
de.DailyExpencesId = id;
Rep_DailyExpences expRepo = new Rep_DailyExpences();
expRepo.UpdateExpence(de);
return(RedirectToAction("GetExpences"));
}
catch (Exception ex)
{
return(RedirectToAction("GetExpences"));
}
}
public ActionResult Create(FormCollection collection)
{
try
{
DailyExpences de = new DailyExpences();
de.expenceDate = DateTime.Parse(Convert.ToString(Request.Form["expenceDate"]));
de.expenceDescription = Convert.ToString(Request.Form["expenceDescription"]);
de.expencesAmount = Convert.ToDouble(Request.Form["expencesAmount"]);
de.remark = Convert.ToString(Request.Form["remark"]);
Rep_DailyExpences expRepo = new Rep_DailyExpences();
expRepo.AddDailyExpences(de);
//return RedirectToAction("..//home//Index");
return(RedirectToAction("GetExpences"));
}
catch
{
return(View());
}
}
