public static bool InsertAdvnaceMemo(OfficeAdvanceAdmin model)
{
int cashmemoid;
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertOwnerAdvance", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("busid", model.BusNumber);
cmd.Parameters.AddWithValue("reason", model.Reason);
cmd.Parameters.AddWithValue("date", model.InsertDate);
cmd.Parameters.AddWithValue("approvedby", model.InsertedBy);
cmd.Parameters.AddWithValue("amount", model.Amount);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw;
}
conn.Close();
}
}
return(true);
}
public static bool BALInsertAdvance(OfficeAdvanceAdmin model)
{
return(OfficeAdminRepository.InsertAdvnaceMemo(model));
}
