private void LoadOnlineCourierDetail()
{
txtOnlineCourierName.Focus();
if (IsEditMode())
{
lblPopupTitle.Text = "Edit Sheet";
var objOnlineCourier = new OnlineCourier()
{
OnlineCourierId = lblOnlineCourierId.zToInt(),
}.SelectList <OnlineCourier>()[0];
txtOnlineCourierName.Text = objOnlineCourier.Name;
txtDate.Text = objOnlineCourier.Date.Value.ToString(CS.ddMMyyyy);
txtPaymentMade.Text = objOnlineCourier.PaymentMade.HasValue ? objOnlineCourier.PaymentMade.ToString() : string.Empty;
txtPaymentRecived.Text = objOnlineCourier.PaymentRecived.HasValue ? objOnlineCourier.PaymentRecived.ToString() : string.Empty;
txtDescription.Text = objOnlineCourier.Description;
}
else
{
lblPopupTitle.Text = "New Sheet";
txtOnlineCourierName.Text = string.Empty;
txtDate.Text = IndianDateTime.Today.ToString(CS.ddMMyyyy);
txtPaymentMade.Text = txtPaymentRecived.Text = txtDescription.Text = string.Empty;
}
}
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);
}
