private void createUnit(int deviceID, int typeID)
{
Units _units = new Units();
ProcessUnitManagementQueries _unitManagement = new ProcessUnitManagementQueries(AlarmasABC.BLL.InvokeOperations.operations.INSERT);
try
{
_units.UnitID = deviceID;
_units.UnitName = deviceID.ToString();
_units.TypeID = typeID;
_units.IconName = "redcar";
_units.ComID = comID;
_unitManagement.Units = _units;
_unitManagement.invoke();
/*DataSet _ds = new DataSet();
ExecuteSQL exec = new ExecuteSQL();
_ds = exec.getDataSet("SELECT unitID FROM tblUnits WHERE deviceID = " + deviceID +
" AND unitName = '" + deviceID + "' AND comID = " + comID);
int unitID = int.Parse(_ds.Tables[0].Rows[0][0].ToString());
if (unitID < 1)
{
return -1;
}
return unitID;*/
}
catch (Exception ex)
{
throw new Exception("CreateNewAccount::createUnit(): " + ex.Message.ToString());
}
finally
{
_units = null;
_unitManagement = null;
}
}
private bool updateUserInfo(int UnitID, string companyID)
{
string _listValue = _hListValue.Value;
string[] _listItem = _listValue.Split(';');
if (_listItem.Length > 1)
{
deleteUnitUserInforamtion(UnitID, companyID);
for (int i = 0; i < _listItem.Length - 1; ++i)
{
Units _unit = new Units();
ProcessUnitManagementQueries _unitmangmnt = new ProcessUnitManagementQueries(_unit);
try
{
_unit.GroupID = int.Parse(_listItem[i]);
_unit.UnitID = UnitID;
_unit.ComID = int.Parse(companyID);
_unitmangmnt.Units = _unit;
_unitmangmnt.updateUnitUserInfo();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
_unit = null;
_unitmangmnt = null;
}
}
}
return true;
}
private void updateInfo(string iconName, string companyID)
{
string patternID = cmbPattern.SelectedValue.ToString();
int comID = int.Parse(companyID);
//DateTime pDate = new DateTime();
//DateTime dDate = new DateTime();
//if (txtUnitPerchaseDate.SelectedDate.ToString() != "")
// pDate = Convert.ToDateTime(txtUnitPerchaseDate.SelectedDate.ToString());
//else
// pDate = Convert.ToDateTime("01/01/2000");
//if (txtDevicePerchaseDate.SelectedDate.ToString() != "")
// dDate = Convert.ToDateTime(txtDevicePerchaseDate.SelectedDate.ToString());
//else
// dDate = Convert.ToDateTime("01/01/2000");
Units _units = new Units();
ProcessUnitManagementQueries _unitManagement = new ProcessUnitManagementQueries(AlarmasABC.BLL.InvokeOperations.operations.UPDATE);
try
{
_units.UnitID = int.Parse(cmbUnitName.SelectedValue.ToString());
_units.UnitName = txtName.Text.Trim();
_units.LicenseID = txtLicense.Text.Trim();
//_units.DriverName = txtDriver.Text.Trim();
//_units.VIN = txtVIN.Text.Trim();
//_units.ModelID = int.Parse(cmbUnitModel.SelectedValue.ToString());
//_units.Unitpurchasedate = pDate;
//_units.LevelArmor = cmbArmor.SelectedValue.ToString();
//_units.Wtint = txtWindowtIntScheme.Text.Trim();
//_units.Package = cmbCommonPackage.SelectedValue.ToString();
//_units.UnitColor = txtUnitColor.Text.Trim();
//_units.KeyCode = txtKeyCode.Text.Trim();
//_units.Unitfueltype = int.Parse(cmbFuel.SelectedValue.ToString());
//_units.DevicePurchaseLocation = txtDevicePerchaseLocation.Text.Trim();
//_units.DevicePurchaseDate = dDate;
//if (txtunitCost.Text.ToString() != "")
//{
// _units.Unitcost = int.Parse(txtunitCost.Text.Trim());
//}
//else
//{
// txtunitCost.Text = "0";
// _units.Unitcost = int.Parse(txtunitCost.Text.Trim());
//}
//_units.CounterIED = txtCounterIED.Text.Trim();
_units.TypeID = int.Parse(cmbVehicleCat.SelectedValue.ToString());
_units.IconName = iconName;
_units.OtherInfo = txtOtherInfo.Text.Trim();
_units.PatternID = int.Parse(patternID);
_unitManagement.Units = _units;
_unitManagement.invoke();
int UnitID = int.Parse(cmbUnitName.SelectedValue.ToString());
if (updateUserInfo(UnitID, companyID))
{
lblMessage.Text = "Unit " + _units.UnitName + " Updated Successfully...";
clearControls();
}
else
clearData(UnitID.ToString());
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
_units = null;
_unitManagement = null;
}
}
private void saveInfo(string iconName, string companyID)
{
string patternID = cmbPattern.SelectedValue.ToString();
int comID = int.Parse(companyID);
Units _units = new Units();
ProcessUnitManagementQueries _unitManagement = new ProcessUnitManagementQueries(AlarmasABC.BLL.InvokeOperations.operations.INSERT);
ProcessUnitManagementQueries _umg = new ProcessUnitManagementQueries();
DataSet _ds = new DataSet();
try
{
_units.UnitID = int.Parse(txtDevice.Text.Trim());
_units.UnitName = txtName.Text.Trim();
_units.LicenseID = txtLicense.Text.Trim();
_units.TypeID = int.Parse(cmbVehicleCat.SelectedValue.ToString());
_units.IconName = iconName;
_units.ComID = comID;
_units.OtherInfo = txtOtherInfo.Text.Trim();
_units.PatternID = int.Parse(patternID);
_unitManagement.Units = _units;
_unitManagement.invoke();
_umg.MaxUnitId();
_ds = _umg.Ds;
int UnitID = int.Parse(_ds.Tables[0].Rows[0][0].ToString());
saveUserInfo(UnitID, companyID);
lblMessage.Text = "Unit \"" + _units.UnitName + "\" Setup Successfully...";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
throw new Exception(ex.Message.ToString());
}
finally
{
_units = null;
_unitManagement = null;
_umg = null;
_ds = null;
}
}
private void loadVehicleInfo(string _UnitId, string _ComID)
{
Units _units = new Units();
try
{
_units.UnitID = int.Parse(_UnitId);
ProcessUnitManagementQueries _UnitManagement = new ProcessUnitManagementQueries(AlarmasABC.BLL.InvokeOperations.operations.SELECT);
_UnitManagement.Units = _units;
_UnitManagement.invoke();
DataSet _ds = _UnitManagement.Ds;
cmbVehicleCat.SelectedValue = _ds.Tables[0].Rows[0]["typeID"].ToString();
txtLicense.Text = _ds.Tables[0].Rows[0]["LicenseID"].ToString();
txtName.Text = _ds.Tables[0].Rows[0]["unitName"].ToString();
txtDevice.Text = _ds.Tables[0].Rows[0]["deviceID"].ToString();
txtOtherInfo.Text = _ds.Tables[0].Rows[0]["otherInfo"].ToString();
loadImage(_UnitId, _ComID);
if (_ds.Tables[0].Rows[0]["patternID"].ToString() != "")
cmbPattern.SelectedValue = _ds.Tables[0].Rows[0]["patternID"].ToString();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
_units = null;
}
}
private void loadImage(string _Unitid, string _comId)
{
Units _unit = new Units();
_unit.UnitID = int.Parse(_Unitid);
_unit.ComID = int.Parse(_comId);
ProcessUnitManagementQueries _UnitImage = new ProcessUnitManagementQueries(_unit);
_UnitImage.loadImage();
DataSet _ds = _UnitImage.Ds;
if (_ds.Tables[0].Rows.Count > 0)
{
imgIcon.Src = "";
imgIcon.Src = "../Icon/" + _ds.Tables[0].Rows[0][0].ToString() + ".png";
}
else
{
}
}
private void deleteUnitUserInforamtion(int UnitId, string ComID)
{
Units _unit = new Units();
ProcessUnitManagementQueries _unitmangmnt = new ProcessUnitManagementQueries(_unit);
try
{
_unit.UnitID = UnitId;
_unit.ComID = int.Parse(ComID);
_unitmangmnt.Units = _unit;
_unitmangmnt.deleteUnitUserInfo();
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
finally
{
_unit = null;
_unitmangmnt = null;
}
}
private void clearData(string ID)
{
Units _unit = new Units();
_unit.UnitID = int.Parse(ID);
ProcessUnitManagementQueries _UmgtQry = new ProcessUnitManagementQueries(_unit);
_UmgtQry.Units = _unit;
_UmgtQry.clearUnitData();
}
private bool CheckInfo(string comID)
{
Units _unit = new Units();
_unit.ComID = int.Parse(comID);
_unit.UnitID = int.Parse(txtDevice.Text.Trim());
_unit.UnitName = txtName.Text;
ProcessUnitManagementQueries processmgmt = new ProcessUnitManagementQueries(_unit);
processmgmt.Units = _unit;
processmgmt.checkUnitExist();
DataSet _ds = processmgmt.Ds;
if (_ds.Tables[0].Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}