public int UpdateDebit(DTO.University.Request.StudentCheckOutDebit debit)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[Request].[SP_UpdateStudentDebit]";
cmd.Parameters.AddWithValue("@RefID", debit.RefID);
cmd.Parameters.AddWithValue("@stcode", debit.StCode);
cmd.Parameters.AddWithValue("@debitTypeId", debit.DebitTypeID);
cmd.Parameters.AddWithValue("@debitAmount", debit.DebitAmount);
cmd.Parameters.AddWithValue("@Tasvie", debit.TotalLoanAmount);
cmd.Parameters.AddWithValue("@debitNumber", debit.DebitNumber);
cmd.Parameters.AddWithValue("@fishNumber", debit.FishNumber);
cmd.Parameters.AddWithValue("@fishDate", debit.FishDate);
cmd.Parameters.AddWithValue("@note", debit.Note);
int result = 0;
try
{
conn.Open();
result = cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
throw;
}
return(result);
}
public int UpdateMaliDebit(DTO.University.Request.StudentCheckOutDebit debit, int userId)
{
CommonBusiness.InsertIntoUserLog(userId, DateTime.Now.ToPeString(), 12, 78, "ویرایش فیش شماره" + debit.DebitNumber, Convert.ToInt32(debit.DebitNumber));
return(MaliDAO.UpdateMaliDebit(debit));
}
