private void FillScannerConfigDetl()
{
objFixedAsssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
try
{
if (cbSystemID.SelectedIndex > 0)
{
dt = objFixedAsssetDB.GetScannerConfigurationID(cbBranch.SelectedValue.ToString()).Tables[0];
}
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr[0] = "--Select--";
dt.Rows.InsertAt(dr, 0);
cbScanner.DataSource = dt;
cbScanner.DisplayMember = "DisplayMember";
cbScanner.ValueMember = "ValueMember";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDb = null;
dt = null;
}
}
private void FillEmployeeDetails()
{
objFixedAsssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
try
{
if (cbSystemID.SelectedIndex > 0)
{
dt = objFixedAsssetDB.GetAssetSlNos("", cbSystemID.SelectedValue.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
txtEmpName.Text = dt.Rows[0]["EmpName"].ToString();
txtMobileNo.Text = dt.Rows[0]["ContactNo"].ToString();
txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objFixedAsssetDB = null;
dt = null;
}
}
private void FillAssetConfigDetails()
{
objAssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
dtConfigDetl.Rows.Clear();
try
{
dt = objAssetDB.GetFixedAssetsConfigurationDetails(txtAssetSLNo.Text.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dtConfigDetl.Rows.Add(new object[] { "-1", dt.Rows[i]["Config_AssetId"].ToString(),
dt.Rows[i]["Config_Capacity"].ToString(),
dt.Rows[i]["Config_Type"].ToString(),
dt.Rows[i]["Config_Make"].ToString(),
dt.Rows[i]["Config_Model"].ToString(),
dt.Rows[i]["Config_Qty"].ToString() });
GetAssetConfigDetails();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void FillSystemID()
{
objFixedAsssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
cbSystemID.DataSource = null;
try
{
if (cbBranch.SelectedIndex > 0)
{
dt = objFixedAsssetDB.GetAssetSlNos(cbBranch.SelectedValue.ToString(), "").Tables[0];
if (dt.Rows.Count > 0)
{
DataRow dr = dt.NewRow();
dr[0] = "--Select--";
dt.Rows.InsertAt(dr, 0);
cbSystemID.DataSource = dt;
cbSystemID.DisplayMember = "DisplayMember";
cbSystemID.ValueMember = "ValueMember";
}
else
{
cbSystemID.SelectedIndex = -1;
cbMoniter.SelectedIndex = -1;
cbMotherboard.SelectedIndex = -1;
cbPrinter.SelectedIndex = -1;
cbProcesor.SelectedIndex = -1;
cbRAM.SelectedIndex = -1;
cbScanner.SelectedIndex = -1;
cbHDD.SelectedIndex = -1;
cbDVDorCD.SelectedIndex = -1;
cbWebCam.SelectedIndex = -1;
cbBiometrcs.SelectedIndex = -1;
cbOperatingSys.SelectedIndex = -1;
cbAntivirus.SelectedIndex = -1;
txtEmpName.Text = "";
txtMobileNo.Text = "";
txtAssetTagNo.Text = "";
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDb = null;
dt = null;
}
}
private void GetPreviousServiceDetails()
{
objAssetdb = new FixedAssetsDB();
DataTable dt = new DataTable();
gvAssetServiceDetails.Rows.Clear();
//string CompCode = cbCompany.SelectedValue.ToString();
//string BranCode = cbBranch.SelectedValue.ToString();
//string AssetType = cbAssetType.SelectedValue.ToString();
if (cbAssetId.SelectedIndex > 0)
{
try
{
dt = objAssetdb.GetFixedAssetsServiceDetails(cbAssetId.SelectedValue.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
gvAssetServiceDetails.Rows.Add();
gvAssetServiceDetails.Rows[i].Cells["SLNO"].Value = (i + 1).ToString();
gvAssetServiceDetails.Rows[i].Cells["TransactionNo"].Value = dt.Rows[i]["ServiceTrnNo"].ToString();
gvAssetServiceDetails.Rows[i].Cells["AssetId"].Value = dt.Rows[i]["AssetSLNO"].ToString();
gvAssetServiceDetails.Rows[i].Cells["AssetType"].Value = dt.Rows[i]["AssetType"].ToString();
gvAssetServiceDetails.Rows[i].Cells["ServiceType"].Value = dt.Rows[i]["ServiceType"].ToString();
gvAssetServiceDetails.Rows[i].Cells["ServiceDate"].Value = Convert.ToDateTime(dt.Rows[i]["ServiceDate"].ToString()).ToString("dd/MMM/yyyy");
gvAssetServiceDetails.Rows[i].Cells["ServiceCost"].Value = dt.Rows[i]["ServiceCost"].ToString();
gvAssetServiceDetails.Rows[i].Cells["ServiceRemarks"].Value = dt.Rows[i]["ServiceRemarks"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objAssetdb = null;
dt = null;
}
}
}
private void FillSystemConfigurationDetails()
{
objFixedAsssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
try
{
dt = objFixedAsssetDB.GetSystemConfigDtails(cbSystemID.SelectedValue.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
flagUpdate = true;
cbRAM.SelectedValue = dt.Rows[0]["Ram"].ToString();
cbHDD.SelectedValue = dt.Rows[0]["HDD"].ToString();
cbProcesor.SelectedValue = dt.Rows[0]["Processor"].ToString();
cbMotherboard.SelectedValue = dt.Rows[0]["MotherBoard"].ToString();
cbMoniter.SelectedValue = dt.Rows[0]["Moniter"].ToString();
cbDVDorCD.SelectedValue = dt.Rows[0]["CDorDvd"].ToString();
cbPrinter.SelectedValue = dt.Rows[0]["PrinterId"].ToString();
cbScanner.SelectedValue = dt.Rows[0]["ScannerId"].ToString();
cbBiometrcs.SelectedValue = dt.Rows[0]["BioMetricss"].ToString();
cbWebCam.SelectedValue = dt.Rows[0]["WebCam"].ToString();
cbOperatingSys.SelectedValue = dt.Rows[0]["OperatindSys"].ToString();
cbAntivirus.SelectedValue = dt.Rows[0]["Antivirus"].ToString();
}
else
{
flagUpdate = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objDb = null;
dt = null;
}
}
private void FillAssetsDetails()
{
objFixedAssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
if (txtAssetSLNo.Text != "")
{
try
{
dt = objFixedAssetDB.GetFixedAssetsData(txtAssetSLNo.Text.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
flagUpdate = true;
//txtAssetTagNo.ReadOnly = true;
//txtAssetCost.ReadOnly = true;
//dtpGivenDate.Enabled = false;
cbToComp.Enabled = false;
cbToBranch.Enabled = false;
//txtEcode.ReadOnly = true;
txtAssetSLNo.Tag = dt.Rows[0]["AssetId"].ToString();
cbAssetType.SelectedValue = dt.Rows[0]["Asset_Type"].ToString();
cbAssetMake.SelectedValue = dt.Rows[0]["Asset_Make"].ToString();
cbAssetModel.SelectedValue = dt.Rows[0]["Asset_Model"].ToString();
dtpGivenDate.Value = Convert.ToDateTime(dt.Rows[0]["Given_Date"].ToString());
cbStatus.SelectedItem = dt.Rows[0]["Status"].ToString();
txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString();
txtAssetCost.Text = dt.Rows[0]["AssetCost"].ToString();
AssetMovementId = Convert.ToInt32(dt.Rows[0]["Movement_Id"].ToString());
TrnNo = Convert.ToInt32(dt.Rows[0]["Trn_No"].ToString());
if (dt.Rows[0]["Trn_Type"].ToString().Equals("BR2GC"))
{
cbTrnType.Text = "BR2EMPLOYEE";
}
else
{
cbTrnType.Text = dt.Rows[0]["Trn_Type"].ToString();
}
cbToComp.SelectedValue = dt.Rows[0]["AtComp"].ToString();
cbToBranch.SelectedValue = dt.Rows[0]["AtBranch"].ToString();
txtDept.Text = dt.Rows[0]["DeptName"].ToString();
txtDesig.Text = dt.Rows[0]["DesigName"].ToString();
txtContactNo.Text = dt.Rows[0]["ContNo"].ToString();
string ToEcode = dt.Rows[0]["To_Ecode"].ToString();
txtEcode.Text = ToEcode;
txtEcode_KeyUp(null, null);
if (txtContactNo.Text.Length == 0)
{
txtContactNo.Text = dt.Rows[0]["ContNo"].ToString();
}
}
else if (dt.Rows.Count == 0)
{
GenerateAssetSLNo();
flagUpdate = false;
isDetlUpdate = false;
TrnNo = 0;
AssetMovementId = 0;
dtpGivenDate.Value = DateTime.Today;
cbToComp.SelectedIndex = 0;
cbToBranch.SelectedIndex = -1;
txtEcode.Text = "";
txtEName.Text = "";
cbAssetType.SelectedIndex = 0;
cbAssetModel.SelectedIndex = -1;
cbAssetMake.SelectedIndex = -1;
cbStatus.SelectedIndex = 0;
txtDesig.Text = "";
txtDept.Text = "";
dtpGivenDate.Enabled = true;
cbToComp.Enabled = true;
cbToBranch.Enabled = true;
txtEcode.ReadOnly = false;
txtAssetTagNo.ReadOnly = false;
txtAssetCost.ReadOnly = false;
txtAssetTagNo.Text = "";
txtAssetCost.Text = "";
cbTrnType.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objFixedAssetDB = null;
dt = null;
}
}
}
private void FillAssetsDetails()
{
objAssetDB = new FixedAssetsDB();
DataTable dt = new DataTable();
if (txtAssetSLNo.Text != "")
{
try
{
dt = objAssetDB.GetFixedAssetsData(txtAssetSLNo.Text.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
isHeadUpdate = true;
cbAssetType.Enabled = false;
cbAssetMake.Enabled = false;
cbAssetModel.Enabled = false;
cbSupplier.Enabled = false;
dtpPurchaseDate.Enabled = false;
txtAssetTagNo.ReadOnly = true;
txtAssetCost.ReadOnly = true;
dtpGivenDate.Enabled = false;
cbToComp.Enabled = false;
cbToBranch.Enabled = false;
txtToEcode.ReadOnly = true;
cbTrnType.Enabled = false;
txtAssetSLNo.Tag = dt.Rows[0]["AssetId"].ToString();
cbAssetType.SelectedValue = dt.Rows[0]["Asset_Type"].ToString();
cbAssetMake.SelectedValue = dt.Rows[0]["Asset_Make"].ToString();
cbAssetModel.SelectedValue = dt.Rows[0]["Asset_Model"].ToString();
cbSupplier.SelectedValue = dt.Rows[0]["Supplier_Id"].ToString();
if (dt.Rows[0]["Purchase_Date"].ToString().Length > 0)
{
dtpPurchaseDate.Value = Convert.ToDateTime(dt.Rows[0]["Purchase_Date"]);
}
dtpGivenDate.Value = Convert.ToDateTime(dt.Rows[0]["Given_Date"].ToString());
cbStatus.SelectedItem = dt.Rows[0]["Status"].ToString();
AssetMovementId = Convert.ToInt32(dt.Rows[0]["Movement_Id"].ToString());
txtAssetTagNo.Text = dt.Rows[0]["TagNo"].ToString();
txtAssetCost.Text = dt.Rows[0]["AssetCost"].ToString();
TrnNo = Convert.ToInt32(dt.Rows[0]["Trn_No"].ToString());
if (dt.Rows[0]["Trn_Type"].ToString().Equals("BR2GC"))
{
cbTrnType.Text = "BR2EMPLOYEE";
}
else
{
cbTrnType.Text = dt.Rows[0]["Trn_Type"].ToString();
}
cbToComp.Text = dt.Rows[0]["To_Comp_Name"].ToString();
cbToBranch.SelectedValue = dt.Rows[0]["To_Branch"].ToString();
string ToEcode = dt.Rows[0]["To_Ecode"].ToString();
if (ToEcode.Length > 3)
{
txtToEcode.Text = ToEcode;
}
}
else if (dt.Rows.Count == 0)
{
isHeadUpdate = false;
isDetlUpdate = false;
//cbAssetType.SelectedIndex = 0;
GenerateAssetSLNo();
//cbAssetMake.SelectedIndex = -1;
//cbAssetModel.SelectedIndex = -1;
cbSupplier.SelectedIndex = 0;
dtpPurchaseDate.Value = DateTime.Today;
dtpGivenDate.Value = DateTime.Today;
cbTrnType.SelectedIndex = 0;
cbToComp.SelectedIndex = 0;
cbToBranch.SelectedIndex = -1;
txtToEcode.Text = "";
txtToEName.Text = "";
dtConfigDetl.Rows.Clear();
gvAssetConfigDetails.Rows.Clear();
cbStatus.SelectedIndex = 0;
cbAssetType.Enabled = true;
cbAssetMake.Enabled = true;
cbAssetModel.Enabled = true;
cbSupplier.Enabled = true;
dtpPurchaseDate.Enabled = true;
cbTrnType.Enabled = true;
dtpGivenDate.Enabled = true;
cbToComp.Enabled = true;
cbToBranch.Enabled = true;
txtToEcode.ReadOnly = false;
txtAssetTagNo.ReadOnly = false;
txtAssetCost.ReadOnly = false;
txtAssetTagNo.Text = "";
txtAssetCost.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objAssetDB = null;
dt = null;
}
}
}
