private void SaveUnitType() { AlarmasABC.Core.Admin.UnitType _unitType = new AlarmasABC.Core.Admin.UnitType(); ProcessUnitTypeNotQueries insert = new ProcessUnitTypeNotQueries(AlarmasABC.BLL.InvokeOperations.operations.INSERT); try { _unitType.TypeName = _txtTypeName.Text; string _comID = Session["trkCompany"].ToString(); _unitType.ComID = int.Parse(_comID); insert.UnitType = _unitType; insert.invoke(); clearControls(); _lblMessage.ForeColor = System.Drawing.Color.Green; _lblMessage.Text = "Unit Type created Successfully."; } catch (Exception ex) { throw new Exception(" CompanyAdmin::UnitType:: " + ex.Message.ToString()); _lblMessage.ForeColor = System.Drawing.Color.Red; _lblMessage.Text = "Unit Type create fail."; } finally { _unitType = null; } }
protected void _rgrdtype_DeleteCommand(object source, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; string _typeID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["typeID"].ToString(); string _tName = ((Label)e.Item.FindControl("lbltypeName")).Text; if (!UnitExist(_typeID)) { ProcessUnitTypeNotQueries delete = new ProcessUnitTypeNotQueries(AlarmasABC.BLL.InvokeOperations.operations.DELETE); AlarmasABC.Core.Admin.UnitType _unitType = new AlarmasABC.Core.Admin.UnitType(); try { _unitType.TypeID = int.Parse(_typeID); delete.UnitType = _unitType; delete.invoke(); } catch (Exception ex) { throw new Exception(" :: " + ex.Message); } finally { _unitType = null; } } else { _lblMessage.Text = "Unit category "+_tName+ " in use and can't be deleted"; } }
protected void _rgrdtype_UpdateCommand(object source, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; string _typeID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["typeID"].ToString(); string _typeName = (editedItem["typeName"].Controls[0] as TextBox).Text; AlarmasABC.Core.Admin.UnitType _unitType = new AlarmasABC.Core.Admin.UnitType(); ProcessUnitTypeNotQueries _updateType = new ProcessUnitTypeNotQueries(AlarmasABC.BLL.InvokeOperations.operations.UPDATE); try { _unitType.Name = _typeName; _unitType.TypeID = int.Parse(_typeID); _unitType.ComID = int.Parse(Session["trkCompany"].ToString()); _updateType.UnitType = _unitType; _updateType.invoke(); } catch (Exception ex) { throw new Exception(" CompanyAdmin::UnitType:: " + ex.Message.ToString()); } finally { _unitType = null; _updateType = null; } _lblMessage.Text = "Unit Type Updated Successfully."; _lblMessage.ForeColor = System.Drawing.Color.Green; }
private int createUnitGroup(string name) { AlarmasABC.Core.Admin.UnitType unitType = new AlarmasABC.Core.Admin.UnitType(); ProcessUnitTypeNotQueries insert = new ProcessUnitTypeNotQueries(AlarmasABC.BLL.InvokeOperations.operations.INSERT); try { unitType.TypeName = name; unitType.ComID = comID; insert.UnitType = unitType; insert.invoke(); DataSet _ds = new DataSet(); ExecuteSQL exec = new ExecuteSQL(); _ds = exec.getDataSet("SELECT typeID FROM tblUnitType WHERE comID = " + comID + " AND typeName = '" + name + "';"); int typeID = int.Parse(_ds.Tables[0].Rows[0][0].ToString()); if (typeID < 1) { return -1; } return typeID; } catch (Exception ex) { throw new Exception(" CreateNewAccount::createUnitGroup(): " + ex.Message.ToString()); } finally { unitType = null; } }