public static bool InsertReceivingChit(FuelRecieve model)
{
int cashmemoid;
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertFuelRecieving", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("pumpid", model.Pumpid);
cmd.Parameters.AddWithValue("fueltypeid", model.FuelType);
cmd.Parameters.AddWithValue("recievingprice", model.PriceRecieved);
cmd.Parameters.AddWithValue("recievingquantity", model.QuantityRecieved);
cmd.Parameters.AddWithValue("vechileno", model.VechileNumber);
cmd.Parameters.AddWithValue("comment", model.Comment);
cmd.Parameters.AddWithValue("insertedby", model.InsertedBy);
cmd.Parameters.AddWithValue("totalprice", model.QuantityRecieved * model.PriceRecieved);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(false);
}
conn.Close();
}
}
return(true);
}
public ActionResult SaveFuelRecievingDetails(FuelRecieve model)
{
var user = ((UserValidation.CustomPrincipal)(HttpContext.Request.RequestContext.HttpContext.User)).User;
var data = BusinessAccessLayer.BALFuel.BALInsertReceivingChit(model);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public static bool BALInsertReceivingChit(FuelRecieve model)
{
return(DataRepository.FuelRepository.InsertReceivingChit(model));
}
