public string updateMark(ATTmarks ATTmarkObj)
{
DLLmarks DLLmarkObj = new DLLmarks();
string resMsg = DLLmarkObj.updateMark(ATTmarkObj);
return(resMsg);
}
public ATTmarks getMark(int sn)
{
SqlConnection connection = new SqlConnection(connString);
ATTmarks ATTmarkObj = new ATTmarks();
string sp = "dbo.getMark";
connection.Open();
SqlCommand cmd = new SqlCommand(sp, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@qid", SqlDbType.Int, 10).Value = sn;
SqlDataReader dReader = cmd.ExecuteReader();
while (dReader.Read())
{
ATTmarkObj.qid = dReader.GetInt32(0);
ATTmarkObj.math = dReader.GetDouble(1);
ATTmarkObj.science = dReader.GetDouble(2);
ATTmarkObj.english = dReader.GetDouble(3);
ATTmarkObj.social = dReader.GetDouble(4);
}
connection.Close();
dReader.Close();
return(ATTmarkObj);
}
public string updateMark(string mark)
{
BLLmarks BLLmarkObj = new BLLmarks();
ATTmarks ATTmarkObj = jss.Deserialize <ATTmarks>(mark) as ATTmarks;
string msg = BLLmarkObj.updateMark(ATTmarkObj);
return(msg);
}
public string getMark(int sn)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
DLLmarks DLLmarkObj = new DLLmarks();
ATTmarks ATTmarkObj = DLLmarkObj.getMark(sn);
string resMsg = serializer.Serialize(ATTmarkObj);
return(resMsg);
}
public string updateMark(ATTmarks ATTmarkObj)
{
SqlConnection connection = new SqlConnection(connString);
string resMsg = "";
string sp = "dbo.updateMark";
connection.Open();
SqlCommand cmd = new SqlCommand(sp, connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@qid", SqlDbType.Int, 10).Value = ATTmarkObj.qid;
cmd.Parameters.Add("@math", SqlDbType.Float, 50).Value = ATTmarkObj.math;
cmd.Parameters.Add("@science", SqlDbType.Float, 50).Value = ATTmarkObj.science;
cmd.Parameters.Add("@english", SqlDbType.Float, 50).Value = ATTmarkObj.english;
cmd.Parameters.Add("@social", SqlDbType.Float, 50).Value = ATTmarkObj.social;
cmd.ExecuteNonQuery();
resMsg = "success";
connection.Close();
return(resMsg);
}