public bool Remove(UsersLastSelected data, ref string msgError)
{
SqlConnection oConn = null;
try
{
oConn = ConnManager.OpenConn();
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
msgError = ex.Message;
return(false);
};
bool result;
try
{
result = Remove(data, oConn);
}
catch (Exception ex)
{
ConnManager.CloseConn(oConn);
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
return(false);
}
ConnManager.CloseConn(oConn);
return(result);
}
private bool Remove(UsersLastSelected data, SqlConnection oConn)
{
string sql = "DELETE FROM UsersLastSelections " +
" WHERE (ULSId = @id)";
SqlCommand cmd = new SqlCommand(sql, oConn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(data.ULSId);
int number = Convert.ToInt32(cmd.ExecuteNonQuery());
if (number > 0)
{
return(true);
}
return(false);
}
public UsersLastSelected Add(UsersLastSelected data, ref string msgError)
{
SqlConnection oConn = null;
try
{
oConn = ConnManager.OpenConn();
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
throw;
};
string sql = "INSERT INTO UsersLastSelections ({0}) VALUES ({1}) " +
"SELECT SCOPE_IDENTITY()";
EnumExtension.setListValues(data, "ULSId", ref sql);
SqlCommand cmd = new SqlCommand(sql, oConn);
int keyGenerated = 0;
try
{
keyGenerated = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception ex)
{
ConnManager.CloseConn(oConn);
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
msgError = ex.Message;
return(null);
}
UsersLastSelected returnData = Get(keyGenerated, oConn);
ConnManager.CloseConn(oConn);
return(returnData);
}
public UsersLastSelected Get(int id, ref string msgError)
{
SqlConnection oConn = null;
try
{
oConn = ConnManager.OpenConn();
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
msgError = ex.Message;
return(null);
};
UsersLastSelected data = Get(id, oConn);
ConnManager.CloseConn(oConn);
return(data);
}
public UsersLastSelected Update(UsersLastSelected data, ref string msgError)
{
SqlConnection oConn = null;
try
{
oConn = ConnManager.OpenConn();
}
catch (Exception ex)
{
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
throw;
};
string sql = "UPDATE UsersLastSelections SET {0} WHERE ULSId = @id";
EnumExtension.setUpdateValues(data, "ULSId", ref sql);
SqlCommand cmd = new SqlCommand(sql, oConn);
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(data.ULSId);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
ConnManager.CloseConn(oConn);
LogManager.Write("ERROR:" + Environment.NewLine + "\tMETHOD = " + this.GetType().FullName + "." + MethodBase.GetCurrentMethod().Name + Environment.NewLine + "\tMESSAGE = " + ex.Message);
msgError = ex.Message;
return(null);
}
UsersLastSelected returnData = Get(data.ULSId, oConn);
ConnManager.CloseConn(oConn);
return(returnData);
}
private void handleSelected(User currentUser, int id, bool isChecked, SqlConnection oConn, ref string errMsg)
{
UsersLastSelected uls = null;
uls = ULSRepository.GetPOVByUser(currentUser.UserId, id, ref errMsg);
if (uls == null && isChecked)
{
uls = new UsersLastSelected();
uls.UserId = currentUser.UserId;
uls.POVId = id;
uls = ULSRepository.Add(uls, ref errMsg);
}
else
{
if (uls != null && !isChecked)
{
ULSRepository.Remove(uls, ref errMsg);
}
}
}