public EmbroideryBillView(EmbroideryOrderLineItem[] order, EmbroideryOrder Transaction)
{
InitializeComponent();
this.order = order;
this.Transaction = Transaction;
BillDataGridView.Rows.Clear();
}
public EmbroideryOrder LoadEmbroideryOrderTransactiondetails(string billno)
{
EmbroideryOrder e2;
con = new SqlConnection();
cmd = new SqlCommand();
cmd.CommandText = string.Format("select * from EmbroideryOrder where dealeruserid='{0}' and [BillNo.]='{1}'", dealer.UserId, billno);
con.ConnectionString = Connection;
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
if (reader.Read())
{
e2 = new EmbroideryOrder(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 <EmbroideryOrderLineItem>();
for (int i = 0; i < d1.RowCount - 1; i++)
{
bool x;
if (d1.Rows[i].Cells[5].Value.ToString() == "Yes")
{
x = true;
}
else
{
x = false;
}
string date = d1.Rows[i].Cells[6].Value.ToString();
OrderLineItem.AddLast(new EmbroideryOrderLineItem(bilno, int.Parse(d1.Rows[i].Cells[0].Value.ToString()), d1.Rows[i].Cells[1].Value.ToString(), d1.Rows[i].Cells[2].Value.ToString(), double.Parse(d1.Rows[i].Cells[3].Value.ToString()), Double.Parse(d1.Rows[i].Cells[4].Value.ToString()), x, date, SaveImage(imagepath)));
OrderTransactions = new EmbroideryOrder(bilno, billissuedate, totalamt, dealer.UserId);
AddCodeName(d1.Rows[i].Cells[1].Value.ToString(), d1.Rows[i].Cells[2].Value.ToString());
}
WriteOrder();
UpdateNewRemainingPayment();
totalamt = 0;
}
public EmbroideryOrder[] LoadPrevoiusEmbdDealerTransactions()
{
LinkedList <EmbroideryOrder> e1 = new LinkedList <EmbroideryOrder>();
con = new SqlConnection();
cmd = new SqlCommand();
cmd.CommandText = string.Format("select [BillNo.] from EmbroideryOrder where dealeruserid='{0}'", dealer.UserId);
con.ConnectionString = Connection;
con.Open();
cmd.Connection = con;
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
EmbroideryOrder e2 = new EmbroideryOrder();
e2.BillNo = reader[0].ToString();
e1.AddLast(e2);
}
con.Close();
return(e1.ToArray <EmbroideryOrder>());
}
