public static bool InsertChitBook(ChitBookModel model)
{
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertChitBookDetails", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("busid", model.BusID);
cmd.Parameters.AddWithValue("chitbookno", model.ChitBookNumber);
cmd.Parameters.AddWithValue("chitserialstart", model.ChitSerialStart);
cmd.Parameters.AddWithValue("chhitserialend", model.ChitSerialEnd);
cmd.Parameters.AddWithValue("issuedby", model.IssuedBy);
cmd.Parameters.AddWithValue("comment", model.Comment);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(false);
}
conn.Close();
}
}
return(true);
}
public ActionResult SaveDieselBookDetails(ChitBookModel model)
{
var user = ((UserValidation.CustomPrincipal)(HttpContext.Request.RequestContext.HttpContext.User)).User;
model.IssuedBy = user.LoginEmpID;
var data = BALBookStore.BALInsertChitBook(model);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public static bool BALInsertChitBook(ChitBookModel model)
{
return(DataRepository.BookStoreRepository.InsertChitBook(model));
}
