private void PopulateDataGrid()
{
// Hide Controls
this.dvEmptyContent.Visible = false;
this.dvDataContent.Visible = false;
this.dvNoSearchResult.Visible = false;
// Search text
string searchText = this.txtSearch.Text.ToLower().Trim();
// Populate Items
//PriceLevelBO objPriceLevel = new PriceLevelBO();
//List<PriceLevelBO> lstPriceLevels = new List<PriceLevelBO>();
PriceLevelNewBO objPriceLevel = new PriceLevelNewBO();
List <PriceLevelNewBO> lstPriceLevels = new List <PriceLevelNewBO>();
if ((searchText != string.Empty) && (searchText != "search"))
{
lstPriceLevels = (from o in objPriceLevel.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList()
where o.Name.ToLower().Contains(searchText)
select o).ToList();
}
else
{
lstPriceLevels = objPriceLevel.SearchObjects().AsQueryable().OrderBy(SortExpression).ToList();
}
if (lstPriceLevels.Count > 0)
{
this.dgPriceLevels.AllowPaging = (lstPriceLevels.Count > this.dgPriceLevels.PageSize);
this.dgPriceLevels.DataSource = lstPriceLevels;
this.dgPriceLevels.DataBind();
this.dvDataContent.Visible = true;
}
else if ((searchText != string.Empty && searchText != "search"))
{
this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty);
this.dvDataContent.Visible = true;
this.dvNoSearchResult.Visible = true;
}
else
{
this.dvEmptyContent.Visible = true;
this.btnAddPriceLevel.Visible = false;
}
this.dgPriceLevels.Visible = (lstPriceLevels.Count > 0);
}
protected void dgPriceLevels_ItemDataBound(object sender, DataGridItemEventArgs e)
{
DataGridItem item = e.Item;
//if (item.ItemIndex > -1 && item.DataItem is PriceLevelBO)
//{
// PriceLevelBO objPriceLevel = (PriceLevelBO)item.DataItem;
if (item.ItemIndex > -1 && item.DataItem is PriceLevelNewBO)
{
PriceLevelNewBO objPriceLevel = (PriceLevelNewBO)item.DataItem;
HyperLink linkEdit = (HyperLink)item.FindControl("linkEdit");
linkEdit.Attributes.Add("qid", objPriceLevel.ID.ToString());
HyperLink linkDelete = (HyperLink)item.FindControl("linkDelete");
linkDelete.Attributes.Add("qid", objPriceLevel.ID.ToString());
}
}
/// <summary>
/// Process the page data.
/// </summary>
///
private void ProcessForm(int queryId, bool isDelete)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
PriceLevelNewBO objPriceLevel = new PriceLevelNewBO(this.ObjContext);
if (queryId > 0)
{
objPriceLevel.ID = queryId;
objPriceLevel.GetObject();
}
if (isDelete)
{
objPriceLevel.Delete();
}
else
{
objPriceLevel.Name = txtName.Text;
objPriceLevel.Volume = txtVolume.Text;
objPriceLevel.Markup = decimal.Parse(txtMarkup.Text);
objPriceLevel.LastModifier = this.LoggedUser.ID;
objPriceLevel.LastModifiedDate = DateTime.Now;
}
if (queryId == 0)
{
objPriceLevel.Add();
}
this.ObjContext.SaveChanges();
ts.Complete();
}
}
catch (Exception ex)
{
// Log the error
IndicoLogging.log.Error("Error occured while Saving the PriceLevel", ex);
}
}
private void ReBindGrid()
{
if (Session["CostSheetDetails"] != null)
{
RadGridCostSheets.DataSource = (DataTable)Session["CostSheetDetails"];
RadGridCostSheets.MasterTableView.GetColumn("IndimanPrice").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("QuotedFOBPrice").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("FOBCost").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("CostSheet").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("ActMgn").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("QuotedMp").FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.MasterTableView.GetColumn("FabricPrice").FilterControlWidth = Unit.Pixel(50);
if (this.DisplayMarginRates && !this.IsFOB)
{
RadGridCostSheets.MasterTableView.GetColumn("Save").FilterControlWidth = Unit.Pixel(50);
}
int column = 16;
if (DisplayPriceLevels)
{
List <PriceLevelNewBO> lstPriceLevels = new PriceLevelNewBO().SearchObjects();
foreach (PriceLevelNewBO objLevel in lstPriceLevels)
{
RadGridCostSheets.Columns[column].FilterControlWidth = Unit.Pixel(50);
column++;
}
RadGridCostSheets.Columns[column].FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.Columns[++column].FilterControlWidth = Unit.Pixel(50);
}
//if (DisplayMarginRates)
// RadGridCostSheets.Columns[column].FilterControlWidth = Unit.Pixel(50);
RadGridCostSheets.DataBind();
}
}
protected void btnApply_Click(object sender, EventArgs e)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
Button btn = (Button)(sender);
int level = int.Parse(btn.CommandName);
GridHeaderItem header = (GridHeaderItem)this.RadGridCostSheets.MasterTableView.GetItems(GridItemType.Header)[0];
TextBox txtPrice = (TextBox)header.FindControl("txtPrice" + level);
PriceLevelNewBO objLevel = new PriceLevelNewBO(this.ObjContext);
objLevel.ID = level;
objLevel.GetObject();
objLevel.LastModifier = this.LoggedUser.ID;
objLevel.LastModifiedDate = DateTime.Now;
objLevel.Markup = decimal.Parse(txtPrice.Text);
this.ObjContext.SaveChanges();
ts.Complete();
}
if (IsFOB)
{
Server.Transfer("EditIndicoFOBPriceLevel.aspx");
}
else
{
Server.Transfer("EditIndicoCIFPriceLevel.aspx");
}
}
catch (Exception ex)
{
// Log the error
IndicoLogging.log.Error("Error occured while saving value to PriceLevelNewBO from IndicoPriceLevels.ascx", ex);
}
}
private void PopulateDataGrid()
{
// Hide Controls
this.dvEmptyContent.Visible = false;
this.dvDataContent.Visible = false;
this.dvNoSearchResult.Visible = false;
// Populate Items
IndicoCIFPriceViewBO objPrice = new IndicoCIFPriceViewBO();
List <IndicoCIFPriceViewBO> lstCostSheets = objPrice.SearchObjects().OrderBy(m => m.PatternCode).ToList();
if (IsFOB)
{
lstCostSheets.ForEach(m => m.IndimanPrice = (m.IndimanPrice - m.ConversionFactor));
}
DataTable dtCostSheets = ToDataTable(lstCostSheets);
if (lstCostSheets.Count > 0)
{
this.RadGridCostSheets.AllowPaging = (lstCostSheets.Count > this.RadGridCostSheets.PageSize);
if (DisplayPriceLevels)
{
List <PriceLevelNewBO> lstPriceLevels = new PriceLevelNewBO().SearchObjects();
if (lstPriceLevels.Any())
{
ViewState["LevelCount"] = lstPriceLevels.Count;
foreach (PriceLevelNewBO objLevel in lstPriceLevels)
{
string colName = objLevel.Volume.Replace(' ', '_');
GridTemplateColumn tempColumn = new GridTemplateColumn();
tempColumn.AllowFiltering = true;
tempColumn.DataField = colName;
tempColumn.FilterControlWidth = Unit.Pixel(50);
tempColumn.UniqueName = colName;
//tempColumn.HeaderText = objLevel.Volume + " units";
RadGridCostSheets.Columns.Add(tempColumn);
DataColumn columnLevel = new DataColumn(colName, typeof(string));
columnLevel.DefaultValue = "$0.00";
dtCostSheets.Columns.Add(columnLevel);
int row = 0;
foreach (IndicoCIFPriceViewBO objCostSheet in lstCostSheets)
{
dtCostSheets.Rows[row++][columnLevel] = "$" + ((objCostSheet.IndimanPrice ?? 0) / Convert.ToDecimal(((100 - objLevel.Markup) / 100))).ToString("0.00");
}
}
GridTemplateColumn whatIfPriceColumn = new GridTemplateColumn();
whatIfPriceColumn.FilterControlWidth = Unit.Pixel(50);
whatIfPriceColumn.AllowFiltering = false;
whatIfPriceColumn.UniqueName = "WhatPrice";
RadGridCostSheets.Columns.Add(whatIfPriceColumn);
whatIfPriceColumn.HeaderText = "What-if Price";
GridTemplateColumn whatIfPercentageColumn = new GridTemplateColumn();
whatIfPercentageColumn.FilterControlWidth = Unit.Pixel(50);
whatIfPercentageColumn.AllowFiltering = false;
whatIfPercentageColumn.UniqueName = "WhatPercentage";
RadGridCostSheets.Columns.Add(whatIfPercentageColumn);
whatIfPercentageColumn.HeaderText = "What-if %";
litModified.Text = "Last Modified by " + lstPriceLevels.First().objLastModifier.GivenName + " " + lstPriceLevels.First().objLastModifier.FamilyName + " on " + lstPriceLevels.First().LastModifiedDate.ToShortDateString();
}
}
if (this.DisplayMarginRates && !this.IsFOB)
{
GridTemplateColumn savePriceColumn = new GridTemplateColumn();
savePriceColumn.FilterControlWidth = Unit.Pixel(50);
savePriceColumn.AllowFiltering = false;
savePriceColumn.UniqueName = "Save";
RadGridCostSheets.Columns.Add(savePriceColumn);
savePriceColumn.HeaderText = string.Empty;
}
this.RadGridCostSheets.DataSource = dtCostSheets;
this.RadGridCostSheets.DataBind();
RadGridCostSheets.MasterTableView.GetColumn("LastModifier").Display = false;
RadGridCostSheets.MasterTableView.GetColumn("ModifiedDate").Display = false;
RadGridCostSheets.MasterTableView.GetColumn("Remarks").Display = false;
RadGridCostSheets.MasterTableView.GetColumn("IndimanPrice").Visible = this.DisplayIndimanPrice;
RadGridCostSheets.MasterTableView.GetColumn("QuotedFOBPrice").Visible = this.DisplayJKPrice;
RadGridCostSheets.MasterTableView.GetColumn("FOBCost").Visible = this.DisplayFOBCost;
RadGridCostSheets.MasterTableView.GetColumn("CostSheet").Visible = this.DisplayCostSheet;
RadGridCostSheets.MasterTableView.GetColumn("ActMgn").Visible = this.DisplayMarginRates;
RadGridCostSheets.MasterTableView.GetColumn("QuotedMp").Visible = this.DisplayMarginRates;
RadGridCostSheets.MasterTableView.GetColumn("FabricPrice").Visible = this.DisplayFabricPrice;
this.dvDataContent.Visible = true;
Session["CostSheetDetails"] = dtCostSheets;
}
//else if ((searchText != string.Empty && searchText != "search"))
//{
// this.lblSerchKey.Text = searchText + ((searchText != string.Empty) ? " - " : string.Empty);
// this.dvDataContent.Visible = true;
// this.dvNoSearchResult.Visible = true;
//}
else
{
this.dvEmptyContent.Visible = true;
//this.btnAddSetting.Visible = false;
}
this.RadGridCostSheets.Visible = (lstCostSheets.Count > 0);
}
protected void RadGridCostSheets_ItemCreated(object sender, GridItemEventArgs e)
{
if (e.Item is GridHeaderItem)
{
if (DisplayPriceLevels)
{
IndicoPage page = new IndicoPage();
GridHeaderItem item = (GridHeaderItem)e.Item;
List <PriceLevelNewBO> lstPriceLevels = new PriceLevelNewBO().SearchObjects();
foreach (PriceLevelNewBO objLevel in lstPriceLevels)
{
TableCell cell = (TableCell)item[objLevel.Volume.Replace(' ', '_')];
Label lblBR = new Label();
lblBR.Text = objLevel.Volume + " units</br>";
cell.Controls.Add(lblBR);
if (page.LoggedUserRoleName == IndicoPage.UserRole.IndimanAdministrator || page.LoggedUserRoleName == IndicoPage.UserRole.IndicoAdministrator)
{
Button btnApply = new Button();
btnApply.Text = "Apply";
btnApply.CssClass = "btn btn-info";
btnApply.ForeColor = Color.White;
btnApply.Click += btnApply_Click;
btnApply.CommandName = objLevel.ID.ToString();
TextBox txtPrice = new TextBox();
txtPrice.ID = "txtPrice" + objLevel.ID.ToString();
txtPrice.Text = objLevel.Markup.ToString();
txtPrice.Width = Unit.Pixel(50);
txtPrice.BorderStyle = BorderStyle.Inset;
txtPrice.Height = Unit.Pixel(15);
txtPrice.Width = Unit.Pixel(40);
cell.Controls.Add(txtPrice);
cell.Controls.Add(btnApply);
}
else
{
Label lblPercentage = new Label();
lblPercentage.Text = objLevel.Markup.ToString() + "%";
lblPercentage.Width = Unit.Pixel(50);
cell.Controls.Add(lblPercentage);
}
}
}
}
else if (e.Item is GridDataItem)
{
if (this.DisplayMarginRates && !this.IsFOB)
{
var item = e.Item as GridDataItem;
DataRowView objPrice = (DataRowView)item.DataItem;
Button btnSave = new Button();
btnSave.ID = "btnSave";
btnSave.Text = "Save";
btnSave.CssClass = "btn btn-info";
btnSave.ForeColor = Color.White;
btnSave.Width = Unit.Pixel(50);
btnSave.CommandName = "Save";
item["Save"].Controls.Add(btnSave);
}
}
}
protected void RadGridCostSheets_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
var item = e.Item as GridDataItem;
if (item.ItemIndex > -1 && item.DataItem is DataRowView)
{
DataRowView objPrice = (DataRowView)item.DataItem;
HyperLink hlCostSheet = (HyperLink)item.FindControl("hlCostSheet");
hlCostSheet.Text = objPrice["CostSheetId"].ToString();
hlCostSheet.NavigateUrl = "../AddEditFactoryCostSheet.aspx?id=" + objPrice["CostSheetId"].ToString();
Literal litFabricCost = (Literal)item.FindControl("litFabricCost");
litFabricCost.Text = "$" + objPrice["FabricPrice"].ToString();
Literal litIndimanPrice = (Literal)item.FindControl("litIndimanPrice");
litIndimanPrice.Text = "$" + ((this.DisplayMarginRates && !this.IsFOB) ? string.Empty : objPrice["IndimanPrice"].ToString());
TextBox txtIndimanPrice = (TextBox)item.FindControl("txtIndimanPrice");
txtIndimanPrice.Text = objPrice["IndimanPrice"].ToString();
txtIndimanPrice.Visible = this.DisplayMarginRates && !this.IsFOB;
HiddenField hdnCSID = (HiddenField)e.Item.FindControl("hdnCSID");
hdnCSID.Value = objPrice["CostSheetId"].ToString();
Literal litActMgn = (Literal)item.FindControl("litActMgn");
litActMgn.Text = "$" + objPrice["ActMgn"].ToString();
Literal litQuotedMp = (Literal)item.FindControl("litQuotedMp");
litQuotedMp.Text = objPrice["QuotedMp"].ToString() + "%";
Literal litFOBCost = (Literal)item.FindControl("litFOBCost");
litFOBCost.Text = "$" + objPrice["FOBCost"].ToString();
Literal litQuotedFOBPrice = (Literal)item.FindControl("litQuotedFOBPrice");
litQuotedFOBPrice.Text = "$" + objPrice["QuotedFOBPrice"].ToString();
DateTime dtModified = DateTime.Parse(objPrice["ModifiedDate"].ToString());
if (dtModified.Year != 1900)
{
Literal litModifiedDate = (Literal)item.FindControl("litModifiedDate");
litModifiedDate.Text = dtModified.ToShortDateString();
}
int column = 18;
if (DisplayPriceLevels)
{
List <PriceLevelNewBO> lstPriceLevels = new PriceLevelNewBO().SearchObjects();
foreach (PriceLevelNewBO objLevel in lstPriceLevels)
{
item.Cells[column].Text = objPrice[objLevel.Volume.Replace(' ', '_')].ToString(); //"$" + ((objPrice.IndimanPrice ?? 0) / Convert.ToDecimal(((100 - objLevel.Markup) / 100))).ToString("0.00");
item.Cells[column++].HorizontalAlign = HorizontalAlign.Right;
}
TextBox txtPrice = new TextBox();
txtPrice.ID = "txtPrice";
txtPrice.Width = Unit.Pixel(50);
txtPrice.CssClass = "iWhatPrice";
item["WhatPrice"].Controls.Add(txtPrice);
TextBox txtPercentage = new TextBox();
txtPercentage.ID = "txtPercentage";
txtPercentage.Width = Unit.Pixel(50);
txtPercentage.CssClass = "iWhatPercentage";
item["WhatPercentage"].Controls.Add(txtPercentage);
}
}
}
}
