//UPDATE Employee Group
public bool UpdateEmployeeGroup(EmployeeGroupModel objEmp)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@GroupName", objEmp.GroupName));
paramCollection.Add(new DBParameter("@AliasName", objEmp.AliasName));
paramCollection.Add(new DBParameter("@Primary", objEmp.Primary, System.Data.DbType.Boolean));
paramCollection.Add(new DBParameter("@UnderGroup", objEmp.UnderGroup));
paramCollection.Add(new DBParameter("@NatureGroup", objEmp.NatureGroup));
paramCollection.Add(new DBParameter("@EG_id", objEmp.GroupId));
paramCollection.Add(new DBParameter("@ModifiedBy", objEmp.CreatedBy));
Query = "UPDATE employeegroup SET GroupName=@GroupName,AliasName=@AliasName,`Primary`=@Primary,UnderGroup=@UnderGroup,ModifiedBy=@ModifiedBy " +
"WHERE EG_ID=@EG_id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
private void FillAccountInfo()
{
EmployeeGroupModel EmployeeGroup = objbl.GetListofEmployeeGroupsById(Empid);
tbxGroupName.Text = EmployeeGroup.GroupName;
tbxAliasname.Text = EmployeeGroup.AliasName;
cbxPrimarygroup.SelectedItem = Convert.ToString((EmployeeGroup.Primary)?"Y":"N");
cbxUndergroup.SelectedItem = EmployeeGroup.UnderGroup;
cbxNaturegroup.SelectedItem = EmployeeGroup.Primary;
}
public EmployeeGroupModel GetListofEmployeeGroupsById(int id)
{
EmployeeGroupModel EmployeeGroup = new EmployeeGroupModel();
string Query = "SELECT * FROM `employeegroup` WHERE EG_ID=" + id + "";
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
EmployeeGroup.GroupId = Convert.ToInt32(dr["EG_ID"]);
EmployeeGroup.GroupName = dr["GroupName"].ToString();
EmployeeGroup.AliasName = dr["AliasName"].ToString();
EmployeeGroup.Primary = Convert.ToBoolean(dr["Primary"]);
EmployeeGroup.UnderGroup = dr["UnderGroup"].ToString();
}
return(EmployeeGroup);
}
public EmployeeGroupModel Update(int businessId, EmployeeGroupModel employeeGroup)
{
ApiRequest <EmployeeGroupModel, EmployeeGroupModel>($"/business/{businessId}/employeegroup/{employeeGroup.Id}", employeeGroup, Method.PUT);
return(Get(businessId, employeeGroup.Id));
}
