private void gvAssetList_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
if (e.Column.Caption == "Edit")
{
Int64 nKitID = 0;
var row = gvAssetList.GetFocusedDataRow();
lblKitAssetID.Text = Convert.ToString(row[1]);
lblKitID.Text = Convert.ToString(row[2]);
lblAssetID.Text = Convert.ToString(row[3]);
lblAssetCodeID.Text = Convert.ToString(row[4]);
lblAssetCodeName.Text = Convert.ToString(row[7]);
DataTable dtAssetList = (DataTable)cmbAssetList.DataSource;
DataRow drAsset = dtAssetList.NewRow();
drAsset["nAssetCodeID"] = lblAssetCodeID.Text;
drAsset["sAssetCodeName"] = Convert.ToString(row[7]);
dtAssetList.Rows.InsertAt(drAsset, 0);
cmbAssetList.DataSource = dtAssetList;
cmbAssetList.DisplayMember = "sAssetCodeName";
cmbAssetList.ValueMember = "nAssetCodeID";
cmbAssetList.SelectedIndex = 0;
btnAddAsset.Text = "Edit";
}
if (e.Column.Caption == "Delete")
{
var row = gvAssetList.GetFocusedDataRow();
int n = Convert.ToString(gvAssetList.GetRowCellValue(e.RowHandle, "IsUsed")) == "" || Convert.ToString(gvAssetList.GetRowCellValue(e.RowHandle, "IsUsed")) == "0" ? 0 : 1;
if (n == 1)
{
return;
}
if (Convert.ToInt64(lblKitID.Text) > 0)
{
Int64 nKitAssetID = Convert.ToInt64(row["nKitAssetID"]);
KitAsset oKitAsset = new KitAsset();
oKitAsset.nKitAssetID = nKitAssetID;
if (oKitAsset.DeleteKitAsset() > 0)
{
MessageBox.Show("Asset code deleted successfully.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Asset code not deleted.", clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
FillAssetCode(Convert.ToInt64(lblKitID.Text));
if (oKitAsset != null)
{
oKitAsset.Dispose();
oKitAsset = null;
}
}
else
{
Int64 nAssetCodeID = Convert.ToInt64(row["nAssetCodeID"]);
DataRow[] drDelete = dtAssetCode.Select("nAssetCodeID=" + Convert.ToInt64(nAssetCodeID));
foreach (DataRow dr in drDelete)
{
dr.Delete();
}
dtAssetCode.AcceptChanges();
int nRow = 0;
foreach (DataRow dr in dtAssetCode.Rows)
{
nRow++;
dr["RowNo"] = nRow;
}
//gvAssetList.GridControl.DataSource = dtAssetCode;
//gvAssetList.RefreshData();
}
gvAssetList.GridControl.DataSource = dtAssetCode;
gvAssetList.RefreshData();
FillAllAsset();
}
}
catch (Exception ex)
{
MessageBox.Show("Error : " + ex, clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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);
}
}
private void btnAddAsset_Click(object sender, EventArgs e)
{
try
{
if (ValidateAssetCode())
{
int num = 0;
string sValue = string.Empty;
num = dtAssetCode.Rows.Count;
num++;
sValue = num.ToString();
if (num < 1000)
{
sValue = num.ToString("000");
}
if (Convert.ToInt64(lblKitID.Text) > 0)
{
KitAsset oKitAsset = null;
if (btnAddAsset.Text.ToLower() == "add")
{
string[] sKitAssetName = cmbAssetList.Text.Trim().Split('-');
oKitAsset = new KitAsset();
oKitAsset.nAssetID = 0;
oKitAsset.nAssetCodeID = Convert.ToInt64(cmbAssetList.SelectedValue);
oKitAsset.nKitAssetID = 0;
oKitAsset.nKitID = Convert.ToInt64(lblKitID.Text);
oKitAsset.sAssetName = Convert.ToString(sKitAssetName[0]);
oKitAsset.sUniqueCode = Convert.ToString(sKitAssetName[1]);
oKitAsset.sAssetNameWithCode = Convert.ToString(cmbAssetList.Text);
}
else if (btnAddAsset.Text.ToLower() == "edit")
{
string[] sKitAssetName = cmbAssetList.Text.Trim().Split('-');
oKitAsset = new KitAsset();
oKitAsset.nAssetID = Convert.ToInt64(lblAssetID.Text);
oKitAsset.nAssetCodeID = Convert.ToInt64(lblAssetCodeID.Text);
oKitAsset.nKitAssetID = Convert.ToInt64(lblKitAssetID.Text);
oKitAsset.nKitID = Convert.ToInt64(lblKitID.Text);
oKitAsset.sAssetName = Convert.ToString(sKitAssetName[0]);
oKitAsset.sUniqueCode = Convert.ToString(sKitAssetName[1]);
oKitAsset.sAssetNameWithCode = Convert.ToString(lblAssetCodeName.Text);
}
Int64 nStatus = oKitAsset.UpdateAssetCode();
if (nStatus > 0)
{
FillAssetCode(oKitAsset.nKitID);
}
}
else
{
string[] sKitAssetName = cmbAssetList.Text.Trim().Split('-');
DataRow drKit = dtAssetCode.NewRow();
drKit["RowNo"] = num;
drKit["nKitAssetID"] = 0;
drKit["nKitID"] = 0;
drKit["nAssetID"] = 0;
drKit["nAssetCodeID"] = Convert.ToInt64(cmbAssetList.SelectedValue);
drKit["sUniqueCode"] = sKitAssetName[1];
drKit["sAssetName"] = sKitAssetName[0];
drKit["assetNameWithCode"] = cmbAssetList.Text.Trim();
dtAssetCode.Rows.Add(drKit);
gvAssetList.GridControl.DataSource = dtAssetCode;
gvAssetList.Columns[1].Visible = false;
gvAssetList.Columns[2].Visible = false;
gvAssetList.Columns[5].Visible = false;
}
ClearKitDetails();
}
}
catch (Exception ex)
{
MessageBox.Show("Error asset code: " + ex.ToString(), clsGlobal.MessageboxCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}