protected void LinkButtonupdate_click(object sender, System.EventArgs e)
{
CSLOrderingARCBAL.LinqToSqlDataContext db = null;
try
{
pnlGradeDetails.Visible = true;
pnlGradeList.Visible = false;
litAction.Text = "You choose to <b>EDIT GRADE MAPPING</b>";
LinkButton lbctg = sender as LinkButton;
if (lbctg != null)
{
GridViewRow gvr = (GridViewRow)lbctg.NamingContainer;
Label lbl1 = gvr.FindControl("lblProductGradeID") as Label;
ViewState["ProductGradeID"] = lbl1.Text;
}
db = new LinqToSqlDataContext();
var usrDtls = ProductBAL.GetProductGradeById(Convert.ToInt32(ViewState["ProductGradeID"].ToString()));
if (usrDtls != null)
{
txtProductCode.Text = usrDtls.ProductCode;
ddlGrade.SelectedValue = usrDtls.Grade.ToString();
}
db.Dispose();
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LinkButtonupdate_click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session[enumSessions.User_Id.ToString()] == null)
{
Response.Redirect("Login.aspx");
}
if (!Page.IsPostBack)
{
LoadCategories();
}
}
catch (System.Threading.ThreadAbortException)
{
// ** Do Nothing
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "Page_Load", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
public static List <OrderItemDetailsDTO> GetOrderDetailsforReport(int orderID)
{
CSLOrderingARCBAL.LinqToSqlDataContext db = null;
try
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
List <OrderItemDetailsDTO> orderItemDetails = new List <OrderItemDetailsDTO>();
orderItemDetails =
(from o in db.Orders
join oi in db.OrderItems on o.OrderId equals oi.OrderId
join oid in db.OrderItemDetails on oi.OrderItemId equals oid.OrderItemId
join ois in db.OrderStatusMasters on oi.OrderItemStatusId equals ois.OrderStatusId
join op in db.Options on oid.OptionId equals op.OptID into x
from Y in x.DefaultIfEmpty()
select new OrderItemDetailsDTO
{
GPRSNo = oid.GPRSNo,
PSTNNo = oid.PSTNNo,
GSMNo = oid.GSMNo,
LANNo = oid.LANNo,
GPRSNoPostCode = oid.GPRSNoPostCode,
ICCID = oid.ICCID,
OrderItemStatus = ois.OrderStatus,
OptionName = (Y == null ? String.Empty : Y.OptionName)
}).ToList <OrderItemDetailsDTO>();;
// (from o in db.Orders
// join oi in db.OrderItems on o.OrderId equals oi.OrderId
// join oid in db.OrderItemDetails on oi.OrderItemId equals oid.OrderItemId
// join op in db.Options on oid.OptionId equals op.OptID
// join ois in db.OrderStatusMasters on oi.OrderItemStatusId equals ois.OrderStatusId
// where oi.OrderItemId == orderID && oid.GPRSNo !=String.Empty
// select new OrderItemDetailsDTO
// {
// GPRSNo = oid.GPRSNo,
// PSTNNo = oid.PSTNNo,
// GSMNo = oid.GSMNo,
// LANNo = oid.LANNo,
// GPRSNoPostCode = oid.GPRSNoPostCode,
// ICCID = oid.ICCID,
// OrderItemStatus = ois.OrderStatus,
// OptionName = op.OptionName
// }).ToList<OrderItemDetailsDTO>();
db.Dispose();
return(orderItemDetails);
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails("ARC Ordering", "GetOrderDetailsforReport", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, null);
return(null);
}
}
protected void ddlDeliveryTypes_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
int deliTypeID = 0;
int.TryParse(ddlDeliveryTypes.SelectedValue, out deliTypeID);
if (deliTypeID != 0)
{
lblDeliveryTotal.Text = OrdersBAL.CalculateOrderDeliverycharge(deliTypeID).ToString();
lblDtlsDeliveryTotal.Text = lblDeliveryTotal.Text;
decimal amt = Convert.ToDecimal(String.IsNullOrEmpty(lblDtlsOrderTotal.Text) == true ? "0.00" : lblDtlsOrderTotal.Text) + Convert.ToDecimal(lblDtlsDeliveryTotal.Text);
decimal?VAT = amt * VATRate;
lblDtlsVAT.Text = Math.Round(Convert.ToDecimal(VAT), 2).ToString();
lblDtlsTotalToPay.Text = (amt + Math.Round(Convert.ToDecimal(VAT), 2)).ToString();
}
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "ddlDeliveryTypes_SelectedIndexChanged", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
private string LoadARCEmailCC()
{
string val = string.Empty;
LinqToSqlDataContext db = new LinqToSqlDataContext();
try
{
val = db.USP_GetARCEmailCC(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString())).FirstOrDefault().ARC_CCEMAIL;
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadARCEmailCC", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
finally
{
db.Dispose();
}
return(val);
}
public void LoadData()
{
CSLOrderingARCBAL.LinqToSqlDataContext db = null;
try
{
ddlGrade.DataSource = ProductBAL.GradeList();
ddlGrade.DataTextField = "Grade";
ddlGrade.DataValueField = "Grade";
ddlGrade.DataBind();
gvGrade.DataSource = ProductBAL.GetProductGrade();
gvGrade.DataBind();
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadData", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void LinkButtondelete_click(object sender, System.EventArgs e)
{
CSLOrderingARCBAL.LinqToSqlDataContext db = null;
try
{
LinkButton lbdel = sender as LinkButton;
if (lbdel != null)
{
GridViewRow gvr = (GridViewRow)lbdel.NamingContainer;
Label lbl2 = gvr.FindControl("lblProductGradeID") as Label;
ViewState["ProductGradeID"] = lbl2.Text;
}
else
{
//Reset
if (ViewState["ProductGradeID"] != null)
{
}
else
{
//Do a cancel as no value in ViewState
btnCancel_Click(sender, e);
}
}
db = new LinqToSqlDataContext();
Boolean retunStatus = ProductBAL.DeleteProductGrade(Convert.ToInt32(ViewState["ProductGradeID"].ToString()));
if (retunStatus == true)
{
LoadData();
string script = "alertify.alert('" + ltrGrade.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
}
}
catch (Exception objException)
{
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LinkButtondelete_click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void ProductsRepeater_ItemBound(object sender, RepeaterItemEventArgs args)
{
try
{
if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem)
{
USP_GetProductsByCategoryAndArcResult product = (USP_GetProductsByCategoryAndArcResult)args.Item.DataItem;
TextBox txtProductQty = args.Item.FindControl("txtProductQty") as TextBox;
RadioButtonList rdbCompanies = args.Item.FindControl("rdbCompanies") as RadioButtonList;
HiddenField hdnIsDCC = null;
hdnIsDCC = (HiddenField)args.Item.FindControl("hdnIsDCC");
LinqToSqlDataContext db = new LinqToSqlDataContext();
// using the truncated product code get the full product codes eligible for that ARc and displying radio button accordingly
if (Convert.ToBoolean(hdnIsDCC.Value) == true)
{
//displayManufacturerRadioButtons(rdbCompanies, product.ProductId);
// displayManufacturerRadioButtons(rdbCompanies);
displayManufacturerRadioButtons(rdbCompanies, product.ProductCode);
}
if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString())
{
Label lblProductPrice = args.Item.FindControl("lblProductPrice") as Label;
lblProductPrice.Text = String.Empty; // 0.00 for ARC_admin roles
}
}
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "ProductsRepeater_ItemBound", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void rptrDependentProducts_ItemBound(object sender, RepeaterItemEventArgs args)
{
try
{
if (args.Item.ItemType == ListItemType.Item || args.Item.ItemType == ListItemType.AlternatingItem)
{
if (Session[enumSessions.User_Role.ToString()] != null && Session[enumSessions.User_Role.ToString()].ToString() == enumRoles.ARC_Admin.ToString())
{
Label lblProductPrice = (Label)args.Item.FindControl("lblProductPrice");
lblProductPrice.Text = String.Empty;//0.00
Label lblProductPriceTotal = (Label)args.Item.FindControl("lblProductPriceTotal");
lblProductPriceTotal.Text = String.Empty;//0.00
}
}
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "rptrDependentProducts_ItemBound", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void LoadDeliveryTypes()
{
ddlDeliveryTypes.Items.Clear();
//Calculating order total and other offers to populate delivery options
OrdersBAL deliveryOptions = new OrdersBAL();
deliveryOptions.orderId = Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString());
//Set the lowest priced as selected.
int i = 0; int selectedIndex = 0;
decimal leastPriceItem = decimal.MaxValue;
try
{
//List<DeliveryType> shippingOptions = deliveryOptions.GetShippingOptions();
LinqToSqlDataContext db = new LinqToSqlDataContext();
List <USP_GetShippingOptionsResult> shippingOptions = new List <USP_GetShippingOptionsResult>();
shippingOptions = db.USP_GetShippingOptions(Convert.ToInt32(Session[enumSessions.ARC_Id.ToString()].ToString()), new Guid(Session[enumSessions.InstallerCompanyID.ToString()].ToString()), Convert.ToInt32(Session[enumSessions.OrderId.ToString()])).ToList();
foreach (USP_GetShippingOptionsResult delivery in shippingOptions)
{
System.Web.UI.WebControls.ListItem item = new System.Web.UI.WebControls.ListItem();
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-GB", false);
item.Text = delivery.DeliveryShortDesc + " - " + delivery.DeliveryPrice.Value.ToString("c");
item.Value = delivery.DeliveryTypeId.ToString();
if (leastPriceItem != decimal.Zero && delivery.DeliveryPrice < leastPriceItem)
{
leastPriceItem = delivery.DeliveryPrice.Value;
ddlDeliveryTypes.ClearSelection();
ddlDeliveryTypes.SelectedIndex = i;
selectedIndex = i;
}
ddlDeliveryTypes.Items.Add(item);
i++;
}
ddlDeliveryTypes.DataBind();
ddlDeliveryTypes.SelectedIndex = selectedIndex;
bool?isAncillary = false;
db.USP_IsAncillaryOnlyOrders(Convert.ToInt32(Session[enumSessions.OrderId.ToString()]), ref isAncillary);
if (isAncillary.Value == true)
{
lblIsAncillary.Visible = true;
}
else
{
lblIsAncillary.Visible = false;
}
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "LoadDeliveryTypes", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
protected void btnProceed_Click(object sender, EventArgs e)
{
try
{
Page.Validate();
if (Page.IsValid)
{
bool isQtyEntered = false;
TextBox txtProductQty = null;
TextBox lblProductType = null;
TextBox lblProductId = null;
RadioButtonList rdbCompanies = null;
Label lblProductCode = null;
HiddenField hdnIsDCC = null;
LinqToSqlDataContext db = new LinqToSqlDataContext();
int OrderItemId = 0;
int qtyCounter = 0;
foreach (RepeaterItem item in dlProducts.Items)
{
txtProductQty = (TextBox)item.FindControl("txtProductQty");
lblProductType = (TextBox)item.FindControl("lblProductType");
lblProductId = (TextBox)item.FindControl("lblProductId");
rdbCompanies = (RadioButtonList)item.FindControl("rdbCompanies");
lblProductCode = (Label)item.FindControl("lblProductCode");
hdnIsDCC = (HiddenField)item.FindControl("hdnIsDCC");
//only display radio for ISDCC is true
if (Convert.ToBoolean(hdnIsDCC.Value) == true)
{
// displayManufacturerRadioButtons(rdbCompanies);
displayManufacturerRadioButtons(rdbCompanies, lblProductCode.Text);
//displayManufacturerRadioButtons(rdbCompanies, Convert.ToInt32(lblProductId.Text));
}
if (!string.IsNullOrEmpty(txtProductQty.Text) && Convert.ToInt32(txtProductQty.Text) > 0)
{
if (rdbCompanies.Visible == true && (Convert.ToBoolean(hdnIsDCC.Value) == true))
{
if (rdbCompanies.SelectedItem.Text != rdbCompanies.Items[0].Text)//added by priya
{
string companyId = (from dcc in db.DCCCompanies
where dcc.company_name == rdbCompanies.SelectedItem.Text
select dcc.company_id).SingleOrDefault();
if (companyId != null)
{
string productCode = lblProductCode.Text + companyId;
int productid = (from p in db.Products
where p.ProductCode == productCode
select p.ProductId).SingleOrDefault();
//validation to check if the productid exists needed
if (productid != 0)
{
lblProductId.Text = productid.ToString();
}
else
{
string script = "alertify.alert('" + ltrNotaValidProduct + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
}
}
else
{
string script = "alertify.alert('" + ltrSelectManufacturer.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
}
int CategoryID = Convert.ToInt32(Request.QueryString["CategoryId"]);
//update product code and product id
var orderitem = db.USP_SaveOrderItems(Convert.ToInt32(Session[enumSessions.OrderId.ToString()].ToString()), Convert.ToInt32(lblProductId.Text), Convert.ToInt32(txtProductQty.Text), new Guid(Session[enumSessions.User_Id.ToString()].ToString()), Session[enumSessions.User_Name.ToString()].ToString(), Convert.ToInt32(Request.QueryString["CategoryId"])).SingleOrDefault();
if (orderitem != null)
{
if (orderitem.OrderItemId.HasValue)
{
int.TryParse(orderitem.OrderItemId.Value.ToString(), out OrderItemId);
}
}
if (OrderItemId != 0)
{
/* by ajitender
* db.USP_DeleteOrderItemDetailsByOrderItemId(OrderItemId);*/
List <String> CategorieswithNoChipNo = (from app in db.ApplicationSettings
where app.KeyName == "CategorieswithNoChipNo"
select app.KeyValue).SingleOrDefault().Split(',').ToList();
string GPRSNo = string.Empty;
if (CategorieswithNoChipNo.Contains(CategoryID.ToString()))
{
GPRSNo = "0000";
}
for (qtyCounter = 0; qtyCounter < Convert.ToInt32(txtProductQty.Text); qtyCounter++)
{
db.USP_AddOrderItemDetailsToBasket(OrderItemId, GPRSNo, "", Session[enumSessions.User_Name.ToString()].ToString());
}
}
isQtyEntered = true;
}
}
db.Dispose();
if (isQtyEntered)
{
Response.Redirect("Basket.aspx");
}
else
{
string script = "alertify.alert('" + ltrEnterQntty.Text + "');";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "alert", script, true);
return;
}
}
}
catch (System.Threading.ThreadAbortException ex)
{
//
}
catch (Exception objException)
{
CSLOrderingARCBAL.LinqToSqlDataContext db;
db = new CSLOrderingARCBAL.LinqToSqlDataContext();
db.USP_SaveErrorDetails(Request.Url.ToString(), "btnProceed_Click", Convert.ToString(objException.Message), Convert.ToString(objException.InnerException), Convert.ToString(objException.StackTrace), "", HttpContext.Current.Request.UserHostAddress, false, Convert.ToString(HttpContext.Current.Session[enumSessions.User_Id.ToString()]));
db.Dispose();
}
}
