public void BindForm(ItemDetail item)
{
CertificateCharges.Text = item.CertificateCharges.ToString("C");
DesignCode.Text = item.DesignCode;
ItemCategory.Text = item.ItemCategory;
ItemDesc.Text = item.ItemDescription;
LabourCharges.Text = item.LabourCharges.ToString("C");
MetalNetAmount.Text = item.MetalDetail.MetalNetAmount.ToString("C");
MetalNetWt.Text = item.MetalDetail.MetalNetWt.ToString();
MetalType.Text = item.MetalDetail.MetalType;
StoneNetAmount.Text = item.StoneDetail.StoneNetAmount.ToString("C");
lblTotalAmount.Text = item.Amount.ToString("C");
StoneNetWt.Text = item.StoneDetail.StoneNetWt.ToString();
StoneType.Text = item.StoneDetail.StoneType;
TotalWeight.Text = item.TotalWeight.ToString();
lblStamping.Text = item.StampingCharges.ToString("C");
CStpe.Text = item.ColorStoneDetail.ColorStoneType;
CSwt.Text = item.ColorStoneDetail.ColorStoneNetWt.ToString();
CSnamt.Text = item.ColorStoneDetail.ColorStoneNetAmount.ToString("C");
_chart = item.StoneDetail.StoneChart;
TotalStonePcs.Text = item.StoneDetail.TotalStonePcs != 0 ? item.StoneDetail.TotalStonePcs.ToString()
: item.ColorStoneDetail.ColorTotalStonePcs.ToString();
JewelNumber.Text = item.DesignCode;
pictureBox.Image = ImageExtension.ResolveImage(item.DesignCode);
}
private void FindJewelByJewelNo(FindJewelBy findParam)
{
foreach (DataGridViewRow dgvr in dgvJewel.Rows)
{
var findCode = String.Empty;
var code = String.Empty;
if (findParam == FindJewelBy.JewelNo)
{
findCode = dgvr.Cells[_columnjewelnumber.ToLowerCaseColumnName()].Value.ToString();
code = txtBarCode.Text;
}
if (String.Compare(findCode, code, StringComparison.OrdinalIgnoreCase) == 0)
{
MessageBox.Show(findParam + Resources.frmMemoOrder_FindJewelByJewelNo__already_exists__Please_search_for_new_record_, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtBarCode.Text = String.Empty;
return;
}
}
JewelStockLedger JewelData = null;
if (findParam == FindJewelBy.JewelNo)
{
JewelData = _transactionServices.GetJewelStockByJewelNo(txtBarCode.Text);
}
if (!(JewelData != null && JewelData.StockStatus == StockStatus.ItemIsInStock))
{
MessageBox.Show(Resources.frmMemoOrder_FindJewelByJewelNo_Records_Not_found__);
txtBarCode.Text = String.Empty;
return;
}
int _newRowNumber = dgvJewel.RowCount;
dgvJewel.Rows.Add(1);
dgvJewel.Rows[_newRowNumber].Height = 50;
dgvJewel.Rows[_newRowNumber].Cells[_columnjewelnumber.ToLowerCaseColumnName()].Value = JewelData.JewelNumber;
dgvJewel.Rows[_newRowNumber].Cells[_columndesigncode.ToLowerCaseColumnName()].Value = JewelData.DesignCode;
dgvJewel.Rows[_newRowNumber].Cells[_columntype.ToLowerCaseColumnName()].Value = JewelData.JewelItemCategory;
dgvJewel.Rows[_newRowNumber].Cells[_columngoldkt.ToLowerCaseColumnName()].Value = JewelData.KT;
dgvJewel.Rows[_newRowNumber].Cells[_columntotalwt.ToLowerCaseColumnName()].Value = JewelData.TotalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columnmetalweight.ToLowerCaseColumnName()].Value = JewelData.MetalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columndiamondweight.ToLowerCaseColumnName()].Value = JewelData.StoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columndiapcs.ToLowerCaseColumnName()].Value = JewelData.StonePcs;
dgvJewel.Rows[_newRowNumber].Cells[_columncolwt.ToLowerCaseColumnName()].Value = JewelData.CStoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columncolpcs.ToLowerCaseColumnName()].Value = JewelData.CStonePcs;
dgvJewel[_columnimage.ToLowerCaseColumnName(), _newRowNumber].Value = ImageExtension.ResolveImage(JewelData.DesignCode);
dgvJewel.Rows[_newRowNumber].Cells[_columndgRemoveItem.ToLowerCaseColumnName()].Value = "Remove";
dgvJewel.FirstDisplayedScrollingRowIndex = dgvJewel.RowCount - 1;
CalculateTotal();
}
private void dgvJewel_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dataGridView = ((frmCatalogue)Owner).dgvJewel;
try
{
if (((DataGridView)sender).Columns[e.ColumnIndex].Name == "Select" & e.RowIndex >= 0)
{
if (dgvJewel.Columns[e.ColumnIndex].CellType == typeof(DataGridViewCheckBoxCell))
{
int dl;
for (dl = 0; dl <= dataGridView.Rows.Count - 1; dl++)
{
if (dataGridView.Rows[dl].Cells[2].Value.ToString().Trim() == dgvJewel.Rows[e.RowIndex].Cells[2].Value.ToString().Trim())
{
MessageBox.Show(Resources.frmProduct_dgvJewel_CellContentClick_Record_already_exists_, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dgvJewel.Rows[e.RowIndex].Cells[0].Value = false;
return;
}
}
dataGridView.Rows.Add(1);
dataGridView.Rows[AddProductToGrid].Cells[0].Value = true;
dataGridView.Rows[AddProductToGrid].Height = 100;
dataGridView.Rows[AddProductToGrid].Cells[2].Value = dgvJewel.Rows[e.RowIndex].Cells[2].Value;
dataGridView.Rows[AddProductToGrid].Cells[3].Value = dgvJewel.Rows[e.RowIndex].Cells[3].Value;
dataGridView.Rows[AddProductToGrid].Cells[4].Value = dgvJewel.Rows[e.RowIndex].Cells[4].Value;
dataGridView.Rows[AddProductToGrid].Cells[5].Value = dgvJewel.Rows[e.RowIndex].Cells[5].Value;
dataGridView.Rows[AddProductToGrid].Cells[6].Value = dgvJewel.Rows[e.RowIndex].Cells[6].Value;
dataGridView.Rows[AddProductToGrid].Cells[7].Value = dgvJewel.Rows[e.RowIndex].Cells[7].Value;
dataGridView.Rows[AddProductToGrid].Cells[8].Value = dgvJewel.Rows[e.RowIndex].Cells[8].Value;
dataGridView.Rows[AddProductToGrid].Cells[9].Value = dgvJewel.Rows[e.RowIndex].Cells[9].Value;
dataGridView.Rows[AddProductToGrid].Cells[10].Value = dgvJewel.Rows[e.RowIndex].Cells[10].Value;
var styleno = dataGridView.Rows[AddProductToGrid].Cells[6].Value;
dataGridView[1, AddProductToGrid].Value = ImageExtension.ResolveImage(styleno.ToString());
dgvJewel[1, GridRow].Value = ImageExtension.ResolveImage(styleno.ToString());
dataGridView.FirstDisplayedScrollingRowIndex = dataGridView.RowCount - 1;
AddProductToGrid = ((frmCatalogue)Owner).AddRowToGrid = ((frmCatalogue)Owner).AddRowToGrid + 1;
((frmCatalogue)Owner).CatalogueRequest.Add(new QueryRequest()
{
JewelNo = dgvJewel.Rows[e.RowIndex].Cells[2].Value.ToString(),
StyleNo = dgvJewel.Rows[e.RowIndex].Cells[3].Value.ToString(),
});
}
((frmCatalogue)Owner).GetTotal();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void BindForm(JewelStockLedger jewelStockLedger)
{
lblJewelNoValue.Text = jewelStockLedger.JewelNumber;
lblStyleNoValue.Text = jewelStockLedger.DesignCode;
//lblJewelDescValue.Text = jewelStockLedger.JewelDescription;
//lblMetalColorValue.Text = Convert.ToString(jewelStockLedger.MetalColor);
lblDiamondPcsValue.Text = Convert.ToString(jewelStockLedger.StonePcs);
lblDiamondWtValue.Text = Convert.ToString(jewelStockLedger.StoneWeight);
lblGoldPcsValue.Text = Convert.ToString(0.00);
lblGoldWtValue.Text = Convert.ToString(jewelStockLedger.StoneWeight);
pictureBox.Image = ImageExtension.ResolveImage(jewelStockLedger.DesignCode);
}
void _addtoPanel(JewelTransaction item)
{
var panel = new Panel {
Tag = item.JewelTransactionRowId
};
panel.MouseClick += JewelItemClick;
var menu = new ContextMenu();
menu.MenuItems.Add(new MenuItem("Remove Item", _itemremovefromPanel));
panel.ContextMenu = menu;
panel.BorderStyle = BorderStyle.FixedSingle;
panel.Cursor = Cursors.Hand;
panel.BackgroundImageLayout = ImageLayout.Stretch;
panel.Size = new Size(71, 46);
panel.BackgroundImage = ImageExtension.ResolveImage(item.DesignCode);
flowLayout.Controls.Add(panel);
}
private void FillGrid(int StartRow)
{
//var owner = (frmCatalogue)Owner;
//var Jewels = _jewelService.GetCatalogueJewels(owner.FromJewel, owner.ToJewel, owner.JewelDescription, owner.SelectedWeight);
IList <JewelMaster> Jewels;
Jewels = OWNERS.HasFilters ? _jewelService.GetCatalogueJewels(OWNERS.Filters) : _jewelService.GetCatalogueJewels(OWNERS.FromJewel, OWNERS.ToJewel, OWNERS.JewelDescription, OWNERS.SelectedWeight);
totalRecords = Jewels.Count;
if (totalRecords == 0)
{
MessageBox.Show(Resources.frmProduct_FillGrid_Records_Not_found__);
Close();
return;
}
var JewelData = Jewels.Skip(StartRow).Take(10).ToList();
dgvJewel.Rows.Clear();
GridRow = 0;
foreach (var jewel in JewelData)
{
dgvJewel.Rows.Add(1);
dgvJewel.Rows[GridRow].Height = 100;
dgvJewel.Rows[GridRow].Cells[2].Value = jewel.JewelNo;
dgvJewel.Rows[GridRow].Cells[3].Value = jewel.StyleNo;
dgvJewel.Rows[GridRow].Cells[4].Value = jewel.JewelDescription;
dgvJewel.Rows[GridRow].Cells[5].Value = jewel.MetalColor;
dgvJewel.Rows[GridRow].Cells[6].Value = ImageExtension.GetImageName(jewel.StyleNo);
dgvJewel.Rows[GridRow].Cells[7].Value = jewel.DiamondPcs;
dgvJewel.Rows[GridRow].Cells[8].Value = jewel.DiamondWt;
dgvJewel.Rows[GridRow].Cells[9].Value = jewel.GrsWt;
dgvJewel.Rows[GridRow].Cells[10].Value = jewel.NetWt;
dgvJewel[1, GridRow].Value = ImageExtension.ResolveImage(jewel.StyleNo);
GridRow = GridRow + 1;
}
lblTotItems.Text = Resources.frmProduct_FillGrid_ + Convert.ToString(dgvJewel.RowCount);
dgvJewel.Focus();
}
private void frmAllCatalogueProduct_Load(object sender, EventArgs e)
{
WindowState = FormWindowState.Normal;
lblProductName.Text = ((frmCatalogue)Owner).JewelDescription;
var JewelData = _jewelService.GetAllCatalogueJewels();
if (JewelData.Count == 0)
{
MessageBox.Show(Resources.frmAllCatalogueProduct_frmAllCatalogueProduct_Load_Record_s__Not_found__);
Close();
return;
}
dgvJewel.Rows.Clear();
GridRow = 0;
foreach (var jewel in JewelData)
{
dgvJewel.Rows.Add(1);
dgvJewel.Rows[GridRow].Height = 100;
dgvJewel.Rows[GridRow].Cells[2].Value = jewel.JewelNo;
dgvJewel.Rows[GridRow].Cells[3].Value = jewel.StyleNo;
dgvJewel.Rows[GridRow].Cells[4].Value = jewel.JewelDescription;
dgvJewel.Rows[GridRow].Cells[5].Value = jewel.MetalColor;
dgvJewel.Rows[GridRow].Cells[6].Value = ImageExtension.GetImageName(jewel.StyleNo);
dgvJewel.Rows[GridRow].Cells[7].Value = jewel.DiamondPcs;
dgvJewel.Rows[GridRow].Cells[8].Value = jewel.DiamondWt;
dgvJewel.Rows[GridRow].Cells[9].Value = jewel.GrsWt;
dgvJewel.Rows[GridRow].Cells[10].Value = jewel.NetWt;
dgvJewel[1, GridRow].Value = ImageExtension.ResolveImage(jewel.StyleNo);
GridRow = GridRow + 1;
dgvJewel.FirstDisplayedScrollingRowIndex = dgvJewel.RowCount - 1;
}
lblTotItems.Text = Resources.frmAllCatalogueProduct_frmAllCatalogueProduct_Load_ + Convert.ToString(dgvJewel.RowCount);
dgvJewel.Focus();
}
private void FindJewelByJewelNo(TransactionLookup lookup)
{
int _newRowNumber = dgvJewel.RowCount;
foreach (var Jeweldetail in lookup.JewelTransactions)
{
dgvJewel.Rows.Add(1);
dgvJewel.Rows[_newRowNumber].Height = 50;
dgvJewel.Rows[_newRowNumber].Cells[_columnselectchk.ToLowerCaseColumnName()].Value = true;
dgvJewel.Rows[_newRowNumber].Cells[_columnjewelnumber.ToLowerCaseColumnName()].Value = Jeweldetail.JewelNumber;
dgvJewel.Rows[_newRowNumber].Cells[_columndesigncode.ToLowerCaseColumnName()].Value = Jeweldetail.DesignCode;
dgvJewel.Rows[_newRowNumber].Cells[_columntotalwt.ToLowerCaseColumnName()].Value = Jeweldetail.TotalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columnmetalweight.ToLowerCaseColumnName()].Value = Jeweldetail.MetalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columnmetalcolor.ToLowerCaseColumnName()].Value = Jeweldetail.MetalColor;
dgvJewel.Rows[_newRowNumber].Cells[_columnstoneweight.ToLowerCaseColumnName()].Value = Jeweldetail.StoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columndesigncode.ToLowerCaseColumnName()].Value = Jeweldetail.DesignCode;
dgvJewel.Rows[_newRowNumber].Cells[_columnstonepcs.ToLowerCaseColumnName()].Value = Jeweldetail.StonePcs;
dgvJewel.Rows[_newRowNumber].Cells[_columncstoneweight.ToLowerCaseColumnName()].Value = Jeweldetail.CStoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columncstonepcs.ToLowerCaseColumnName()].Value = Jeweldetail.CStonePcs;
dgvJewel.Rows[_newRowNumber].Cells[_columntrno.ToLowerCaseColumnName()].Value = Jeweldetail.JewelTransactionId;
var state = _transactionServices.GetJewelStockByJewelNo(Jeweldetail.JewelNumber);
dgvJewel.Rows[_newRowNumber].Cells[_columnstate.ToLowerCaseColumnName()].Value = state.StockStatus.GetDescription();
dgvJewel.Rows[_newRowNumber].Cells[_columndetails.ToLowerCaseColumnName()].Value = "Details";
dgvJewel.Rows[_newRowNumber].Cells[_columndetails.ToLowerCaseColumnName()].Tag = Jeweldetail.JewelTransactionId;
dgvJewel[_columnimage.ToLowerCaseColumnName(), _newRowNumber].Value = ImageExtension.ResolveImage(Jeweldetail.DesignCode);
_newRowNumber = _newRowNumber + 1;
dgvJewel.FirstDisplayedScrollingRowIndex = dgvJewel.RowCount - 1;
}
}
private void FindJewel(FindJewelBy findParam)
{
foreach (DataGridViewRow dgvr in dgvJewel.Rows)
{
var findCode = "";
var code = "";
if (findParam == FindJewelBy.JewelNo)
{
findCode = dgvr.Cells["JewelNo"].Value.ToString();
code = txtBarCode.Text;
}
else if (findParam == FindJewelBy.StyleNo)
{
findCode = dgvr.Cells["StyleNo"].Value.ToString();
code = txtStyleNo.Text;
}
if (String.Compare(findCode, code, StringComparison.OrdinalIgnoreCase) == 0)
{
MessageBox.Show(findParam + Resources.frmBarCodeOrder_FindJewel__already_exists_Please_search_for_new_record_, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtBarCode.Text = String.Empty;
txtStyleNo.Text = String.Empty;
return;
}
}
JewelMaster JewelData = null;
if (findParam == FindJewelBy.JewelNo)
{
JewelData = _jewelService.GetJewelsByJewelNo(txtBarCode.Text);
}
else if (findParam == FindJewelBy.StyleNo)
{
JewelData = _jewelService.GetJewelsByStyleNo(txtStyleNo.Text);
}
if (JewelData == null)
{
MessageBox.Show(Resources.frmBarCodeOrder_FindJewel_Records_Not_found__);
txtBarCode.Text = String.Empty;
txtStyleNo.Text = String.Empty;
return;
}
int _newRow = dgvJewel.RowCount;
dgvJewel.Rows.Add(1);
dgvJewel.Rows[_newRow].Cells[0].Value = true;
dgvJewel.Rows[_newRow].Height = 100;
dgvJewel.Rows[_newRow].Cells[2].Value = JewelData.JewelNo;
dgvJewel.Rows[_newRow].Cells[3].Value = JewelData.StyleNo;
dgvJewel.Rows[_newRow].Cells[4].Value = JewelData.JewelDescription;
dgvJewel.Rows[_newRow].Cells[5].Value = JewelData.MetalColor;
dgvJewel.Rows[_newRow].Cells[6].Value = ImageExtension.GetImageName(JewelData.StyleNo);
dgvJewel.Rows[_newRow].Cells[7].Value = JewelData.DiamondPcs;
dgvJewel.Rows[_newRow].Cells[8].Value = JewelData.DiamondWt;
dgvJewel.Rows[_newRow].Cells[9].Value = JewelData.GrsWt;
dgvJewel.Rows[_newRow].Cells[10].Value = JewelData.NetWt;
dgvJewel[1, _newRow].Value = ImageExtension.ResolveImage(JewelData.StyleNo);
dgvJewel.FirstDisplayedScrollingRowIndex = dgvJewel.RowCount - 1;
CatalogueRequest.Add(new QueryRequest
{
JewelNo = JewelData.JewelNo,
StyleNo = JewelData.StyleNo,
});
GetTotal();
}
public void ShowStickerReport(IEnumerable <String> jewelNumbers)
{
var jewelStickerDataSet = new JewelStickerDataSet();
foreach (var jewelNo in jewelNumbers)
{
var jewel = _transactionService.GetJewelStockByJewelNo(jewelNo.Trim());
if (jewel == null)
{
continue;
}
var jewelMasterRow = jewelStickerDataSet.Tables["JewelSticker"].NewRow();
jewelMasterRow["JewelNumber"] = jewel.JewelNumber;
jewelMasterRow["DesignCode"] = jewel.DesignCode;
jewelMasterRow["NetWeight"] = jewel.MetalWeight;
jewelMasterRow["GrossWeight"] = jewel.TotalWeight;
jewelMasterRow["StoneWeight"] = jewel.StoneWeight;
jewelMasterRow["StonePcs"] = jewel.StonePcs;
jewelMasterRow["JewelImage"] = ImageConverterHelper.ImageToByteArray(ImageExtension.ResolveImage(jewel.DesignCode));
jewelStickerDataSet.Tables["JewelSticker"].Rows.Add(jewelMasterRow);
}
var orderReport = new frmReport
{
ReportPath = ResolveReportPath(ReportConstants.JewelStickerReport),
ReportDataSet = jewelStickerDataSet
};
orderReport.Show();
}
private void btnGo_Click(object sender, EventArgs e)
{
if (IsValid == false)
{
MessageBox.Show(AllErrors.ErrorMessageString(), Constants.ALERTMESSAGEHEADER);
return;
}
var customer = (Customer)cboCustomer.SelectedValue;
var ledger = _transactionServices.GetJewelStockLedgers();
dgvJewel.Rows.Clear();
var jewelTransactions = from tran in _transactionServices.GetJewelTransactions()
join lg in ledger on tran.JewelNumber equals lg.JewelNumber
where lg.JewelState_Enum == (short)JewelState.OnApproval &&
lg.StockStatus_Enum == (short)StockStatus.ItemOutOfStock &&
tran.TransactionLookup.TransactionPartyRef == customer.CustomersCode &&
tran.TransactionType_Enum == (short)TransactionType.ApprovalTransaction &&
tran.UpdatedTransactionBy == null
select tran;
foreach (var tran in jewelTransactions)
{
var _newRowNumber = dgvJewel.RowCount;
dgvJewel.Rows.Add(1);
dgvJewel.Rows[_newRowNumber].Height = 50;
dgvJewel.Rows[_newRowNumber].Cells[_columnselectchk.ToLowerCaseColumnName()].Value = false;
dgvJewel.Rows[_newRowNumber].Cells[_columnselectchk.ToLowerCaseColumnName()].Tag = tran.JewelTransactionId;
dgvJewel.Rows[_newRowNumber].Cells[_columnjewelnumber.ToLowerCaseColumnName()].Value = tran.JewelNumber;
dgvJewel.Rows[_newRowNumber].Cells[_columndesigncode.ToLowerCaseColumnName()].Value = tran.DesignCode;
dgvJewel.Rows[_newRowNumber].Cells[_columntype.ToLowerCaseColumnName()].Value = tran.JewelItemCategory;
dgvJewel.Rows[_newRowNumber].Cells[_columngoldkt.ToLowerCaseColumnName()].Value = tran.KT;
dgvJewel.Rows[_newRowNumber].Cells[_columntotalwt.ToLowerCaseColumnName()].Value = tran.TotalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columnmetalweight.ToLowerCaseColumnName()].Value = tran.MetalWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columndiamondweight.ToLowerCaseColumnName()].Value = tran.StoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columndiapcs.ToLowerCaseColumnName()].Value = tran.StonePcs;
dgvJewel.Rows[_newRowNumber].Cells[_columncolwt.ToLowerCaseColumnName()].Value = tran.CStoneWeight;
dgvJewel.Rows[_newRowNumber].Cells[_columncolpcs.ToLowerCaseColumnName()].Value = tran.CStonePcs;
dgvJewel.Rows[_newRowNumber].Cells[_columntotalAmount.ToLowerCaseColumnName()].Value = tran.TotalAmount;
dgvJewel[_columnimage.ToLowerCaseColumnName(), _newRowNumber].Value = ImageExtension.ResolveImage(tran.DesignCode);
dgvJewel.FirstDisplayedScrollingRowIndex = dgvJewel.RowCount - 1;
}
}