public int InsertUpdateClassAdmin(DOLUser objUser)
{
int result = 0;
try
{
result = DataAccessLayer.ExecuteStoredProcedure(new SqlParameter[] { new SqlParameter("@ClassAdminId", objUser.UserId),
new SqlParameter("@FirstName", objUser.FirstName),
new SqlParameter("@LastName", objUser.LastName),
new SqlParameter("@Address", objUser.Address),
new SqlParameter("@Email", objUser.Email),
new SqlParameter("@Password", objUser.Password),
new SqlParameter("@RESULT", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, result) }, "SP_INSERT_UPDATE_CLASSADMIN", "@RESULT");
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int InsertStudent(DOLUser objUser)
{
int result = 0;
try
{
result = DataAccessLayer.ExecuteStoredProcedure(new SqlParameter[] { new SqlParameter("@StudentId", objUser.UserId),
new SqlParameter("@SchoolId", objUser.SchoolId),
new SqlParameter("@ClassId", objUser.ClassId),
new SqlParameter("@CityId", objUser.CityId),
new SqlParameter("@FirstName", objUser.FirstName),
new SqlParameter("@LastName", objUser.LastName),
new SqlParameter("@Email", objUser.Email),
new SqlParameter("@Password", objUser.Password),
new SqlParameter("@UserName", objUser.UserName),
new SqlParameter("@RESULT", SqlDbType.Int, 4, ParameterDirection.Output, false, 0, 0, "", DataRowVersion.Proposed, result) }, "SP_INSERTUPDATE_STUDENT", "@RESULT");
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public int InsertUpdateCityAdmin(DOLUser objUser)
{
int result = 0;
try
{
result = DataAccessLayer.ExecuteStoredProcedure(new SqlParameter[] { new SqlParameter("@CityAdminId", objUser.UserId),
//new SqlParameter("@CityId", objUser.CityId),
new SqlParameter("@FirstName",objUser.FirstName),
new SqlParameter("@LastName",objUser.LastName),
new SqlParameter("@Address",objUser.Address),
new SqlParameter("@Email",objUser.Email),
new SqlParameter("@Password",objUser.Password),
new SqlParameter("@RESULT",SqlDbType.Int, 4, ParameterDirection.Output, false, 0,0,"",DataRowVersion.Proposed,result)}, "SP_INSERT_UPDATE_CITYADMIN", "@RESULT");
}
catch (Exception ex)
{
throw ex;
}
return result;
}
public int InsertStudent(DOLUser objUser)
{
int result = 0;
try
{
result = DataAccessLayer.ExecuteStoredProcedure(new SqlParameter[] { new SqlParameter("@StudentId", objUser.UserId),
new SqlParameter("@SchoolId", objUser.SchoolId),
new SqlParameter("@ClassId",objUser.ClassId),
new SqlParameter("@CityId",objUser.CityId),
new SqlParameter("@FirstName",objUser.FirstName),
new SqlParameter("@LastName",objUser.LastName),
new SqlParameter("@Email",objUser.Email),
new SqlParameter("@Password",objUser.Password),
new SqlParameter("@UserName",objUser.UserName),
new SqlParameter("@RESULT",SqlDbType.Int, 4, ParameterDirection.Output, false, 0,0,"",DataRowVersion.Proposed,result)}, "SP_INSERTUPDATE_STUDENT", "@RESULT");
}
catch (Exception ex)
{
throw ex;
}
return result;
}
