private void gvKitList_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
if (e.Column.Caption == "Edit")
{
Int64 nKitID = 0;
var row = gvKitList.GetFocusedDataRow();
nKitID = Convert.ToInt64(row[1]);
frmAddKit frmKit = new frmAddKit(nKitID);
frmKit.ShowDialog();
FillKitList();
}
if (e.Column.Caption == "Delete")
{
var row = gvKitList.GetFocusedDataRow();
int n = Convert.ToString(gvKitList.GetRowCellValue(e.RowHandle, "IsUsed")) == "" || Convert.ToString(gvKitList.GetRowCellValue(e.RowHandle, "IsUsed")) == "0" ? 0 : 1;
if (n == 1)
{
return;
}
if (MessageBox.Show("Do you want to delete?", clsGlobal._sMessageboxCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
KitMaster oKitMaster = new KitMaster();
oKitMaster.nKitID = Convert.ToInt64(row[1]);
if (oKitMaster.DeleteKit() > 0)
{
MessageBox.Show("Kit details deleted successfully.", clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (oKitMaster != null)
{
oKitMaster.Dispose();
oKitMaster = null;
}
//clsMasters oclsMaster = new clsMasters();
//oclsMaster.nMasterID = Convert.ToInt64(row[1]);
//oclsMaster.MasterType = this.MasterType;
//oclsMaster.DeleteMaster();
FillKitList();
}
if (e.Column.Caption == "Show Asset")
{
Int64 nKitID = 0;
var row = gvKitList.GetFocusedDataRow();
nKitID = Convert.ToInt64(row[1]);
frmMainKitAssetList oFrmAssetCodeList = new frmMainKitAssetList(nKitID);
oFrmAssetCodeList.ShowDialog();
FillKitList();
}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex, clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void FillKitInformation(long nKitID)
{
KitMaster oKitMaster = null;
DataSet ds = null;
try
{
oKitMaster = new KitMaster();
ds = oKitMaster.GetKitDetails(nKitID);
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtKitDetails = ds.Tables[0];
DataTable dtKitAssetDetails = ds.Tables[1];
if (dtKitDetails != null && dtKitDetails.Rows.Count > 0)
{
lblKitID.Text = Convert.ToString(dtKitDetails.Rows[0]["nKitID"]);
txtKitName.Text = Convert.ToString(dtKitDetails.Rows[0]["sKitName"]);
txtKitCode.Text = Convert.ToString(dtKitDetails.Rows[0]["sKitCode"]);
txtAbbrivation.Text = Convert.ToString(dtKitDetails.Rows[0]["sKitAbbrivation"]);
txtKitDescription.Text = Convert.ToString(dtKitDetails.Rows[0]["sKitDescription"]);
byte[] barcodeImage = (byte[])dtKitDetails.Rows[0]["Barcode"];
if (barcodeImage.Length > 0)
{
barcodeImage = (byte[])dtKitDetails.Rows[0]["Barcode"];
MemoryStream msHeaderImage = new MemoryStream(barcodeImage);
picBarcodeImage.Image = Image.FromStream(msHeaderImage);
}
}
if (dtKitAssetDetails != null)
{
gvAssetList.GridControl.DataSource = dtKitAssetDetails;
gvAssetList.Columns[1].Visible = false;
gvAssetList.Columns[2].Visible = false;
gvAssetList.Columns[5].Visible = false;
}
btnUpdateKit.Visible = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void FillAssetKitDetails(long nKitID)
{
KitMaster oKitMaster = null;
DataTable dtAssetCode = null;
try
{
oKitMaster = new KitMaster();
dtAssetCode = oKitMaster.GetKitAssetList(nKitID);
if (dtAssetCode != null)
{
gvKitAssetList.GridControl.DataSource = dtAssetCode;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void FillAssetCode(Int64 nKitID = 0)
{
KitMaster oKit = null;
try
{
oKit = new KitMaster();
dtAssetCode = oKit.GetKitAssetAssociation(nKitID);
if (dtAssetCode != null)
{
gvAssetList.GridControl.DataSource = dtAssetCode;
gvAssetList.Columns[1].Visible = false;
gvAssetList.Columns[2].Visible = false;
gvAssetList.Columns[5].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void FillKitList()
{
KitMaster oKitMaster = null;
DataTable dt = null;
try
{
oKitMaster = new KitMaster();
dt = oKitMaster.GetKitList(0);
if (dt != null)
{
gvKitList.GridControl.DataSource = dt;
gvKitList.Columns[1].Visible = false;
gvKitList.Columns[8].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void SaveKitDetils(bool bIsSaveKit_Asset = true)
{
KitMaster oKitMaster = null;
try
{
oKitMaster = new KitMaster();
oKitMaster.nKitID = Convert.ToInt64(lblKitID.Text);
oKitMaster.sKitName = txtKitName.Text.Trim();
oKitMaster.sKitCode = txtKitCode.Text.Trim();
oKitMaster.sKitAbbrivation = txtAbbrivation.Text.Trim();
oKitMaster.sKitDescription = txtKitDescription.Text.Trim();
byte[] BarcodeImage = new byte[] { };
if (picBarcodeImage != null)
{
if (picBarcodeImage.Image != null)
{
using (MemoryStream ms = new MemoryStream())
{
picBarcodeImage.Image.Save(ms, ImageFormat.Jpeg);
BarcodeImage = new byte[ms.Length];
ms.Position = 0;
ms.Read(BarcodeImage, 0, BarcodeImage.Length);
}
}
}
oKitMaster.kitBarcode = BarcodeImage;
List <KitAsset> lstKitAsset = new List <KitAsset>();
foreach (DataRow dr in dtAssetCode.Rows)
{
using (KitAsset oKitAsset = new KitAsset())
{
oKitAsset.nKitID = Convert.ToInt64(dr["nKitID"]);
oKitAsset.nKitAssetID = Convert.ToInt64(dr["nKitAssetID"]);
oKitAsset.nAssetID = Convert.ToInt64(dr["nAssetID"]);
oKitAsset.nAssetCodeID = Convert.ToInt64(dr["nAssetCodeID"]);
oKitAsset.sAssetName = Convert.ToString(dr["sAssetName"]);
oKitAsset.sUniqueCode = Convert.ToString(dr["sUniqueCode"]);
oKitAsset.sAssetNameWithCode = Convert.ToString(dr["assetNameWithCode"]);
lstKitAsset.Add(oKitAsset);
}
}
oKitMaster.lstKitDetails = lstKitAsset;
Int64 nKitID = oKitMaster.InsertUpdateKitDetails(bIsSaveKit_Asset);
if (nKitID == 0)
{
MessageBox.Show("Kit details not saved.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (nKitID == 2)
{
MessageBox.Show("Kit code already present. Please change asset code.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Kit details saved successfuly", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
ClearKit();
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.ToString(), clsGlobal._sMessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}