public JsonResult InsertBillGenerate(BillGenerateVM _obj)
{
try
{
_obj.createdBy = Convert.ToInt32(Session["userId"]);
int result = _dishBillGenerateDA.InsertBillGenerate(_obj);
return(Json(new { success = true, message = "Data Saved" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public int InsertBillGenerate(BillGenerateVM _obj)
{
int result = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("isp_DishCustomerBillGenerate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@cid", _obj.cid);
cmd.Parameters.AddWithValue("@isBatch", _obj.isBatch);
cmd.Parameters.AddWithValue("@month", _obj.month);
cmd.Parameters.AddWithValue("@year", _obj.year);
cmd.Parameters.AddWithValue("@remarks", _obj.remarks);
cmd.Parameters.AddWithValue("@createdBy", _obj.createdBy);
cmd.CommandTimeout = 0;
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
result = 1;
con.Close();
}
return(result);
}
