public ActionResult Detail(int id, ExpenseDetail expenseDetail)
{
try
{
ExpenseManager expenseManager = new ExpenseManager();
expenseDetail.ExpenseSummaryID = id;
int value = expenseManager.CreateExpenseDetail(expenseDetail);
////create path to store in database
//// expenseDetail.user_image = "~/image/" + expenseDetail.expenseAttachment.FileName;
//var t = Server.MapPath("Images") + "/" + expenseDetail.expenseAttachment.FileName;
////store image in folder
//expenseDetail.expenseAttachment.SaveAs(Server.MapPath("~/Images") + "/" + expenseDetail.expenseAttachment.FileName);
byte[] bytes;
if (expenseDetail.expenseAttachment != null)
{
using (BinaryReader br = new BinaryReader(expenseDetail.expenseAttachment.InputStream))
{
bytes = br.ReadBytes(expenseDetail.expenseAttachment.ContentLength);
}
string constr = ConfigurationManager.AppSettings["PayMe-Connectionstring"];
using (SqlConnection con = new SqlConnection(constr))
{
string query = "INSERT INTO ExpenseDetailDocument VALUES (@ExpenseDetailID,@Name, @ContentType, @Data)";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@ExpenseDetailID", value);
cmd.Parameters.AddWithValue("@Name", Path.GetFileName(expenseDetail.expenseAttachment.FileName));
cmd.Parameters.AddWithValue("@ContentType", expenseDetail.expenseAttachment.ContentType);
cmd.Parameters.AddWithValue("@Data", bytes);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
TempData["Message"] = "Expense Detail Created Successfully";
return(RedirectToAction("Detail/" + id));
}
catch (Exception ex)
{
TempData["Message"] = "Error Occured";
return(View());
}
}