public OrderStatusInfo GetModel(object OrderId)
{
OrderStatusInfo model = null;
string cmdText = @"select top 1 OrderId,LineNum,Status,LastUpdatedDate
from OrderStatus
where OrderId = @OrderId " ;
SqlParameter parm = new SqlParameter("@OrderId", SqlDbType.UniqueIdentifier);
parm.Value = Guid.Parse(OrderId.ToString());
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new OrderStatusInfo();
model.OrderId = reader.GetGuid(0);
model.LineNum = reader.GetString(1);
model.Status = reader.GetByte(2);
model.LastUpdatedDate = reader.GetDateTime(3);
}
}
}
return(model);
}
internal IEnumerable <OrderStatusInfo> InitOrderStatuses()
{
return(new[]
{
DefaultOrderStatus = NewOrderStatus(1)
});
}
public IList <OrderStatusInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select OrderId,LineNum,Status,LastUpdatedDate
from OrderStatus";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
IList <OrderStatusInfo> list = new List <OrderStatusInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderStatusInfo model = new OrderStatusInfo();
model.OrderId = reader.GetGuid(0);
model.LineNum = reader.GetString(1);
model.Status = reader.GetByte(2);
model.LastUpdatedDate = reader.GetDateTime(3);
list.Add(model);
}
}
}
return(list);
}
public IList <OrderStatusInfo> GetList()
{
string cmdText = @"select OrderId,LineNum,Status,LastUpdatedDate
from OrderStatus
order by LastUpdatedDate desc " ;
IList <OrderStatusInfo> list = new List <OrderStatusInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderStatusInfo model = new OrderStatusInfo();
model.OrderId = reader.GetGuid(0);
model.LineNum = reader.GetString(1);
model.Status = reader.GetByte(2);
model.LastUpdatedDate = reader.GetDateTime(3);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// Handles the grid's OnAction event.
/// </summary>
/// <param name="actionName">Name of item (button) that throws event</param>
/// <param name="actionArgument">ID (value of Primary key) of corresponding data row</param>
protected void gridElem_OnAction(string actionName, object actionArgument)
{
int orderId = ValidationHelper.GetInteger(actionArgument, 0);
OrderInfo oi = null;
OrderStatusInfo osi = null;
switch (actionName.ToLowerCSafe())
{
case "edit":
string redirectToUrl = UIContextHelper.GetElementUrl(ModuleName.ECOMMERCE, "OrderProperties", false, orderId);
if (customerId > 0)
{
redirectToUrl += "&customerId=" + customerId;
}
URLHelper.Redirect(redirectToUrl);
break;
case "previous":
// Check 'ModifyOrders' and 'EcommerceModify' permission
if (!ECommerceContext.IsUserAuthorizedForPermission(EcommercePermissions.ORDERS_MODIFY))
{
AccessDenied(ModuleName.ECOMMERCE, "EcommerceModify OR ModifyOrders");
}
oi = OrderInfoProvider.GetOrderInfo(orderId);
if (oi != null)
{
osi = OrderStatusInfoProvider.GetPreviousEnabledStatus(oi.OrderStatusID);
if (osi != null)
{
oi.OrderStatusID = osi.StatusID;
// Save order status changes
OrderInfoProvider.SetOrderInfo(oi);
}
}
break;
case "next":
// Check 'ModifyOrders' and 'EcommerceModify' permission
if (!ECommerceContext.IsUserAuthorizedForPermission(EcommercePermissions.ORDERS_MODIFY))
{
AccessDenied(ModuleName.ECOMMERCE, "EcommerceModify OR ModifyOrders");
}
oi = OrderInfoProvider.GetOrderInfo(orderId);
if (oi != null)
{
osi = OrderStatusInfoProvider.GetNextEnabledStatus(oi.OrderStatusID);
if (osi != null)
{
oi.OrderStatusID = osi.StatusID;
// Save order status changes
OrderInfoProvider.SetOrderInfo(oi);
}
}
break;
}
}
/// <summary>
/// Load data of editing orderStatus.
/// </summary>
/// <param name="orderStatusObj">OrderStatus object</param>
protected void LoadData(OrderStatusInfo orderStatusObj)
{
chkStatusEnabled.Checked = orderStatusObj.StatusEnabled;
txtStatusDisplayName.Text = orderStatusObj.StatusDisplayName;
txtStatusName.Text = orderStatusObj.StatusName;
clrPicker.SelectedColor = orderStatusObj.StatusColor;
chkStatusEmail.Checked = orderStatusObj.StatusSendNotification;
chkMarkOrderAsPaid.Checked = orderStatusObj.StatusOrderIsPaid;
}
private void SetUpOrderStatuses()
{
mOrderStatusNew = Factory.DefaultOrderStatus;
mOrderStatusFailed = Factory.NewOrderStatus(2);
mOrderStatusFailed.Insert();
mOrderStatusPaid = Factory.NewOrderStatus(3, true);
mOrderStatusPaid.Insert();
}
protected void gridElem_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int orderStatId = ValidationHelper.GetInteger(((DataRowView)(e.Row.DataItem)).Row["ToStatusID"], 0);
OrderStatusInfo osi = OrderStatusInfoProvider.GetOrderStatusInfo(orderStatId);
if (osi != null)
{
e.Row.Style.Add("background-color", osi.StatusColor);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
rfvStatusDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
rfvStatusName.ErrorMessage = GetString("general.requirescodename");
clrPicker.SupportFolder = "~/CMSAdminControls/ColorPicker";
string currentOrderStatus = GetString("OrderStatus_Edit.NewItemCaption");
// Get order status id from querystring
mOrderStatusId = QueryHelper.GetInteger("orderStatusId", 0);
if (mOrderStatusId > 0)
{
OrderStatusInfo orderStatusObj = EditedObject as OrderStatusInfo;
if (orderStatusObj != null)
{
// Check edited object site ID
CheckEditedObjectSiteID(orderStatusObj.StatusSiteID);
currentOrderStatus = ResHelper.LocalizeString(orderStatusObj.StatusDisplayName);
// Fill editing form
if (!RequestHelper.IsPostBack())
{
LoadData(orderStatusObj);
// Show that the orderStatus was created or updated successfully
if (QueryHelper.GetString("saved", "") == "1")
{
// Show message
ShowChangesSaved();
}
}
}
}
// Initializes page title breadcrumbs control
string[,] pageTitleTabs = new string[2, 3];
pageTitleTabs[0, 0] = GetString("OrderStatus_Edit.ItemListLink");
pageTitleTabs[0, 1] = "~/CMSModules/Ecommerce/Pages/Tools/Configuration/OrderStatus/OrderStatus_List.aspx?siteId=" + SiteID;
pageTitleTabs[0, 2] = "";
pageTitleTabs[1, 0] = currentOrderStatus;
pageTitleTabs[1, 1] = "";
pageTitleTabs[1, 2] = "";
CurrentMaster.Title.Breadcrumbs = pageTitleTabs;
}
public int Update(OrderStatusInfo model)
{
string cmdText = @"update OrderStatus set LineNum = @LineNum,Status = @Status,LastUpdatedDate = @LastUpdatedDate
where OrderId = @OrderId" ;
SqlParameter[] parms =
{
new SqlParameter("@OrderId", SqlDbType.UniqueIdentifier),
new SqlParameter("@LineNum", SqlDbType.Char, 12),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.OrderId;
parms[1].Value = model.LineNum;
parms[2].Value = model.Status;
parms[3].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
public IList <OrderStatusInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
string cmdText = @"select count(*) from OrderStatus ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += " where 1=1 " + sqlWhere;
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms);
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
OrderId,LineNum,Status,LastUpdatedDate
from OrderStatus " ;
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <OrderStatusInfo> list = new List <OrderStatusInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderStatusInfo model = new OrderStatusInfo();
model.OrderId = reader.GetGuid(1);
model.LineNum = reader.GetString(2);
model.Status = reader.GetByte(3);
model.LastUpdatedDate = reader.GetDateTime(4);
list.Add(model);
}
}
}
return(list);
}
public int Insert(OrderStatusInfo model)
{
string cmdText = @"insert into OrderStatus (LineNum,Status,LastUpdatedDate)
values
(@LineNum,@Status,@LastUpdatedDate)
" ;
SqlParameter[] parms =
{
new SqlParameter("@LineNum", SqlDbType.Char, 12),
new SqlParameter("@Status", SqlDbType.TinyInt),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.LineNum;
parms[1].Value = model.Status;
parms[2].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderConnString, CommandType.Text, cmdText, parms));
}
private object gridElem_OnExternalDataBound(object sender, string sourceName, object parameter)
{
if (sourceName == "statusName")
{
var statusRow = parameter as DataRowView;
if (statusRow == null)
{
return(string.Empty);
}
// Create tag with status name and color
var statusInfo = new OrderStatusInfo(statusRow.Row);
return(new Tag
{
Text = statusInfo.StatusDisplayName,
Color = statusInfo.StatusColor
});
}
return(parameter);
}
protected void Page_Load(object sender, EventArgs e)
{
// Register check permissions
EditForm.OnCheckPermissions += (s, args) => CheckConfigurationModification();
OrderStatusInfo orderStatusObj = EditedObject as OrderStatusInfo;
if ((orderStatusObj != null) && (orderStatusObj.StatusID > 0))
{
// Check if not editing object from another site
CheckEditedObjectSiteID(orderStatusObj.StatusSiteID);
}
// Register new object handling
EditForm.OnBeforeSave += (s, args) =>
{
OrderStatusInfo status = EditForm.Data as OrderStatusInfo;
if ((status != null) && (status.StatusID == 0))
{
// Assign order - place
status.StatusOrder = OrderStatusInfoProvider.GetLastStatusOrder(ConfiguredSiteID) + 1;
}
};
}
/// <summary>
/// Gets and bulk updates order statuses. Called when the "Get and bulk update statuses" button is pressed.
/// Expects the CreateOrderStatus method to be run first.
/// </summary>
private bool GetAndBulkUpdateOrderStatuses()
{
// Prepare the parameters
string where = "StatusName LIKE N'MyNewStatus%'";
where = SqlHelperClass.AddWhereCondition(where, "StatusSiteID = " + CMSContext.CurrentSiteID, "AND");
// Get the data
DataSet statuses = OrderStatusInfoProvider.GetOrderStatuses(where, null, 0, null);
if (!DataHelper.DataSourceIsEmpty(statuses))
{
// Loop through the individual items
foreach (DataRow statusDr in statuses.Tables[0].Rows)
{
// Create object from DataRow
OrderStatusInfo modifyStatus = new OrderStatusInfo(statusDr);
// Update the properties
modifyStatus.StatusDisplayName = modifyStatus.StatusDisplayName.ToUpper();
// Update the order status
OrderStatusInfoProvider.SetOrderStatusInfo(modifyStatus);
}
return true;
}
return false;
}
/// <summary>
/// Returns where condition based on webpart fields.
/// </summary>
private string GetWhereCondition()
{
// Orders from current site
string where = "OrderSiteID = " + CMSContext.CurrentSiteID;
// Order status filter
OrderStatusInfo status = OrderStatusInfoProvider.GetOrderStatusInfo(OrderStatus, SiteContext.CurrentSiteName);
if (status != null)
{
where = SqlHelper.AddWhereCondition(where, "OrderStatusID = " + status.StatusID);
}
// Customer or company like filter
if (!string.IsNullOrEmpty(CustomerOrCompany))
{
string safeQueryStr = SecurityHelper.GetSafeQueryString(CustomerOrCompany);
where = SqlHelper.AddWhereCondition(where, "OrderCustomerID IN (SELECT CustomerID FROM COM_Customer WHERE ((CustomerFirstName + ' ' + CustomerLastName + ' ' + CustomerFirstName) LIKE N'%" + safeQueryStr + "%') OR (CustomerCompany LIKE N'%" + safeQueryStr + "%'))");
}
// Filter for orders with note
if (HasNote)
{
where = SqlHelper.AddWhereCondition(where, "(OrderNote != '') AND (OrderNote IS NOT NULL)");
}
// Payment method filter
PaymentOptionInfo payment = PaymentOptionInfoProvider.GetPaymentOptionInfo(PaymentMethod, SiteContext.CurrentSiteName);
if (payment != null)
{
where = SqlHelper.AddWhereCondition(where, "OrderPaymentOptionID = " + payment.PaymentOptionID);
}
// Payment status filter
switch (PaymentStatus.ToLowerCSafe())
{
case PAY_STATUS_NOT_PAID:
where = SqlHelper.AddWhereCondition(where, "(OrderIsPaid = 0) OR (OrderIsPaid IS NULL)");
break;
case PAY_STATUS_PAID:
where = SqlHelper.AddWhereCondition(where, "OrderIsPaid = 1");
break;
}
// Currency filter
CurrencyInfo currencyObj = CurrencyInfoProvider.GetCurrencyInfo(Currency, SiteContext.CurrentSiteName);
if (currencyObj != null)
{
where = SqlHelper.AddWhereCondition(where, "OrderCurrencyID = " + currencyObj.CurrencyID);
}
// Min price in main currency filter
if (MinPriceInMainCurrency > 0)
{
where = SqlHelper.AddWhereCondition(where, "OrderTotalPriceInMainCurrency >= " + MinPriceInMainCurrency);
}
// Max price in main currency filter
if (MaxPriceInMainCurrency > 0)
{
where = SqlHelper.AddWhereCondition(where, "OrderTotalPriceInMainCurrency <= " + MaxPriceInMainCurrency);
}
// Shipping option filter
ShippingOptionInfo shipping = ShippingOptionInfoProvider.GetShippingOptionInfo(ShippingOption, SiteContext.CurrentSiteName);
if (shipping != null)
{
where = SqlHelper.AddWhereCondition(where, "OrderShippingOptionID = " + shipping.ShippingOptionID);
}
// Shipping country filter
where = SqlHelper.AddWhereCondition(where, GetCountryWhereCondition());
// Date filter
where = SqlHelper.AddWhereCondition(where, GetDateWhereCondition());
return(where);
}
protected void AddOrder()
{
CustomerInfo customer = createCustomer();
CountryInfo ci = CountryInfoProvider.GetCountryInfo(ECommerceSettings.DefaultCountryName(CMSContext.CurrentSiteName));
AddressInfo billing = new AddressInfo();
PaymentOptionInfo pi = PaymentOptionInfoProvider.GetPaymentOptionInfo("WorldPay", CMSContext.CurrentSiteName);
OSI = OrderStatusInfoProvider.GetOrderStatusInfo("OrderCreated", CMSContext.CurrentSiteName);
billing.AddressName = customer.CustomerFirstName + " " + customer.CustomerLastName;
billing.AddressPersonalName = "Home";
billing.AddressCity = "";// TxtTown.Text.ToString();
billing.AddressIsBilling = true;
billing.AddressIsShipping = true;
billing.AddressLine1 = "";// TxtAddress1.Text.ToString();
billing.AddressLine2 = "";// TxtAddress2.Text.ToString();
billing.AddressZip = "";// TxtPostcode.Text.ToString();
billing.AddressCustomerID = customer.CustomerID;
billing.AddressCountryID = ci.CountryID;
billing.AddressEnabled = true;
billing.AddressPersonalName = customer.CustomerLastName;
billing.Insert();
ShoppingCart.ShoppingCartBillingAddressID = billing.AddressID;
//Order
// Set order culture
ShoppingCart.ShoppingCartCulture = CMSContext.PreferredCultureCode;
// Update customer preferences
CustomerInfoProvider.SetCustomerPreferredSettings(ShoppingCart);
// Create order
ShoppingCartInfoProvider.SetOrder(ShoppingCart);
order.SetValue("CustomerTitle", txtTitle.Text);
order.OrderCustomerID = customer.CustomerID;
order.OrderBillingAddressID = billing.AddressID;
order.OrderShippingAddressID = billing.AddressID;
order.OrderTotalTax = ShoppingCart.TotalTax;
order.OrderTotalPrice = ShoppingCart.TotalItemsPrice;
order.OrderTotalPriceInMainCurrency = ShoppingCart.TotalItemsPrice;
order.OrderSiteID = CMSContext.CurrentSiteID;
order.OrderStatusID = OSI.StatusID;
order.OrderIsPaid = false;
order.OrderCurrencyID = CMSContext.CurrentSite.SiteDefaultCurrencyID;
order.OrderPaymentOptionID = pi.PaymentOptionID;
order.SetValue("ImagePath", ViewState["PhotoPath"]);
if (!corporate.Checked )
{
order.SetValue("IsGiftAid", gift_aid.Checked);
}
else
{
gift_aid.Checked = false;
}
order.SetValue("AllowUseOfName", use_name.Checked);
order.SetValue("AllowUseOfComment", use_comment.Checked);
order.SetValue("Comment", userComment.InnerText);
order.SetValue("CorporateDonation", corporate.Checked);
OrderInfoProvider.SetOrderInfo(order);
OrderItemInfo oii = OrderItemInfoProvider.GetOrderItemInfo(ShoppingCart.GetShoppingCartItem(ShoppingCart.CartItems[0].CartItemGUID));
oii.OrderItemOrderID = order.OrderID;
OrderItemInfoProvider.SetOrderItemInfo(oii);
}
/// <summary>
/// Handles the gridElem's OnAction event.
/// </summary>
/// <param name="actionName">Name of item (button) that throws event</param>
/// <param name="actionArgument">ID (value of Primary key) of corresponding data row</param>
protected void gridElem_OnAction(string actionName, object actionArgument)
{
int orderId = ValidationHelper.GetInteger(actionArgument, 0);
OrderInfo oi = null;
OrderStatusInfo osi = null;
switch (actionName.ToLowerCSafe())
{
case "edit":
string redirectToUrl = "Order_Edit.aspx?orderID=" + orderId.ToString();
if (customerId > 0)
{
redirectToUrl += "&customerId=" + customerId.ToString();
}
URLHelper.Redirect(redirectToUrl);
break;
case "delete":
// Check 'ModifyOrders' and 'EcommerceModify' permission
if (!ECommerceContext.IsUserAuthorizedForPermission("ModifyOrders"))
{
AccessDenied("CMS.Ecommerce", "EcommerceModify OR ModifyOrders");
}
// delete OrderInfo object from database
OrderInfoProvider.DeleteOrderInfo(orderId);
break;
case "previous":
// Check 'ModifyOrders' and 'EcommerceModify' permission
if (!ECommerceContext.IsUserAuthorizedForPermission("ModifyOrders"))
{
AccessDenied("CMS.Ecommerce", "EcommerceModify OR ModifyOrders");
}
oi = OrderInfoProvider.GetOrderInfo(orderId);
if (oi != null)
{
osi = OrderStatusInfoProvider.GetPreviousEnabledStatus(oi.OrderStatusID);
if (osi != null)
{
oi.OrderStatusID = osi.StatusID;
// Save order status changes
OrderInfoProvider.SetOrderInfo(oi);
}
}
break;
case "next":
// Check 'ModifyOrders' and 'EcommerceModify' permission
if (!ECommerceContext.IsUserAuthorizedForPermission("ModifyOrders"))
{
AccessDenied("CMS.Ecommerce", "EcommerceModify OR ModifyOrders");
}
oi = OrderInfoProvider.GetOrderInfo(orderId);
if (oi != null)
{
osi = OrderStatusInfoProvider.GetNextEnabledStatus(oi.OrderStatusID);
if (osi != null)
{
oi.OrderStatusID = osi.StatusID;
// Save order status changes
OrderInfoProvider.SetOrderInfo(oi);
}
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
rfvStatusDisplayName.ErrorMessage = GetString("general.requiresdisplayname");
rfvStatusName.ErrorMessage = GetString("general.requirescodename");
// Control initializations
lblStatusEmail.Text = GetString("OrderStatus_Edit.StatusSendEmail");
lblStatusDisplayName.Text = GetString("OrderStatus_Edit.StatusDisplayNameLabel");
lblStatusName.Text = GetString("OrderStatus_Edit.StatusNameLabel");
lblStatusColor.Text = GetString("OrderStatus_Edit.StatusColor");
clrPicker.SupportFolder = "~/CMSAdminControls/ColorPicker";
btnOk.Text = GetString("General.OK");
string currentOrderStatus = GetString("OrderStatus_Edit.NewItemCaption");
// Get order status id from querystring
mOrderStatusId = QueryHelper.GetInteger("orderStatusId", 0);
if (mOrderStatusId > 0)
{
OrderStatusInfo orderStatusObj = OrderStatusInfoProvider.GetOrderStatusInfo(mOrderStatusId);
EditedObject = orderStatusObj;
if (orderStatusObj != null)
{
// Check edited object site ID
CheckEditedObjectSiteID(orderStatusObj.StatusSiteID);
currentOrderStatus = ResHelper.LocalizeString(orderStatusObj.StatusDisplayName);
// Fill editing form
if (!RequestHelper.IsPostBack())
{
LoadData(orderStatusObj);
// Show that the orderStatus was created or updated successfully
if (QueryHelper.GetString("saved", "") == "1")
{
lblInfo.Visible = true;
lblInfo.Text = GetString("General.ChangesSaved");
}
}
}
this.CurrentMaster.Title.TitleText = GetString("OrderStatus_Edit.HeaderCaption");
this.CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Ecommerce_OrderStatus/object.png");
}
else
{
this.CurrentMaster.Title.TitleText = GetString("OrderStatus_Edit.NewItemCaption");
this.CurrentMaster.Title.TitleImage = GetImageUrl("Objects/Ecommerce_OrderStatus/new.png");
}
this.CurrentMaster.Title.HelpTopicName = "newedit_order";
this.CurrentMaster.Title.HelpName = "helpTopic";
// Initializes page title breadcrumbs control
string[,] pageTitleTabs = new string[2, 3];
pageTitleTabs[0, 0] = GetString("OrderStatus_Edit.ItemListLink");
pageTitleTabs[0, 1] = "~/CMSModules/Ecommerce/Pages/Tools/Configuration/OrderStatus/OrderStatus_List.aspx?siteId=" + SiteID;
pageTitleTabs[0, 2] = "";
pageTitleTabs[1, 0] = currentOrderStatus;
pageTitleTabs[1, 1] = "";
pageTitleTabs[1, 2] = "";
this.CurrentMaster.Title.Breadcrumbs = pageTitleTabs;
}
/// <summary>
/// Sets data to database.
/// </summary>
protected void btnOK_Click(object sender, EventArgs e)
{
// Check permissions
CheckConfigurationModification();
string errorMessage = new Validator()
.NotEmpty(txtStatusName.Text.Trim(), GetString("general.requirescodename"))
.NotEmpty(txtStatusDisplayName.Text.Trim(), GetString("general.requiresdisplayname")).Result;
if (!ValidationHelper.IsCodeName(txtStatusName.Text.Trim()))
{
errorMessage = GetString("General.ErrorCodeNameInIdentificatorFormat");
}
if (errorMessage == "")
{
OrderStatusInfo orderStatusObj = OrderStatusInfoProvider.GetOrderStatusInfo(txtStatusName.Text.Trim(), SiteInfoProvider.GetSiteName(ConfiguredSiteID));
// If statusName value is unique for site OR edit
if ((orderStatusObj == null) || (orderStatusObj.StatusID == mOrderStatusId))
{
// If statusName value is unique for site -> determine whether it is update or insert
if ((orderStatusObj == null))
{
// Get OrderStatusInfo object by primary key
orderStatusObj = OrderStatusInfoProvider.GetOrderStatusInfo(mOrderStatusId);
if (orderStatusObj == null)
{
// Create new item -> insert
orderStatusObj = new OrderStatusInfo();
orderStatusObj.StatusSiteID = ConfiguredSiteID;
}
}
orderStatusObj.StatusSendNotification = chkStatusEmail.Checked;
orderStatusObj.StatusEnabled = chkStatusEnabled.Checked;
orderStatusObj.StatusDisplayName = txtStatusDisplayName.Text.Trim();
orderStatusObj.StatusName = txtStatusName.Text.Trim();
orderStatusObj.StatusColor = clrPicker.SelectedColor;
orderStatusObj.StatusOrderIsPaid = chkMarkOrderAsPaid.Checked;
if (orderStatusObj.StatusOrder == 0)
{
orderStatusObj.StatusOrder = OrderStatusInfoProvider.GetLastStatusOrder(orderStatusObj.StatusSiteID) + 1;
}
// Save
OrderStatusInfoProvider.SetOrderStatusInfo(orderStatusObj);
URLHelper.Redirect("OrderStatus_Edit.aspx?orderStatusId=" + orderStatusObj.StatusID + "&saved=1&siteId=" + SiteID);
}
else
{
lblError.Visible = true;
lblError.Text = GetString("OrderStatus_Edit.OrderStatusExist");
}
}
else
{
lblError.Visible = true;
lblError.Text = errorMessage;
}
}
private object gridElem_OnExternalDataBound(object sender, string sourceName, object parameter)
{
if (sourceName == "statusName")
{
var statusRow = parameter as DataRowView;
if (statusRow == null)
{
return string.Empty;
}
// Create tag with status name and color
var statusInfo = new OrderStatusInfo(statusRow.Row);
return new Tag
{
Text = statusInfo.StatusDisplayName,
Color = statusInfo.StatusColor
};
}
return parameter;
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(OrderStatusInfo model)
{
return(dal.Update(model));
}
/// <summary>
/// Sets data to database.
/// </summary>
protected void btnOK_Click(object sender, EventArgs e)
{
// Check permissions
CheckConfigurationModification();
string errorMessage = new Validator()
.NotEmpty(txtStatusName.Text.Trim(), GetString("general.requirescodename"))
.NotEmpty(txtStatusDisplayName.Text.Trim(), GetString("general.requiresdisplayname")).Result;
if (!ValidationHelper.IsCodeName(txtStatusName.Text.Trim()))
{
errorMessage = GetString("General.ErrorCodeNameInIdentificatorFormat");
}
if (errorMessage == "")
{
OrderStatusInfo orderStatusObj = OrderStatusInfoProvider.GetOrderStatusInfo(txtStatusName.Text.Trim(), SiteInfoProvider.GetSiteName(ConfiguredSiteID));
// If statusName value is unique for site OR edit
if ((orderStatusObj == null) || (orderStatusObj.StatusID == mOrderStatusId))
{
// If statusName value is unique for site -> determine whether it is update or insert
if ((orderStatusObj == null))
{
// Get OrderStatusInfo object by primary key
orderStatusObj = OrderStatusInfoProvider.GetOrderStatusInfo(mOrderStatusId);
if (orderStatusObj == null)
{
// Create new item -> insert
orderStatusObj = new OrderStatusInfo();
orderStatusObj.StatusSiteID = ConfiguredSiteID;
}
}
orderStatusObj.StatusSendNotification = chkStatusEmail.Checked;
orderStatusObj.StatusEnabled = chkStatusEnabled.Checked;
orderStatusObj.StatusDisplayName = txtStatusDisplayName.Text.Trim();
orderStatusObj.StatusName = txtStatusName.Text.Trim();
orderStatusObj.StatusColor = clrPicker.SelectedColor;
orderStatusObj.StatusOrderIsPaid = chkMarkOrderAsPaid.Checked;
if (orderStatusObj.StatusOrder == 0)
{
orderStatusObj.StatusOrder = OrderStatusInfoProvider.GetLastStatusOrder(orderStatusObj.StatusSiteID) + 1;
}
// Save
OrderStatusInfoProvider.SetOrderStatusInfo(orderStatusObj);
URLHelper.Redirect("OrderStatus_Edit.aspx?orderStatusId=" + orderStatusObj.StatusID + "&saved=1&siteId=" + SiteID);
}
else
{
lblError.Visible = true;
lblError.Text = GetString("OrderStatus_Edit.OrderStatusExist");
}
}
else
{
lblError.Visible = true;
lblError.Text = errorMessage;
}
}
/// <summary>
/// Creates order status. Called when the "Create status" button is pressed.
/// </summary>
private bool CreateOrderStatus()
{
// Create new order status object
OrderStatusInfo newStatus = new OrderStatusInfo();
// Set the properties
newStatus.StatusDisplayName = "My new status";
newStatus.StatusName = "MyNewStatus";
newStatus.StatusEnabled = true;
newStatus.StatusSiteID = CMSContext.CurrentSiteID;
newStatus.StatusOrder = 1;
// Create the order status
OrderStatusInfoProvider.SetOrderStatusInfo(newStatus);
return true;
}
/// <summary>
/// Load data of editing orderStatus.
/// </summary>
/// <param name="orderStatusObj">OrderStatus object</param>
protected void LoadData(OrderStatusInfo orderStatusObj)
{
chkStatusEnabled.Checked = orderStatusObj.StatusEnabled;
txtStatusDisplayName.Text = orderStatusObj.StatusDisplayName;
txtStatusName.Text = orderStatusObj.StatusName;
clrPicker.SelectedColor = orderStatusObj.StatusColor;
chkStatusEmail.Checked = orderStatusObj.StatusSendNotification;
chkMarkOrderAsPaid.Checked = orderStatusObj.StatusOrderIsPaid;
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(OrderStatusInfo model)
{
return(dal.Insert(model));
}
