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); }