protected void dtProductInvoice_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string strReturnOrderId = dtProductInvoice.DataKeys[e.Item.ItemIndex].ToString();
GridView dgvLeft = (GridView)e.Item.FindControl("dgvLeftGridView");
GridView dgvRIght = (GridView)e.Item.FindControl("dgvRightgrid");
if (strReturnOrderId != "" && dgvLeft != null && dgvRIght != null)
{
objReturnOrder = new tblReturnOrder();
objDataTable = objReturnOrder.LoadReturnOrderInvoice(strReturnOrderId);
dgvLeft.DataSource = objDataTable;
dgvLeft.DataBind();
dgvRIght.DataSource = objDataTable;
dgvRIght.DataBind();
string strTotal = objDataTable.Compute("sum(appTotal)", "").ToString();
Label lblLeftOrdeTotal = (Label)e.Item.FindControl("lblLeftOrdeTotal"); lblLeftOrdeTotal.Text = strTotal;
Label lblLeftCODCharges = (Label)e.Item.FindControl("lblLeftCODCharges"); lblLeftCODCharges.Text = "0";
Label lblLeftShippingCharges = (Label)e.Item.FindControl("lblLeftShippingCharges"); lblLeftShippingCharges.Text = "0";
Label lblLeftAmount = (Label)e.Item.FindControl("lblLeftAmount"); lblLeftAmount.Text = strTotal;
Label lblRightTotal = (Label)e.Item.FindControl("lblRightTotal"); lblRightTotal.Text = strTotal;
Label lblRightAmount = (Label)e.Item.FindControl("lblRightAmount"); lblRightAmount.Text = strTotal;
objReturnOrder = null;
}
}
}
protected void dgvSubDetail_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
if (e.CommandName == "IsView")
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objReturnOrder.s_AppCourierCompanyID == "" || objReturnOrder.AppCourierCompanyID == null)
{
lblForLabel1.Text = "Contact No.";
lblValue1.Text = objReturnOrder.AppCourierCompanyContactNo;
lblForLabel2.Text = "Site URL.";
lblValue2.Text = objReturnOrder.AppCourierCompanyWebsite;
}
else
{
lblForLabel1.Text = "Courier Company";
tblCourierCompany objCourierCompany = new tblCourierCompany();
if (objCourierCompany.LoadByPrimaryKey(objReturnOrder.AppCourierCompanyID))
{
lblValue1.Text = objCourierCompany.AppCourierCompany;
}
objCourierCompany = null;
lblForLabel2.Text = "Docket No";
lblValue2.Text = objReturnOrder.AppDocketNo;
}
mpeView.Show();
}
}
}
}
protected void btnReturnGenrateSlip_Click(object sender, EventArgs e)
{
if (hdnReturnOrderID.Value != "")
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(hdnReturnOrderID.Value)))
{
objReturnOrder.s_AppDocketNo = txtDocketNo.Text;
if (Convert.ToInt32(ddlCourierCompany.SelectedValue) != -1)
{
objReturnOrder.s_AppCourierCompanyID = ddlCourierCompany.SelectedValue;
}
else
{
objReturnOrder.AppCourierCompanyContactNo = txtCourierContactNo.Text;
objReturnOrder.AppCourierCompanyWebsite = txtSiteName.Text;
}
objReturnOrder.Save();
objEncrypt = new clsEncryption();
hdnReturnOrderID.Value = GetAlias("Productslip.aspx") + objEncrypt.Encrypt(objReturnOrder.s_AppReturnOrderID, appFunctions.strKey);
objEncrypt = null;
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "CallProductInvoice()", true);
}
objReturnOrder = null;
}
LoadMyorderList();
}
protected void btnReturnProduct_Click(object sender, EventArgs e)
{
if (hdnSelectedSubOrderIDs.Value != "" && hdnOrderId.Value != "")
{
string strIds = hdnSelectedSubOrderIDs.Value.Trim().TrimEnd(',');
if (strIds != "")
{
string[] arIDs = strIds.Split(',');
if (arIDs.Length > 0)
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
objReturnOrder.AddNew();
objReturnOrder.s_AppOrderID = hdnOrderId.Value;
objReturnOrder.AppReason = ddlReason.SelectedValue;
objReturnOrder.AppNote = txtNote.Text;
objReturnOrder.s_AppRequestedDate = GetCurrentDateTime().ToString();
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Requested);
objReturnOrder.s_AppPreviousSubOrderStatus = hdnPrevStatus.Value;
objReturnOrder.s_AppPickupName = txtPickupName.Text;
objReturnOrder.s_AppPickupContactNo1 = txPickupMobile1.Text;
objReturnOrder.s_AppPickupContactNo2 = txtPickupMobile2.Text;
objReturnOrder.s_AppPickupAddress = txtPickupAddress.Text;
objReturnOrder.s_AppPickupPIN = txtPickupPIN.Text;
objReturnOrder.s_AppPreferedTime = txtPreferedTime.Text;
//objReturnOrder.s_AppDocketNo = txtDocketNo.Text;
objReturnOrder.Save();
for (int i = 0; i <= arIDs.Length - 1; i++)
{
if (!string.IsNullOrEmpty(arIDs.GetValue(i).ToString()))
{
tblReturnOrderDetail objReturnOrderDetail = new tblReturnOrderDetail();
objReturnOrderDetail.AddNew();
objReturnOrderDetail.s_AppSubOrderID = arIDs.GetValue(i).ToString();
objReturnOrderDetail.AppReturnOrderID = objReturnOrder.AppReturnOrderID;
objReturnOrderDetail.Save();
objReturnOrderDetail = null;
}
}
objReturnOrder = null;
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetSubOrderStatus(Convert.ToInt32(Enums.Enums_OrderStatus.Returned), strIds, GetCurrentDateTime().ToString());
objSubOrder = null;
ddlReason.SelectedValue = "0";
txtNote.Text = "";
hdnSelectedSubOrderIDs.Value = "";
hdnOrderId.Value = "";
DInfo.ShowMessage("Return Product Request Submitted.", Enums.MessageType.Successfull);
LoadMyorderList();
}
}
}
else
{
DInfo.ShowMessage("Choose Valid Product For Return Try again.", Enums.MessageType.Error);
}
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort)
{
objReturnOrder = new tblReturnOrder();
objDataTable = objReturnOrder.LoadPendingReturnOrderAdmin(ddlFields.SelectedValue, txtSearch.Text, txtStartDate.Text, txtEndDate.Text);
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
if (objDataTable.Rows.Count <= 0)
{
DInfo.ShowMessage("No data found", Enums.MessageType.Information);
return;
}
else
{
if (ddlPerPage.SelectedItem.Text.ToLower() == "all")
{
dgvGridView.AllowPaging = false;
}
else
{
dgvGridView.AllowPaging = true;
dgvGridView.PageSize = Convert.ToInt32(ddlPerPage.SelectedItem.Text);
}
lblCount.Text = objDataTable.Rows.Count.ToString();
if (IsSort)
{
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
}
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objReturnOrder = null;
}
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
if (e.CommandName.ToString() == "ReturnComplete")
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Complete);
objReturnOrder.Save();
}
objReturnOrder = null;
LoadDataGrid(true, false);
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
try
{
string strId = "";
objEncrypt = new clsEncryption();
objCommon = new clsCommon();
strId = objCommon.GetParameterFromUrl(Enums.Enums_URLParameterType.ByNumber, "1");
strId = objEncrypt.Decrypt(strId, appFunctions.strKey);
objEncrypt = null;
if (strId != "")
{
objReturnOrder = new tblReturnOrder();
objDataTable = objReturnOrder.GetReturnOrderListWithCityStateCountry(strId, Convert.ToInt32(Enums.Enum_ReturnStatus.Slip).ToString(), appFunctions.strSellerName, appFunctions.strMobileNo, appFunctions.strAddress, appFunctions.strCountry, appFunctions.strState, appFunctions.strCity, appFunctions.strPinColde);
if (objDataTable.Rows.Count > 0)
{
printButton.Visible = true;
}
else
{
printButton.Visible = false;
}
dtProductInvoice.DataSource = objDataTable;
dtProductInvoice.DataBind();
// objSubOrder.SetProductInvoiceGenerated(Convert.ToInt32(Enums.Enums_OrderStatus.Confirmed).ToString(),strId.TrimEnd(',').Trim());
objReturnOrder = null;
}
else
{
printButton.Visible = false;
}
}
catch (Exception ex)
{
printButton.Visible = false;
Response.Write(ex.StackTrace.ToString());
}
}
}
protected void dgvGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataControlRowType itemType = e.Row.RowType;
switch (itemType)
{
case DataControlRowType.DataRow:
string strID = dgvGridView.DataKeys[e.Row.RowIndex].Values[0].ToString();
GridView dgvSubDetail = (GridView)e.Row.FindControl("dgvSubDetail");
if (dgvSubDetail != null)
{
objReturnOrder = new tblReturnOrder();
dgvSubDetail.DataSource = objReturnOrder.LoadReturOrderProductFromReturnOrder(strID);
dgvSubDetail.DataBind();
objReturnOrder = null;
}
break;
}
}
private bool Approve(int intPKID)
{
bool retval = false;
objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(intPKID))
{
//string strCourierCompanyID = "";
//string strDocketNo = "";
//tblReturnOrder objTempReturnOrder = new tblReturnOrder();
//objDataTable = objTempReturnOrder.LoadReturnOrderdWiseProductWeight(objReturnOrder.s_AppReturnOrderID);
//if (objDataTable.Rows.Count > 0)
//{
// bool IsCod = false;
// //if (objDataTable.Rows[0][tblOrder.ColumnNames.AppPaymentMode].ToString() != "")
// //{
// // if (Convert.ToInt32(objDataTable.Rows[0][tblOrder.ColumnNames.AppPaymentMode].ToString()) == Convert.ToInt32(Enums.PaymentMode.COD))
// // {
// // IsCod = true;
// // }
// //}
// DataTable objCourierCompany = objTempReturnOrder.GetCourierCompanyIdFromData(objDataTable.Rows[0]["appTotalWeight"].ToString(), objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverPIN].ToString(), IsCod);
// if (objCourierCompany.Rows.Count > 0)
// {
// objCommon = new clsCommon();
// strDocketNo = objCommon.GenerateDocketNo(8) + objCommon.GenerateDocketNo(2);
// objCommon = null;
// strCourierCompanyID = objCourierCompany.Rows[0][tblCourierCompany.ColumnNames.AppCourierCompanyID].ToString();
// // objSubOrder.SetSellerOrderMovetoConfirm(Convert.ToInt32(Enums.Enums_OrderStatus.Ordered), Convert.ToInt32(Enums.Enums_OrderStatus.Confirmed), arIDs[i].ToString(), GetCurrentDateTime().ToString(), objCourierCompany.Rows[0][tblCourierCompany.ColumnNames.AppCourierCompanyID].ToString(), strDocketNo, objCourierCompany.Rows[0][tblCourierRate.ColumnNames.AppRate].ToString(), objCourierCompany.Rows[0][tblCourierCompany.ColumnNames.AppCODRate].ToString());
// }
//}
//objTempReturnOrder = null;
//objReturnOrder.s_AppCourierCompanyID = strCourierCompanyID;
//objReturnOrder.s_AppDocketNo = strDocketNo;
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Approved);
objReturnOrder.Save();
}
objReturnOrder = null;
retval = true;
objReturnOrder = null;
return(retval);
}
protected void btnRejected_Click(object sender, EventArgs e)
{
string[] arIDs = hdnSelectedIDs.Value.ToString().TrimEnd(',').Split(',');
bool IsReject = false;
for (int i = 0; i <= arIDs.Length - 1; i++)
{
if (!string.IsNullOrEmpty(arIDs.GetValue(i).ToString()))
{
objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(arIDs.GetValue(i))))
{
if (objReturnOrder.RowCount > 0)
{
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetOrderstatusWhenReturnReject(Convert.ToInt32(Enums.Enums_OrderStatus.Returned), objReturnOrder.AppPreviousSubOrderStatus, objReturnOrder.s_AppReturnOrderID, GetCurrentDateTime().ToString());
objSubOrder = null;
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Reject);
objReturnOrder.Save();
//if (arIDs[i].ToString() != "")
//{
// SendMail(Convert.ToInt32(Enums.Enum_ReturnStatus.Reject), arIDs[i].ToString());
//}
IsReject = true;
}
}
objReturnOrder = null;
}
}
if (IsReject)
{
LoadDataGrid(false, false);
DInfo.ShowMessage("Return Order has been Reject successfully", Enums.MessageType.Successfull);
}
hdnSelectedIDs.Value = "";
}
protected void dgvGridView_RowDataBound(object sender, System.Web.UI.WebControls.GridViewRowEventArgs e)
{
DataControlRowType itemType = e.Row.RowType;
switch (itemType)
{
case DataControlRowType.DataRow:
string strPaymentMode = dgvGridView.DataKeys[e.Row.RowIndex].Values[0].ToString();
string strSubOrderID = dgvGridView.DataKeys[e.Row.RowIndex].Values[1].ToString();
if (strSubOrderID != "")
{
GridView dgvGrid = (GridView)e.Row.FindControl("dgvSubDetail");
if (dgvGrid != null)
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
dgvGrid.DataSource = objReturnOrder.LoadReturOrderProduct(strSubOrderID);
dgvGrid.DataBind();
objReturnOrder = null;
}
}
if (strPaymentMode != "")
{
Label lblPaymentMode = (Label)e.Row.FindControl("lblPaymentMode");
if (strPaymentMode == Convert.ToInt32(Enums.PaymentMode.COD).ToString())
{
lblPaymentMode.Text = "COD";
lblPaymentMode.BackColor = System.Drawing.Color.Brown;
}
if (strPaymentMode == Convert.ToInt32(Enums.PaymentMode.PayNow).ToString())
{
lblPaymentMode.Text = "Pre-Paid";
lblPaymentMode.BackColor = System.Drawing.Color.Green;
}
}
Label lblReturnStatus = (Label)e.Row.FindControl("lblReturnStatus");
LinkButton lnkbtnReturnBack = (LinkButton)e.Row.FindControl("lnkbtnReturnBack");
if (lblReturnStatus != null)
{
if (lblReturnStatus.Text != "")
{
if (Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Slip))
{
lnkbtnReturnBack.Visible = true;
}
if (Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Requested))
{
lblReturnStatus.Text = Enums.Enum_ReturnStatus.Requested.ToString();
}
else if (Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Approved) || Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Slip))
{
lblReturnStatus.Text = Enums.Enum_ReturnStatus.Approved.ToString();
}
else if (Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Complete))
{
lblReturnStatus.Text = Enums.Enum_ReturnStatus.Complete.ToString();
lnkbtnReturnBack.Visible = false;
}
else if (Convert.ToInt32(lblReturnStatus.Text) == Convert.ToInt32(Enums.Enum_ReturnStatus.Dispatched))
{
lblReturnStatus.Text = Enums.Enum_ReturnStatus.Dispatched.ToString();
lnkbtnReturnBack.Visible = true;
}
}
}
break;
}
}
protected void DataListSubOrder_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandArgument.ToString() != "")
{
if (e.CommandName == "ReturnAddress")
{
hdnReturnOrderID.Value = e.CommandArgument.ToString();
tblReturnOrder objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (objReturnOrder.AppReturnStatus == Convert.ToInt32(Enums.Enum_ReturnStatus.Slip) && objReturnOrder.s_AppDocketNo != "")
{
if (objReturnOrder.AppReturnStatus == Convert.ToInt32(Enums.Enum_ReturnStatus.Approved))
{
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Slip);
objReturnOrder.Save();
}
objEncrypt = new clsEncryption();
hdnReturnOrderID.Value = GetAlias("Productslip.aspx") + objEncrypt.Encrypt(objReturnOrder.s_AppReturnOrderID, appFunctions.strKey);
objEncrypt = null;
ScriptManager.RegisterStartupScript(UpMain, UpMain.GetType(), "myFunction", "CallProductInvoice();", true);
}
else
{
if (objReturnOrder.s_AppDocketNo != "")
{
txtDocketNo.Text = objReturnOrder.s_AppDocketNo;
txtDocketNo.Enabled = false;
}
else
{
ddlCourierCompany.SelectedIndex = 0;
txtCourierContactNo.Text = "";
txtSiteName.Text = "";
txtDocketNo.Text = "";
txtDocketNo.Enabled = true;
}
Mpeslip.Show();
}
// Mpeslip.Show();
}
objReturnOrder = null;
}
if (e.CommandName == "ReturnRequest")
{
tblSubOrder objTempSubOrder = new tblSubOrder();
objDataTable = objTempSubOrder.GetProductInvoiceInfo(e.CommandArgument.ToString());
if (objDataTable.Rows.Count > 0)
{
hdnPrevStatus.Value = objDataTable.Rows[0][tblSubOrder.ColumnNames.AppSubOrderStatusID].ToString();
txtPickupName.Text = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverName].ToString();
txtPickupAddress.Text = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverAddress].ToString();
txPickupMobile1.Text = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo1].ToString();
txtPickupMobile2.Text = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverContactNo2].ToString();
txtPickupPIN.Text = objDataTable.Rows[0][tblOrder.ColumnNames.AppReceiverPIN].ToString();
}
objTempSubOrder = null;
MpeReturnRequest.Show();
}
if (e.CommandName == "Dispatch")
{
tblReturnOrder objReturnOrder = new tblReturnOrder();
if (objReturnOrder.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
objReturnOrder.AppReturnStatus = Convert.ToInt32(Enums.Enum_ReturnStatus.Dispatched);
objReturnOrder.Save();
objReturnOrder = null;
}
LoadMyorderList();
}
}
}
