public SrvSchoolTypeMessage InsertUpdateSchoolType(SrvSchoolTypeParam param)
{
con.Open();
SrvSchoolTypeMessage message = new SrvSchoolTypeMessage();
SqlCommand cmd = new SqlCommand("sp_InsertUpdateSchoolType", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("SchoolTypeID", param.SchoolTypeID);
cmd.Parameters.AddWithValue("SchoolTypeName", param.SchoolTypeName);
cmd.Parameters.Add("@ReturnValue", SqlDbType.Int);
cmd.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@ReturnMessage", SqlDbType.NVarChar, 500);
cmd.Parameters["@ReturnMessage"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
message.Message.ReturnValue = Convert.ToInt32(cmd.Parameters["@ReturnValue"].Value);
message.Message.ReturnMessage = cmd.Parameters["@ReturnMessage"].Value.ToString();
con.Close();
return(message);
}
public SrvSchoolTypeMessage InsertUpdateSchoolType([FromBody] SrvSchoolTypeParam param)
{
SchoolTypeBL schoolType;
SrvSchoolTypeMessage message = new SrvSchoolTypeMessage();
try
{
schoolType = new SchoolTypeBL();
message = schoolType.InsertUpdateSchoolType(param);
}
catch (SqlException ex)
{
message.Message.ReturnValue = -1;
message.Message.ReturnMessage = "Sql Error";
}
catch (Exception ex)
{
message.Message.ReturnValue = -1;
message.Message.ReturnMessage = "Internal Error";
}
return(message);
}
