private void setMakingAndOtherCharges(int svno, int tid, SalesLineItemDetail lineItem)
{
double diamondValue = 0;
double stoneValue = 0;
string sqlQry = "SELECT * FROM SALESBILLDETAIL WHERE TID = " + tid + " AND SVNO = " + svno;
OleDbDataReader reader = dbUtils.fetch(sqlQry);
if (reader.HasRows)
{
while (reader.Read())
{
lineItem.MetalRate = reader.GetDouble(3);
lineItem.MetalValue = reader.GetDouble(4);
lineItem.MakingOn = reader.GetString(5);
lineItem.MakingRate = reader.GetDouble(6);
lineItem.MakingAmt = reader.GetDouble(7);
lineItem.OtheChgOn = reader.GetString(8);
lineItem.OtheChgRate = reader.GetDouble(9);
lineItem.OtheChgAmt = reader.GetDouble(10);
if (lineItem.DiamondValue > 0)
{
diamondValue = lineItem.DiamondValue;
}
if (lineItem.StoneValue > 0)
{
stoneValue = lineItem.StoneValue;
}
lineItem.TotalAmt = reader.GetDouble(4) + reader.GetDouble(7) + reader.GetDouble(10) + diamondValue + stoneValue;
}
}
reader.Close();
}
public void addToSalesGrid()
{
SalesLineItemDetail salesLineItemDetail = new SalesLineItemDetail();
salesLineItemDetail.Tid = itemInfo.Tid;
salesLineItemDetail.ItemDesc = lblItem.Text;
salesLineItemDetail.MetalType = lblMetalType.Text;
salesLineItemDetail.TagNo = int.Parse(lblTagNo.Text);
salesLineItemDetail.Pcs = int.Parse(lblPcs.Text);
salesLineItemDetail.GrossWeight = double.Parse(lblGrossWt.Text);
salesLineItemDetail.NetWeight = double.Parse(lblNetWt.Text);
salesLineItemDetail.DiamondWeight = getDiamondWeight();
salesLineItemDetail.DiamondValue = getDiamondValue();
salesLineItemDetail.StoneWeight = getStoneWeight();
salesLineItemDetail.StoneValue = getStoneValue();
salesLineItemDetail.MetalRate = double.Parse(txtMetalRate.Text);
salesLineItemDetail.MetalValue = double.Parse(txtMetalValue.Text);
salesLineItemDetail.MakingOn = cmbMakingOn.Text;
double makingRate = 0;
double makingAmt = 0;
double otherChgRate = 0;;
double otherChgAmt = 0;
double totalAmt = 0;
double.TryParse(txtMakingRate.Text, out makingRate);
double.TryParse(txtMakingChg.Text, out makingAmt);
double.TryParse(txtOtherRate.Text, out otherChgRate);
double.TryParse(txtOtherChg.Text, out otherChgAmt);
double.TryParse(txtTotalValue.Text, out totalAmt);
salesLineItemDetail.MakingRate = makingRate;
salesLineItemDetail.MakingAmt = makingAmt;
salesLineItemDetail.OtheChgOn = cmbOtherChg.Text;
salesLineItemDetail.OtheChgRate = otherChgRate;
salesLineItemDetail.OtheChgAmt = otherChgAmt;
salesLineItemDetail.TotalAmt = totalAmt;
if (filePath.Contains(NO_IMAGE))
{
//To be decided later
}
else
{
salesLineItemDetail.PicPath = filePath;
}
if (currentStatus == 0)
{
salesForm.addToSalesGrid(salesLineItemDetail);
}
else
{
salesForm.UpdateSalesGrid(salesLineItemDetail);
}
Close();
}
private void dgStockOut_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
DialogResult answer = MessageBox.Show("Are you sure want to modify ?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (answer == DialogResult.Yes)
{
SalesLineItemDetail saleLineItemDetail = saleGridLineItem[e.RowIndex];
SaleItemInfo saleItemInfo = new SaleItemInfo(saleLineItemDetail, this);
saleItemInfo.ShowDialog();
}
}
private void setVariousCharges(SalesLineItemDetail itemDetail)
{
cmbMakingOn.Text = itemDetail.MakingOn;
txtMakingRate.Text = dbUtils.Decimal2digit(itemDetail.MakingRate.ToString());
txtMakingChg.Text = dbUtils.Decimal2digit(itemDetail.MakingAmt.ToString());
if (itemDetail.OtheChgAmt > 0)
{
cmbOtherChg.Text = itemDetail.OtheChgOn;
txtOtherRate.Text = dbUtils.Decimal2digit(itemDetail.OtheChgRate.ToString());
txtOtherChg.Text = dbUtils.Decimal2digit(itemDetail.OtheChgAmt.ToString());
}
}
public SaleItemInfo(SalesLineItemDetail saleLineItemDetail, Sales form)
{
InitializeComponent();
//setMainPanelPosition();
itemInfo = new ItemInfo();
itemInfo.ItemCode = saleLineItemDetail.ItemDesc;
itemInfo.TagNo = saleLineItemDetail.TagNo;
itemInfo.Pcs = saleLineItemDetail.Tid;
itemInfo.SaleDate = form.selectedDate;
salesForm = form;
this.loadData(itemInfo);
setVariousCharges(saleLineItemDetail);
currentStatus = 1;
}
public void UpdateSalesGrid(SalesLineItemDetail saleLineItemDetail)
{
int rowIndex = dgStockOut.CurrentRow.Index;
DataGridViewRow row = dgStockOut.Rows[rowIndex];
row.Cells[4].Value = dbUtils.Decimal2digit(saleLineItemDetail.NetWeight.ToString());
row.Cells[5].Value = saleLineItemDetail.MetalType;
row.Cells[6].Value = dbUtils.Decimal2digit(saleLineItemDetail.MetalRate.ToString());
if (saleLineItemDetail.DiamondWeight > 0)
{
row.Cells[7].Value = dbUtils.Decimal2digit(saleLineItemDetail.DiamondWeight.ToString());
}
if (saleLineItemDetail.DiamondValue > 0)
{
row.Cells[8].Value = dbUtils.Decimal2digit(saleLineItemDetail.DiamondValue.ToString());
}
if (saleLineItemDetail.StoneWeight > 0)
{
row.Cells[9].Value = dbUtils.Decimal2digit(saleLineItemDetail.StoneWeight.ToString());
}
if (saleLineItemDetail.StoneValue > 0)
{
row.Cells[10].Value = dbUtils.Decimal2digit(saleLineItemDetail.StoneValue.ToString());
}
row.Cells[11].Value = saleLineItemDetail.Pcs;
if (saleLineItemDetail.MakingAmt > 0 && saleLineItemDetail.OtheChgAmt > 0)
{
string charges = dbUtils.Decimal2digit(saleLineItemDetail.MakingAmt.ToString()) + Environment.NewLine + dbUtils.Decimal2digit(saleLineItemDetail.OtheChgAmt.ToString());
row.Cells[12].Value = charges;
}
else
{
row.Cells[12].Value = dbUtils.Decimal2digit(saleLineItemDetail.MakingAmt.ToString());
}
row.Cells[13].Value = dbUtils.Decimal2digit(saleLineItemDetail.TotalAmt.ToString());
row.Cells[14].Value = saleLineItemDetail.Tid;
dgStockOut.AutoResizeColumns();
cmbTagNo.Text = "";
saleGridLineItem[rowIndex] = saleLineItemDetail;
updateSubTotal();
}
private void loadExistingSaleBillLineItem(int svno)
{
string sqlQry = "SELECT * FROM TRANS WHERE OUTBILLNO = " + svno;
saleGridLineItem.Clear();
SalesLineItemDetail lineItem;
OleDbDataReader reader = dbUtils.fetch(sqlQry);
if (reader.HasRows)
{
while (reader.Read())
{
lineItem = new SalesLineItemDetail();
lineItem.Tid = reader.GetInt32(0);
lineItem.ItemDesc = reader.GetString(2);
lineItem.MetalType = reader.GetString(4);
lineItem.TagNo = reader.GetInt32(3);
lineItem.Pcs = reader.GetInt16(5);
lineItem.GrossWeight = reader.GetDouble(6);
lineItem.NetWeight = reader.GetDouble(7);
Dictionary <string, List <double> > diamondStoneDetail = getDiamondandStoneDetail(lineItem.Tid);
if (diamondStoneDetail.ContainsKey("D"))
{
List <double> diamondList = diamondStoneDetail["D"];
lineItem.DiamondWeight = diamondList[0];
lineItem.DiamondValue = diamondList[1];
}
if (diamondStoneDetail.ContainsKey("S"))
{
List <double> stoneList = diamondStoneDetail["S"];
lineItem.StoneWeight = stoneList[0];
lineItem.StoneValue = stoneList[1];
}
setMakingAndOtherCharges(int.Parse(txtBillNo.Text), lineItem.Tid, lineItem);
//saleGridLineItem.Add(lineItem);
addToSalesGrid(lineItem);
}
}
reader.Close();
}
public void addToSalesGrid(SalesLineItemDetail saleLineItemDetail)
{
string basicPath = Application.StartupPath + "\\Data\\Images\\";
int rowIndex = dgStockOut.Rows.Add();
DataGridViewRow row = dgStockOut.Rows[rowIndex];
row.Cells[0].Value = rowIndex + 1; //Serial No
string imagePath = basicPath + saleLineItemDetail.Tid + ".jpg";
if (File.Exists(imagePath))
{
FileStream fs = null;
fs = new FileStream(imagePath, FileMode.Open, FileAccess.Read);
Image photo = Image.FromStream(fs);
Image photoThumbnail = photo.GetThumbnailImage(100, 100, null, new IntPtr());
row.Cells[1].Value = photoThumbnail;
fs.Close();
}
else
{
row.Cells[1].Value = defaultNoImage; //Photo
}
row.Cells[2].Value = saleLineItemDetail.ItemDesc;
row.Cells[3].Value = saleLineItemDetail.TagNo;
row.Cells[4].Value = dbUtils.Decimal2digit(saleLineItemDetail.NetWeight.ToString());
row.Cells[5].Value = saleLineItemDetail.MetalType;
row.Cells[6].Value = dbUtils.Decimal2digit(saleLineItemDetail.MetalRate.ToString());
if (saleLineItemDetail.DiamondWeight > 0)
{
row.Cells[7].Value = dbUtils.Decimal2digit(saleLineItemDetail.DiamondWeight.ToString());
}
if (saleLineItemDetail.DiamondValue > 0)
{
row.Cells[8].Value = dbUtils.Decimal2digit(saleLineItemDetail.DiamondValue.ToString());
}
if (saleLineItemDetail.StoneWeight > 0)
{
row.Cells[9].Value = dbUtils.Decimal2digit(saleLineItemDetail.StoneWeight.ToString());
}
if (saleLineItemDetail.StoneValue > 0)
{
row.Cells[10].Value = dbUtils.Decimal2digit(saleLineItemDetail.StoneValue.ToString());
}
row.Cells[11].Value = saleLineItemDetail.Pcs;
if (saleLineItemDetail.MakingAmt > 0 && saleLineItemDetail.OtheChgAmt > 0)
{
string charges = dbUtils.Decimal2digit(saleLineItemDetail.MakingAmt.ToString()) + Environment.NewLine + dbUtils.Decimal2digit(saleLineItemDetail.OtheChgAmt.ToString());
row.Cells[12].Value = charges;
}
else
{
row.Cells[12].Value = dbUtils.Decimal2digit(saleLineItemDetail.MakingAmt.ToString());
}
row.Cells[13].Value = dbUtils.Decimal2digit(saleLineItemDetail.TotalAmt.ToString());
row.Cells[14].Value = saleLineItemDetail.Tid;
dgStockOut.AutoResizeColumns();
cmbTagNo.Text = "";
saleGridLineItem.Add(saleLineItemDetail);
dgStockOut.FirstDisplayedScrollingRowIndex = dgStockOut.RowCount - 1;
updateSubTotal();
}
