public int Warranty_Column_Update(BAL_Warranty bwu)
{
try
{ con.Open();
cmd = new SqlCommand("SP_WarrantyUpdate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 2);
cmd.Parameters.AddWithValue("@ID", bwu.ID);
cmd.Parameters.AddWithValue("@Warr_Status", bwu.Warr_Status);
cmd.Parameters.AddWithValue("@S_Status", bwu.S_Status);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
}
public int Warranty_Save(BAL_Warranty bw)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Warranty", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Customer_ID", bw.Customer_ID);
cmd.Parameters.AddWithValue("@Bill_No", bw.Bill_No);
cmd.Parameters.AddWithValue("@Products123", bw.Products123);
cmd.Parameters.AddWithValue("@Warranty", bw.Warranty);
cmd.Parameters.AddWithValue("@Warr_Months", bw.Warr_Months);
cmd.Parameters.AddWithValue("@Warr_StartDate", bw.Warr_StartDate);
cmd.Parameters.AddWithValue("@Warr_EndDate", bw.Warr_EndDate);
cmd.Parameters.AddWithValue("@Warr_RemainingDate", bw.Warr_RemainingDate);
cmd.Parameters.AddWithValue("@Warr_RemainingMonths", bw.Warr_RemainingMonths);
cmd.Parameters.AddWithValue("@Warr_RemainingDays", bw.Warr_RemainingDays);
cmd.Parameters.AddWithValue("@Extend_Y_M", bw.Extend_Y_M);
cmd.Parameters.AddWithValue("@C_ExtendDate", bw.C_ExtendDate);
cmd.Parameters.AddWithValue("@Paid_Amount", bw.Paid_Amount);
cmd.Parameters.AddWithValue("@Warr_Status", bw.Warr_Status);
cmd.Parameters.AddWithValue("@S_Status", bw.S_Status);
cmd.Parameters.AddWithValue("@C_Date", bw.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}