public void InsertStudentAddress(DTO.University.Request.CheckOutStLastUniInfo AddressInfo)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[Request].[SP_InsertStudentAdress]";
cmd.Parameters.AddWithValue("@StCode", AddressInfo.StCode);
cmd.Parameters.AddWithValue("@ProvinceID", AddressInfo.ProvinceID);
cmd.Parameters.AddWithValue("@CityID", AddressInfo.CityID);
cmd.Parameters.AddWithValue("@Street", AddressInfo.Street);
cmd.Parameters.AddWithValue("@Alley", AddressInfo.Alley);
cmd.Parameters.AddWithValue("@Pelak", AddressInfo.Pelak);
cmd.Parameters.AddWithValue("@ZipCode", AddressInfo.ZipCode);
cmd.Parameters.AddWithValue("@Phone", AddressInfo.Phone);
cmd.Parameters.AddWithValue("@Mobile", AddressInfo.Mobile);
cmd.Parameters.AddWithValue("@Email", AddressInfo.Email);
cmd.Parameters.AddWithValue("@RabetPhone", AddressInfo.RabetPhone);
cmd.Parameters.AddWithValue("@RabetMobile", AddressInfo.RabetMobile);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
throw;
}
}
public void InsertStudentLastUniInfo(DTO.University.Request.CheckOutStLastUniInfo lastInfo)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[Request].[SP_InsertStudentLastUniInfo]";
cmd.Parameters.AddWithValue("@StCode", lastInfo.StCode);
cmd.Parameters.AddWithValue("@TypeOfUni", lastInfo.TypeOfUni);
cmd.Parameters.AddWithValue("@UniName", lastInfo.UniName);
cmd.Parameters.AddWithValue("@FieldName", lastInfo.FieldName);
cmd.Parameters.AddWithValue("@Maghta", lastInfo.Maghta);
cmd.Parameters.AddWithValue("@FeraghatYear", lastInfo.FeraghatYear);
cmd.Parameters.AddWithValue("@FeraghatHalfyear", lastInfo.FeraghatHalfYear);
cmd.Parameters.AddWithValue("@FeraghatDate", lastInfo.FeraghatDate);
cmd.Parameters.AddWithValue("@FeraghatType", lastInfo.FeraghatType);
cmd.Parameters.AddWithValue("@CheckOutStatus", lastInfo.CheckOutStatus);
cmd.Parameters.AddWithValue("@LoanAmount", lastInfo.LoanAmount);
cmd.Parameters.AddWithValue("@IsMashmool", lastInfo.IsMashmool);
cmd.Parameters.AddWithValue("@MadrakURL", lastInfo.ScanMadarekURL);
try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
throw;
}
}
public void AddStudentAddressInfo(DTO.University.Request.CheckOutStLastUniInfo AddressInfo)
{
DebitDAO.InsertStudentAddress(AddressInfo);
}
public void AddStudentLastUniInfo(DTO.University.Request.CheckOutStLastUniInfo lastInfo)
{
DebitDAO.InsertStudentLastUniInfo(lastInfo);
}
