public DataTable GetInfoSTU(MilitaryStatusDTO msd) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "[Request].[SP_Get_StudentInfoByFamily]"; cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; DataTable dt = new DataTable(); cmd.Parameters.AddWithValue("@stcode", msd.stCode); cmd.Parameters.AddWithValue("@family", msd.family); try { conn.Open(); SqlDataReader rdr; rdr = cmd.ExecuteReader(); dt.Load(rdr); conn.Close(); } catch { throw; } return(dt); }
public void insertMashmulNumber(MilitaryStatusDTO msd) { SqlCommand cmdInsMash = new SqlCommand(); cmdInsMash.Connection = conn; cmdInsMash.CommandText = "Request.SP_insertMilitaryStatus"; cmdInsMash.CommandType = CommandType.StoredProcedure; cmdInsMash.Parameters.AddWithValue("@stCode", msd.stCode); cmdInsMash.Parameters.AddWithValue("@mashmulNumber", msd.mashmulNumber); cmdInsMash.Parameters.AddWithValue("@MashmulTarikh", msd.mashmulTarikh); cmdInsMash.Parameters.AddWithValue("@MashmulStatus", msd.mashmulStatus); try { conn.Open(); cmdInsMash.ExecuteNonQuery(); conn.Close(); cmdInsMash.Dispose(); } catch (Exception) { throw; } }
public void insertMashmulNumber(MilitaryStatusDTO msd) { RES.insertMashmulNumber(msd); }
public void updateMashmulNumber(MilitaryStatusDTO msd) { RES.updateMashmulNumber(msd); }
public DataTable GetInfoSTUD(MilitaryStatusDTO msd) { return(RES.GetInfoSTU(msd)); }