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