protected void lnkExcelExport_OnClick(object sender, EventArgs e) { DataTable dtOnlineCourierValue = new OnlineCourierValue() { OnlineCourierId = lblOnlineCourierId.zToInt(), }.Select(); dtOnlineCourierValue.Columns.Add("OrderStatusView"); foreach (DataRow drOnlineCourierValue in dtOnlineCourierValue.Rows) { drOnlineCourierValue["OrderStatusView"] = ((eOrderStatus)drOnlineCourierValue["OrderStatus"].zToInt()).ToString(); } var lstColumns = new List <string>(); lstColumns.Add("TrakingId"); lstColumns.Add("CarrierId"); lstColumns.Add("OrderStatusView"); lstColumns.Add("Amount"); lstColumns.Add("Quantity"); lstColumns.Add("TrakingInfo"); lstColumns.Add("Location"); var lstColumnsSelected = new List <string>(); lstColumnsSelected.Add("TrakingId"); lstColumnsSelected.Add("CarrierId"); lstColumnsSelected.Add("OrderStatusView"); lstColumnsSelected.Add("Amount"); lstColumnsSelected.Add("Quantity"); lstColumnsSelected.Add("TrakingInfo"); lstColumnsSelected.Add("Location"); ExcelExport.SetExportData(dtOnlineCourierValue, lstColumns, lstColumnsSelected, "Traking"); popupExcelExport.Show(); }
private bool SaveData() { if (!IsValidate()) { popupOnlineCourier.Show(); return(false); } string Message = string.Empty; var objOnlineCourier = new OnlineCourier() { Name = txtOnlineCourierName.Text, Date = txtDate.zToDate(), PaymentMade = txtPaymentMade.zToInt(), PaymentRecived = txtPaymentRecived.zToInt(), Description = txtDescription.Text, }; if (IsEditMode()) { objOnlineCourier.OnlineCourierId = lblOnlineCourierId.zToInt(); objOnlineCourier.Update(); Message = "Sheet Detail Change Sucessfully."; } else { objOnlineCourier.eStatus = (int)eStatus.Active; objOnlineCourier.OnlineCourierId = objOnlineCourier.Insert(); Message = "New Sheet Added Sucessfully."; } #region Update Value if (fuSheet.HasFile) { var dt = new DataTable(); if (CU.IsValidExcelFile(fuSheet, ref dt, null, string.Empty)) { var lstInsert = new List <OnlineCourierValue>(); var lstUpdate = new List <OnlineCourierValue>(); if (dt.Rows.Count > 0) { var dtOnlineCourierValue = new OnlineCourierValue() { OnlineCourierId = objOnlineCourier.OnlineCourierId }.Select(); foreach (DataRow dr in dt.Rows) { string TrakingId = dr["TrakingId"].ToString(); string CarrierId = dr["CarrierId"].ToString(); string Amount = dr["Amount"].ToString(); string Quantity = dr["Quantity"].ToString(); if (TrakingId.zIsNullOrEmpty()) { continue; } if (CarrierId.zIsNullOrEmpty()) { continue; } if (Amount.zIsNullOrEmpty()) { continue; } if (Quantity.zIsNullOrEmpty()) { continue; } var drOnlineCourierValue = dtOnlineCourierValue.Select(CS.TrakingId + " = '" + TrakingId + "'"); var objOnlineCourierValue = new OnlineCourierValue() { OnlineCourierValueId = drOnlineCourierValue.Length > 0 ? drOnlineCourierValue[0][CS.OnlineCourierValueId].zToInt() : null, OnlineCourierId = objOnlineCourier.OnlineCourierId, TrakingId = TrakingId, CarrierId = CarrierId.zToInt(), Amount = Amount.zToDecimal(), Quantity = Quantity.zToInt(), }; if (objOnlineCourierValue.OnlineCourierValueId.HasValue && objOnlineCourierValue.OnlineCourierValueId > 0) { dtOnlineCourierValue.Rows.Remove(drOnlineCourierValue[0]); lstUpdate.Add(objOnlineCourierValue); if (lstUpdate.Count > 200) { lstUpdate.Update(); lstUpdate = new List <OnlineCourierValue>(); } } else { objOnlineCourierValue.OrderStatus = (int)eOrderStatus.No; lstInsert.Add(objOnlineCourierValue); if (lstInsert.Count > 200) { lstInsert.Insert(); lstInsert = new List <OnlineCourierValue>(); } } #region Upload Shipway var httpWebRequest = (HttpWebRequest)WebRequest.Create("http://shipway.in/api/pushOrderData"); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { string json = "{\r\n\"username\":\"" + UserName + "\",\r\n\"password\":\"" + Password + "\",\r\n\"carrier_id\":\"" + CarrierId + "\",\r\n\"awb\":\" " + TrakingId + "\",\r\n\"order_id\":\"" + TrakingId + "\",\r\n\"first_name\":\"N/A\",\r\n\"last_name\":\" N/A \",\r\n\"email\":\" N/A \",\r\n\"phone\":\" N/A \",\r\n\"products\":\" N/A \",\r\n\"company\":\" xxxxx \"\r\n }"; streamWriter.Write(json); } var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { var result = streamReader.ReadToEnd(); } #endregion } //foreach (DataRow drOnlineCourierValue in dtOnlineCourierValue.Rows) //{ // new OnlineCourierValue() { OnlineCourierValueId = drOnlineCourierValue[CS.OnlineCourierValueId].zToInt() }.Delete(); //} } lstInsert.Insert(); lstUpdate.Update(); } } #endregion CU.ZMessage(eMsgType.Success, string.Empty, Message); return(true); }