public StitchingBillVIew(StitchingOrderLineItem[] order, StitchingOrder transaction) { InitializeComponent(); this.order = order; this.transaction = transaction; BillDataGridView.Rows.Clear(); }
public StitchingOrder LoadStitchingOrderTransactionDetails(String billno) { con = new SqlConnection(); cmd = new SqlCommand(); cmd.CommandText = string.Format("select * from StitchingOrder where DealerUserId='{0}' and [BillNo.]='{1}'", dealer.UserId, billno); con.ConnectionString = Connection; con.Open(); cmd.Connection = con; cmd.ExecuteNonQuery(); reader = cmd.ExecuteReader(); StitchingOrder e2; if (reader.Read()) { e2 = new StitchingOrder(reader[0].ToString(), reader[1].ToString(), Double.Parse(reader[2].ToString()), reader[3].ToString()); reader.Close(); con.Close(); return(e2); } else { reader.Close(); con.Close(); return(null); } }
public void CompleteOrderRecord(DataGridView d1, string bilno, string billissuedate, string dealerid, string imagepath) { OrderLineItem = new LinkedList <StitchingOrderLineItem>(); for (int i = 0; i < d1.RowCount - 1; i++) { bool x; if (d1.Rows[i].Cells[6].Value.ToString() == "Yes") { x = true; } else { x = false; } string date = d1.Rows[i].Cells[8].Value.ToString(); OrderLineItem.AddLast(new StitchingOrderLineItem(bilno, int.Parse(d1.Rows[i].Cells[0].Value.ToString()), d1.Rows[i].Cells[1].Value.ToString(), d1.Rows[i].Cells[2].Value.ToString(), d1.Rows[i].Cells[3].Value.ToString(), int.Parse(d1.Rows[i].Cells[4].Value.ToString()), double.Parse(d1.Rows[i].Cells[5].Value.ToString()), Double.Parse(d1.Rows[i].Cells[6].Value.ToString()), x, date, SaveImage(imagepath))); AddCodeName(d1.Rows[i].Cells[1].Value.ToString(), d1.Rows[i].Cells[2].Value.ToString()); } OrderTransaction = new StitchingOrder(bilno, billissuedate, totalamt, dealer.UserId); WriteOrder(); UpdateNewRemainingPayment(); totalamt = 0; }
public StitchingOrder[] LoadPrevoiusStitchingDealerTransactions() { LinkedList <StitchingOrder> e1 = new LinkedList <StitchingOrder>(); con = new SqlConnection(); cmd = new SqlCommand(); cmd.CommandText = string.Format("select [BillNo.] from StitchingOrder where dealeruserid='{0}'", dealer.UserId); con.ConnectionString = Connection; con.Open(); cmd.Connection = con; cmd.ExecuteNonQuery(); reader = cmd.ExecuteReader(); while (reader.Read()) { StitchingOrder e2 = new StitchingOrder(); e2.BillNo = reader[0].ToString(); e1.AddLast(e2); } con.Close(); return(e1.ToArray <StitchingOrder>()); }