public Boolean updateServiceGroup(servicegroup sgroup)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update ServiceGroup set " +
"GroupDescription = " + "'" + sgroup.GroupDescription + "'" +
" where GroupLevel = " + sgroup.GroupLevel + " and GroupCode = '" + sgroup.GroupCode + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "ServiceGroup", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public List <servicegroup> getServiceGroupDetails(int lvl)
{
servicegroup sgroup;
List <servicegroup> GroupList = new List <servicegroup>();
try
{
string query = "select GroupLevel,GroupCode, GroupDescription, CreateTime, CreateUser " +
" from ServiceGroup where GroupLevel = " + lvl + " order by GroupDescription asc";
SqlConnection conn = new SqlConnection(Login.connString);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sgroup = new servicegroup();
sgroup.GroupLevel = reader.GetInt32(0);
sgroup.GroupCode = reader.GetString(1);
sgroup.GroupDescription = reader.GetString(2);
sgroup.CreateTime = reader.GetDateTime(3);
sgroup.CreateUser = reader.GetString(4);
GroupList.Add(sgroup);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Service Group Details");
}
return(GroupList);
}
public Boolean insertServiceGroup(servicegroup sgroup)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "insert into ServiceGroup " +
"(Grouplevel,GroupCode,GroupDescription,CreateTime,CreateUser) " +
"values ('" + sgroup.GroupLevel + "','"
+ sgroup.GroupCode + "','" +
sgroup.GroupDescription + "'," +
"GETDATE()" + ",'" +
Login.userLoggedIn + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ServiceGroup", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public Boolean validateServiceGroup(servicegroup sg)
{
Boolean status = true;
if ((sg.GroupCode.Trim().Length == 0) || (sg.GroupCode == null))
{
status = false;
}
if ((sg.GroupDescription.Trim().Length == 0) || (sg.GroupDescription == null))
{
status = false;
}
return(status);
}
