private bool SaveData()
{
objCommon = new clsCommon();
if (objCommon.IsRecordExists("tblOrderStatus", tblOrderStatus.ColumnNames.AppOrderStatus, tblOrderStatus.ColumnNames.AppOrderStatusID, txtOrderStatus.Text, hdnPKID.Value))
{
DInfo.ShowMessage("Order Status alredy exits.", Enums.MessageType.Error);
return(false);
}
objOrderStatus = new tblOrderStatus();
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objOrderStatus.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value));
}
else
{
objOrderStatus.AddNew();
objOrderStatus.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblOrderStatus", tblOrderStatus.ColumnNames.AppDisplayOrder);
}
objOrderStatus.AppOrderStatus = txtOrderStatus.Text;
objOrderStatus.AppIsActive = chkIsActive.Checked;
if (chkIsDefault.Checked)
{
tblOrderStatus ObjTempcolor = new tblOrderStatus();
ObjTempcolor.SetDefaultOrderStatus();
ObjTempcolor = null;
objOrderStatus.AppIsActive = true;
objOrderStatus.AppIsDefault = true;
}
else
{
tblOrderStatus ObjTempcolor = new tblOrderStatus();
ObjTempcolor.LoadAll();
if (ObjTempcolor.RowCount <= 0)
{
objOrderStatus.AppIsActive = true;
objOrderStatus.AppIsDefault = true;
}
else
{
objOrderStatus.AppIsDefault = false;
}
ObjTempcolor = null;
}
objOrderStatus.Save();
intPkId = objOrderStatus.AppOrderStatusID;
objOrderStatus = null;
objCommon = null;
return(true);
}
private void LoadDataGrid(bool IsResetPageIndex, bool IsSort, string strFieldName = "", string strFieldValue = "")
{
objOrderStatus = new tblOrderStatus();
objDataTable = objOrderStatus.LoadGridData(ddlFields.SelectedValue, txtSearch.Text.Trim());
//'Reset PageIndex of gridviews
if (IsResetPageIndex)
{
if (dgvGridView.PageCount > 0)
{
dgvGridView.PageIndex = 0;
}
}
dgvGridView.DataSource = null;
dgvGridView.DataBind();
lblCount.Text = 0.ToString();
hdnSelectedIDs.Value = "";
//'Check for data into datatable
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();
objDataTable = SortDatatable(objDataTable, ViewState["SortColumn"].ToString(), (appFunctions.Enum_SortOrderBy)ViewState["SortOrder"], IsSort);
dgvGridView.DataSource = objDataTable;
dgvGridView.DataBind();
}
objOrderStatus = null;
}
public static SalesOrderStatus ToCustomerOrderStatus(this tblOrderStatus status)
{
switch (status)
{
case tblOrderStatus.Scheduled:
case tblOrderStatus.Staged:
case tblOrderStatus.Shipped:
case tblOrderStatus.Treated:
case tblOrderStatus.Void:
return(SalesOrderStatus.Ordered);
case tblOrderStatus.Invoiced:
return(SalesOrderStatus.Invoiced);
default: throw new ArgumentOutOfRangeException("status");
}
}
private void SetValuesToControls()
{
if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "")
{
objOrderStatus = new tblOrderStatus();
if (objOrderStatus.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)))
{
txtOrderStatus.Text = objOrderStatus.AppOrderStatus;
chkIsActive.Checked = objOrderStatus.AppIsActive;
chkIsDefault.Checked = objOrderStatus.AppIsDefault;
if (chkIsDefault.Checked)
{
chkIsDefault.Enabled = false;
}
}
objOrderStatus = null;
}
}
private bool Delete(int intPKID)
{
bool retval = false;
objOrderStatus = new tblOrderStatus();
var _with1 = objOrderStatus;
if (_with1.LoadByPrimaryKey(intPKID))
{
_with1.MarkAsDeleted();
_with1.Save();
}
retval = true;
objOrderStatus = null;
return(retval);
}
public void SetOrderCount()
{
tblOrderStatus objOrderStatus = new tblOrderStatus();
DataTable objTempTable = objOrderStatus.GetCountStatusWiseSubOrder();
if (objTempTable.Rows.Count > 0)
{
lblOrdered.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Ordered)).ToString() + " ]";
lblConfirmed.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Confirmed)).ToString() + " ]";
lblReady.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.ReadyToShip)).ToString() + " ]";
lblShipped.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Shipped)).ToString() + " ]";
lblDelivered.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Delivered)).ToString() + " ]";
lblCancelled.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + " in (" + Convert.ToInt32(Enums.Enums_OrderStatus.CancelledByAdmin) + "," + Convert.ToInt32(Enums.Enums_OrderStatus.CancelledByCustomer) + ")").ToString() + " ]";
lblReturned.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Returned)).ToString() + " ]";
lblComplete.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.Complete)).ToString() + " ]";
lblPaymentFail.Text = "[ " + objTempTable.Compute("sum(TotalCount)", tblOrderStatus.ColumnNames.AppOrderStatusID + "=" + Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail)).ToString() + " ]";
}
objOrderStatus = null;
}
protected void dgvGridView_RowCommand(object sender, System.Web.UI.WebControls.GridViewCommandEventArgs e)
{
if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
{
objCommon = new clsCommon();
if (e.CommandName == "Up")
{
LinkButton inkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent;
if (drCurrent.RowIndex > 0)
{
GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1];
objCommon.SetDisplayOrder("tblOrderStatus", tblOrderStatus.ColumnNames.AppOrderStatusID, tblOrderStatus.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]);
LoadDataGrid(false, false);
objCommon = null;
}
}
else if (e.CommandName == "Down")
{
LinkButton lnkButton = (LinkButton)e.CommandSource;
GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent;
if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1)
{
GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1];
objCommon.SetDisplayOrder("tblOrderStatus", tblOrderStatus.ColumnNames.AppOrderStatusID, tblOrderStatus.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[1], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[1]);
LoadDataGrid(false, false);
objCommon = null;
}
}
else if (e.CommandName == "IsActive")
{
objOrderStatus = new tblOrderStatus();
if (objOrderStatus.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString())))
{
if (!objOrderStatus.AppIsDefault)
{
if (objOrderStatus.AppIsActive == true)
{
objOrderStatus.AppIsActive = false;
}
else if (objOrderStatus.AppIsActive == false)
{
objOrderStatus.AppIsActive = true;
}
objOrderStatus.Save();
LoadDataGrid(false, false);
}
}
objOrderStatus = null;
}
else if (e.CommandName == "IsDefault")
{
objOrderStatus = new tblOrderStatus();
objOrderStatus.SetDefaultOrderStatus(e.CommandArgument.ToString());
objOrderStatus = null;
LoadDataGrid(false, false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckSession();
SetUpPageContent(ref metaDescription, ref metaKeywords);
objCommon = new clsCommon();
try
{
string[] merc_hash_vars_seq;
string merc_hash_string = string.Empty;
string merc_hash = string.Empty;
string order_id = string.Empty;
string strOrderId = "";
string strTransactionId = "";
bool IsSuccess = false;
if (Session[appFunctions.Session.PaymetnOrderId.ToString()] != null)
{
if (Session[appFunctions.Session.PaymetnOrderId.ToString()].ToString() != "")
{
strOrderId = Session[appFunctions.Session.PaymetnOrderId.ToString()].ToString();
Session[appFunctions.Session.PaymetnOrderId.ToString()] = "";
Session[appFunctions.Session.PaymetnOrderId.ToString()] = null;
}
}
if (Session[appFunctions.Session.PaymentTransactionId.ToString()] != null)
{
if (Session[appFunctions.Session.PaymentTransactionId.ToString()].ToString() != "")
{
strTransactionId = Session[appFunctions.Session.PaymentTransactionId.ToString()].ToString();
Session[appFunctions.Session.PaymentTransactionId.ToString()] = "";
Session[appFunctions.Session.PaymentTransactionId.ToString()] = null;
}
}
if (Request.Form["status"] == "success")
{
merc_hash_vars_seq = appFunctions.hashSequence.Split('|');
Array.Reverse(merc_hash_vars_seq);
merc_hash_string = appFunctions.SALT + "|" + Request.Form["status"];
foreach (string merc_hash_var in merc_hash_vars_seq)
{
merc_hash_string += "|";
merc_hash_string = merc_hash_string + (Request.Form[merc_hash_var] != null ? Request.Form[merc_hash_var] : "");
}
// Response.Write(merc_hash_string);
//return;
merc_hash = objCommon.Generatehash512(merc_hash_string).ToLower();
if (merc_hash != Request.Form["hash"])
{
//Response.Write("Hash value did not matched");
DInfo.ShowMessage("Your online payment Failed", BusinessLayer.Enums.MessageType.Error);
IsSuccess = false;
}
else
{
IsSuccess = true;
order_id = Request.Form["txnid"];
DInfo.ShowMessage("Your online payment is done successfully and your transction ID is " + order_id + "", BusinessLayer.Enums.MessageType.Successfull);
}
}
else
{
//Response.Write("Hash value did not matched");
IsSuccess = false;
DInfo.ShowMessage("Your online payment Failed", BusinessLayer.Enums.MessageType.Error);
}
if (strOrderId != "")
{
tblOrder objOrder = new tblOrder();
if (objOrder.LoadByPrimaryKey(Convert.ToInt32(strOrderId)))
{
objOrder.s_AppTransactionID = order_id;
if (IsSuccess)
{
objOrder.AppPaymentStatus = Convert.ToInt32(Enums.Enums_PaymentStatus.success);
string strDefaultOrderStatusID = "";
tblOrderStatus objStatus = new tblOrderStatus();
objStatus.Where.AppIsDefault.Value = true;
objStatus.Query.Load();
if (objStatus.RowCount > 0)
{
strDefaultOrderStatusID = objStatus.s_AppOrderStatusID;
}
objStatus = null;
objOrder.s_AppOrderStatusID = strDefaultOrderStatusID;
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetOrderStatus(Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail), strOrderId, GetCurrentDateTime().ToString(), strDefaultOrderStatusID);
objSubOrder = null;
}
else
{
objOrder.AppPaymentStatus = Convert.ToInt32(Enums.Enums_PaymentStatus.Failure);
objOrder.AppOrderStatusID = Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail);
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetOrderStatus(Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail), strOrderId, GetCurrentDateTime().ToString(), Convert.ToInt32(Enums.Enums_OrderStatus.Ordered).ToString());
objSubOrder = null;
}
objOrder.Save();
SendMail(objOrder.s_AppOrderNo, objOrder.s_AppReceiverName, objOrder.s_AppReceiverContactNo1, objOrder.s_AppRecevierEmail, IsSuccess, objOrder.s_AppTransactionID, objOrder.s_AppBankRefNo);
objOrder = null;
objOrder = new tblOrder();
objDataTable = objOrder.LoadMyOrderList(Session[appFunctions.Session.ClientUserID.ToString()].ToString(), "", strOrderId);
DataListMyOrder.DataSource = null;
DataListMyOrder.DataBind();
if (objDataTable.Rows.Count > 0)
{
DataListMyOrder.DataSource = objDataTable;
DataListMyOrder.DataBind();
}
}
objOrder = null;
}
}
catch (Exception ex)
{
}
objCommon = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckSession();
SetUpPageContent(ref metaDescription, ref metaKeywords);
objCommon = new clsCommon();
try
{
string strOrderId = "";
string strTransactionId = "";
string order_id = "";
string tracking_id = "";
string bank_ref_no = "";
string order_status = "";
string payment_mode = "";
string card_name = "";
string currency = "";
bool IsSuccess = false;
if (Session[appFunctions.Session.PaymetnOrderId.ToString()] != null)
{
if (Session[appFunctions.Session.PaymetnOrderId.ToString()].ToString() != "")
{
strOrderId = Session[appFunctions.Session.PaymetnOrderId.ToString()].ToString();
Session[appFunctions.Session.PaymetnOrderId.ToString()] = "";
Session[appFunctions.Session.PaymetnOrderId.ToString()] = null;
}
}
if (Session[appFunctions.Session.PaymentTransactionId.ToString()] != null)
{
if (Session[appFunctions.Session.PaymentTransactionId.ToString()].ToString() != "")
{
strTransactionId = Session[appFunctions.Session.PaymentTransactionId.ToString()].ToString();
Session[appFunctions.Session.PaymentTransactionId.ToString()] = "";
Session[appFunctions.Session.PaymentTransactionId.ToString()] = null;
}
}
CCACrypto ccaCrypto = new CCACrypto();
string encResponse = ccaCrypto.Decrypt(Request.Form["encResp"], appFunctions.strCCAvenueworkingKey);
NameValueCollection Params = new NameValueCollection();
string[] segments = encResponse.Split('&');
foreach (string seg in segments)
{
string[] parts = seg.Split('=');
if (parts.Length > 0)
{
string Key = parts[0].Trim();
string Value = parts[1].Trim();
Params.Add(Key, Value);
}
}
for (int i = 0; i < Params.Count; i++)
{
if (Params.Keys[i].ToString().ToLower() == "order_id")
{
order_id = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "tracking_id")
{
tracking_id = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "bank_ref_no")
{
bank_ref_no = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "order_status")
{
order_status = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "payment_mode")
{
payment_mode = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "card_name")
{
card_name = Params[i].ToString().ToLower();
}
else if (Params.Keys[i].ToString().ToLower() == "currency")
{
currency = Params[i].ToString().ToLower();
}
//Response.Write(Params.Keys[i] + " = " + Params[i] + "<br>");
}
//Response.Write("order_id : " + order_id + "<br>");
//Response.Write("tracking_id : " + tracking_id + "<br>");
//Response.Write("bank_ref_no : " + bank_ref_no + "<br>");
//Response.Write("order_status : " + order_status + "<br>");
//Response.Write("payment_mode : " + payment_mode + "<br>");
//Response.Write("card_name : " + card_name + "<br>");
//Response.Write("currency : " + currency + "<br>");
if (order_status == "success")
{
IsSuccess = true;
//DInfo.ShowMessage("You Successfull Pay for order.", BusinessLayer.Enums.MessageType.Successfull);
}
else
{
//DInfo.ShowMessage("Your online payment Failure.", BusinessLayer.Enums.MessageType.Error);
}
if (strOrderId != "")
{
tblOrder objOrder = new tblOrder();
if (objOrder.LoadByPrimaryKey(Convert.ToInt32(strOrderId)))
{
objOrder.s_AppTransactionID = order_id;
objOrder.s_AppBankRefNo = bank_ref_no;
objOrder.s_AppPaymentType = payment_mode;
objOrder.s_AppCardName = card_name;
objOrder.s_AppCurrency = currency;
if (IsSuccess)
{
objOrder.AppPaymentStatus = Convert.ToInt32(Enums.Enums_PaymentStatus.success);
string strDefaultOrderStatusID = "";
tblOrderStatus objStatus = new tblOrderStatus();
objStatus.Where.AppIsDefault.Value = true;
objStatus.Query.Load();
if (objStatus.RowCount > 0)
{
strDefaultOrderStatusID = objStatus.s_AppOrderStatusID;
}
objStatus = null;
objOrder.s_AppOrderStatusID = strDefaultOrderStatusID;
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetOrderStatus(Convert.ToInt32(strDefaultOrderStatusID), strOrderId, GetCurrentDateTime().ToString(), Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail).ToString());
objSubOrder = null;
}
else
{
objOrder.AppPaymentStatus = Convert.ToInt32(Enums.Enums_PaymentStatus.Failure);
objOrder.AppOrderStatusID = Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail);
tblSubOrder objSubOrder = new tblSubOrder();
objSubOrder.SetOrderStatus(Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail), strOrderId, GetCurrentDateTime().ToString(), Convert.ToInt32(Enums.Enums_OrderStatus.PaymentFail).ToString());
objSubOrder = null;
}
objOrder.Save();
SendMail(objOrder.s_AppOrderNo, objOrder.s_AppReceiverName, objOrder.s_AppReceiverContactNo1, objOrder.s_AppRecevierEmail, IsSuccess, objOrder.s_AppTransactionID, objOrder.s_AppBankRefNo);
objOrder = null;
objOrder = new tblOrder();
objDataTable = objOrder.LoadMyOrderList(Session[appFunctions.Session.ClientUserID.ToString()].ToString(), "", strOrderId);
DataListMyOrder.DataSource = null;
DataListMyOrder.DataBind();
if (objDataTable.Rows.Count > 0)
{
DataListMyOrder.DataSource = objDataTable;
DataListMyOrder.DataBind();
}
}
objOrder = null;
}
}
catch (Exception ex)
{
}
objCommon = null;
}
}