//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)); }