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>());
}
