public void Filter_Get(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
{
int filteredCount = 0;
List<OrderSheet> OrderSheet_List = new List<OrderSheet>();
DataTable dt = OrderSheet_DA.Filter_Get_OrderSheet(iDisplayLength, iDisplayStart, iSortCol_0, sSortDir_0, sSearch);
foreach (DataRow row in dt.Rows)
{
filteredCount = int.Parse(row["TotalCount"].ToString());
OrderSheet _OrderSheet = new OrderSheet();
_OrderSheet.Id = int.Parse(row["Id"].ToString());
_OrderSheet.ProformaInvoiceName = row["Pi_No"].ToString();
_OrderSheet.ORDERNO = row["ORDERNO"].ToString();
if (row["ORDERDATE"].ToString() != "")
_OrderSheet.ORDERDATEstring = Convert.ToDateTime(row["ORDERDATE"].ToString()).ToString("MM/dd/yyyy");
_OrderSheet.PRODDIV = row["PRODDIV"].ToString();
_OrderSheet.AMENDMENTNO = row["AMENDMENTNO"].ToString();
if (row["AMENDMENTDATE"].ToString() != "")
_OrderSheet.AMENDMENTDATEstring = Convert.ToDateTime(row["AMENDMENTDATE"].ToString()).ToString("MM/dd/yyyy");
if (row["SHIPMENTDATE"].ToString() != "")
_OrderSheet.SHIPMENTDATEstring = Convert.ToDateTime(row["SHIPMENTDATE"].ToString()).ToString("MM/dd/yyyy");
_OrderSheet.DESTINATION = row["DESTINATION"].ToString();
_OrderSheet.TRANSPORTBY = row["TRANSPORTBY"].ToString();
_OrderSheet.PRICETERM = row["PRICETERM"].ToString();
OrderSheet_List.Add(_OrderSheet);
}
var result = new
{
iTotalRecords = GetTotalCount(),
iTotalDisplayRecords = filteredCount,
aaData = OrderSheet_List
};
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(result));
}
public OrderSheet Get(int ID)
{
OrderSheet _OrderSheet = new OrderSheet();
DataTable dt = OrderSheet_DA.Get(ID);
foreach (DataRow row in dt.Rows)
{
_OrderSheet.Id = int.Parse(row["Id"].ToString());
_OrderSheet.ProformaInvoiceId = int.Parse(row["ProformaInvoiceId"].ToString());
_OrderSheet.TOTALCTN = row["TOTALCTN"].ToString();
_OrderSheet.ORDERNO = row["ORDERNO"].ToString();
if (row["ORDERDATE"].ToString() != "")
_OrderSheet.ORDERDATEstring = Convert.ToDateTime(row["ORDERDATE"].ToString()).ToString("MM/dd/yyyy");
_OrderSheet.PRODDIV = row["PRODDIV"].ToString();
_OrderSheet.AMENDMENTNO = row["AMENDMENTNO"].ToString();
if (row["AMENDMENTDATE"].ToString() != "")
_OrderSheet.AMENDMENTDATEstring = Convert.ToDateTime(row["AMENDMENTDATE"].ToString()).ToString("MM/dd/yyyy");
if (row["SHIPMENTDATE"].ToString() != "")
_OrderSheet.SHIPMENTDATEstring = Convert.ToDateTime(row["SHIPMENTDATE"].ToString()).ToString("MM/dd/yyyy");
_OrderSheet.DESTINATION = row["DESTINATION"].ToString();
_OrderSheet.TRANSPORTBY = row["TRANSPORTBY"].ToString();
_OrderSheet.PRICETERM = row["PRICETERM"].ToString();
_OrderSheet.NOTE = row["NOTE"].ToString();
}
return _OrderSheet;
}
public string Submit(OrderSheet orderSheet, List<OrderSheet_B> listOrderSheet_B, List<Sale_B_KNITTED> listOrderSheet_B_KNITTED,
List<List<Sale_B_WOVEN>> listOrderSheet_B_WOVEN,
List<Sale_B_NONWOVEN> listOrderSheet_B_NONWOVEN, List<Sale_B_TERRY> listOrderSheet_B_TERRY, List<Sale_B_KNITWRIST> listOrderSheet_B_KNITWRIST
, List<Sale_B_LEATHER> listOrderSheet_B_LEATHER)
{
string msg = "";
if (orderSheet.Id == 0)
{
orderSheet.CreatedBy = Session["User"].ToString();
msg = OrderSheet_DA.Insert(orderSheet, listOrderSheet_B, listOrderSheet_B_KNITTED, listOrderSheet_B_WOVEN, listOrderSheet_B_NONWOVEN, listOrderSheet_B_TERRY, listOrderSheet_B_KNITWRIST, listOrderSheet_B_LEATHER);
}
else
{
orderSheet.UpdatedBy = Session["User"].ToString();
msg = OrderSheet_DA.Update(orderSheet, listOrderSheet_B, listOrderSheet_B_KNITTED, listOrderSheet_B_WOVEN, listOrderSheet_B_NONWOVEN, listOrderSheet_B_TERRY, listOrderSheet_B_KNITWRIST, listOrderSheet_B_LEATHER);
}
return msg;
}