protected void fillGrid()
{
DataTable dt = new DataTable();
dt.Columns.Add("ProdCatId");
dt.Columns.Add("ProdName");
dt.Columns.Add("Stock");
dt.Columns.Add("msrmnt");
dt.Columns.Add("srcPrice");
dt.Columns.Add("listPrice");
dt.Columns.Add("curr");
Dictionary <String, ShopChildProdsInventory> chilDict = ShopChildProdsInventory.
getAllShopChildProdObjsbyEntId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
Dictionary <String, Currency> allCurrList = (Dictionary <String, Currency>)Session[SessionFactory.CURRENCY_LIST];
//This dictionary will be used by created product screen for duplicacy check
Dictionary <String, String> allExistingProdDict = new Dictionary <String, String>();
int counter = 0;
foreach (KeyValuePair <String, ShopChildProdsInventory> kvp in chilDict)
{
dt.Rows.Add();
ShopChildProdsInventory childObj = (ShopChildProdsInventory)kvp.Value;
dt.Rows[counter]["ProdCatId"] = childObj.getProdCatId();
dt.Rows[counter]["ProdName"] = childObj.getProdName();
dt.Rows[counter]["Stock"] = childObj.getQnty();
dt.Rows[counter]["msrmnt"] = childObj.getMsrmntUnit();
dt.Rows[counter]["srcPrice"] = childObj.getUnitSrcPrice();
dt.Rows[counter]["listPrice"] = childObj.getUnitListPrice();
dt.Rows[counter]["curr"] = childObj.getCurrency() != null &&
allCurrList.ContainsKey(childObj.getCurrency()) ?
allCurrList[childObj.getCurrency()].getCurrencyName() : "";
if (!allExistingProdDict.ContainsKey(childObj.getProdName()) && !childObj.getProdName().Equals(""))
{
allExistingProdDict.Add(childObj.getProdName(), childObj.getProdName());
}
counter++;
}
dt.DefaultView.Sort = "ProdName" + " " + "ASC";
Button_Audit_Prod.Enabled = false;
Button_Notes_Prod.Enabled = false;
GridView1.DataSource = dt.DefaultView.ToTable();
GridView1.DataBind();
GridView1.Visible = true;
GridView1.Columns[2].Visible = false;
GridView1.SelectedIndex = -1;
Dictionary <String, bool> accessList = (Dictionary <String, bool>)Session[SessionFactory.ACCESSLIST_FOR_USER];
if (!accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_EDIT_PRODUCT] &&
!accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_OWNER_ACCESS])
{
GridView1.Columns[1].Visible = false;
}
Session[SessionFactory.ALL_PRODUCT_CREATE_PRODUCT_EXISTING_NAMES] = allExistingProdDict;
Session[SessionFactory.ALL_PRODUCT_PROD_DATA_GRID] = dt.DefaultView.ToTable();
}
protected void fillGrid(String catId)
{
if (catId != null && !catId.Equals("") && !catId.Equals("_"))
{
DataTable dt = new DataTable();
dt.Columns.Add("ProdCatId");
dt.Columns.Add("ProdName");
dt.Columns.Add("Stock");
dt.Columns.Add("msrmnt");
dt.Columns.Add("srcPrice");
dt.Columns.Add("listPrice");
dt.Columns.Add("curr");
Dictionary <String, ShopChildProdsInventory> chilDict = ShopChildProdsInventory.
getAllShopChildProdObjsbyEntId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
Dictionary <String, Currency> allCurrList = (Dictionary <String, Currency>)Session[SessionFactory.CURRENCY_LIST];
int counter = 0;
foreach (KeyValuePair <String, ShopChildProdsInventory> kvp in chilDict)
{
ShopChildProdsInventory childObj = (ShopChildProdsInventory)kvp.Value;
if (childObj.getProdCatId().Equals(catId.Trim()) ||
BackEndObjects.ProductCategory.getRootLevelParentCategoryDB(childObj.getProdCatId()).ContainsKey(catId.Trim()))
{
dt.Rows.Add();
dt.Rows[counter]["ProdCatId"] = childObj.getProdCatId();
dt.Rows[counter]["ProdName"] = childObj.getProdName();
dt.Rows[counter]["Stock"] = childObj.getQnty();
dt.Rows[counter]["msrmnt"] = childObj.getMsrmntUnit();
dt.Rows[counter]["srcPrice"] = childObj.getUnitSrcPrice();
dt.Rows[counter]["listPrice"] = childObj.getUnitListPrice();
dt.Rows[counter]["curr"] = dt.Rows[counter]["curr"] = childObj.getCurrency() != null &&
allCurrList.ContainsKey(childObj.getCurrency()) ?
allCurrList[childObj.getCurrency()].getCurrencyName() : "";
counter++;
}
}
Button_Audit_Prod.Enabled = false;
Button_Notes_Prod.Enabled = false;
GridView1.DataSource = dt;
GridView1.DataBind();
GridView1.Visible = true;
GridView1.Columns[2].Visible = false;
GridView1.SelectedIndex = -1;
Dictionary <String, bool> accessList = (Dictionary <String, bool>)Session[SessionFactory.ACCESSLIST_FOR_USER];
if (!accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_EDIT_PRODUCT] &&
!accessList[BackEndObjects.EntityAccessListRecord.ENTITY_ACCESS_LIST_RECORD_ACCESS_OWNER_ACCESS])
{
GridView1.Columns[1].Visible = false;
}
Session[SessionFactory.ALL_PRODUCT_PROD_DATA_GRID] = dt;
}
else
{
fillGrid();
}
}
protected void createNewProduct()
{
Dictionary <String, String> allExistingProdDict = (Dictionary <String, String>)Session[SessionFactory.ALL_PRODUCT_CREATE_PRODUCT_EXISTING_NAMES];
if (allExistingProdDict.ContainsKey(TextBox_Prod_Name.Text.Trim()))
{
Label_Status.Text = "Product Name Already Exists";
Label_Status.Visible = true;
Label_Status.ForeColor = System.Drawing.Color.Red;
}
else if (Session[SessionFactory.CREATE_PRODUCT_SELECTED_PRODUCT_CAT] == null || Session[SessionFactory.CREATE_PRODUCT_SELECTED_PRODUCT_CAT].ToString().Equals(""))
{
Label_Status.Text = "Must select one product category";
Label_Status.Visible = true;
Label_Status.ForeColor = System.Drawing.Color.Red;
}
else
{
if (!TextBox_Spec.Text.Equals(""))
{
getAddintionalProdSrvList();
TextBox_Spec.Text = "";
}
ArrayList prodSpecList = (ArrayList)Session[SessionFactory.CREATE_PRODUCT_CHILD_PROD_SPEC_MAP];
Dictionary <String, String> rSpecUniqnessValidation = new Dictionary <string, string>();
String mainEntId = Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString();
if (prodSpecList != null)
{
for (int i = 0; i < prodSpecList.Count; i++)
{
ShopChildProdsSpecs prodSpecObj = (ShopChildProdsSpecs)prodSpecList[i];
prodSpecObj.setProdName(TextBox_Prod_Name.Text);
if (rSpecUniqnessValidation.ContainsKey(prodSpecObj.getEntityId() + ":" + prodSpecObj.getProdName() + ":" + prodSpecObj.getFeatId()))
{
prodSpecList.RemoveAt(i);
}
else
{
rSpecUniqnessValidation.Add(prodSpecObj.getEntityId() + ":" + prodSpecObj.getProdName() + ":" + prodSpecObj.getFeatId(), prodSpecObj.getEntityId());
if (prodSpecObj != null && prodSpecObj.getFileStream() != null && prodSpecObj.getFileStream().HasFile)
{
prodSpecObj.setImgPathInFileStore(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
}
}
}
}
ShopChildProdsInventory childProdObj = new ShopChildProdsInventory();
childProdObj.setCreatedBy(User.Identity.Name);
childProdObj.setDateCreated(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
childProdObj.setEntityId(mainEntId);
childProdObj.setMsrmntUnit(DropDownList_Unit_Of_Msrmnt.SelectedValue);
childProdObj.setProdCatId(Session[SessionFactory.CREATE_PRODUCT_SELECTED_PRODUCT_CAT].ToString());
childProdObj.setProdName(TextBox_Prod_Name.Text);
childProdObj.setQnty((!TextBox_Stock.Text.Equals("")?float.Parse(TextBox_Stock.Text):0));
childProdObj.setUnitListPrice(TextBox_List_Price.Text);
childProdObj.setUnitSrcPrice(TextBox_Src_Price.Text);
childProdObj.setCurrency(DropDownList_Curr.SelectedValue);
try
{
BackEndObjects.ShopChildProdsInventory.insertShopChildProdsInventoryDB(childProdObj);
if (prodSpecList != null)
{
BackEndObjects.ShopChildProdsSpecs.insertShopChildProdsSpecsListDB(prodSpecList);
}
//Refresh the session variable with the newly added product name
allExistingProdDict.Add(childProdObj.getProdName(), childProdObj.getProdName());
Session[SessionFactory.ALL_PRODUCT_CREATE_PRODUCT_EXISTING_NAMES] = allExistingProdDict;
Dictionary <String, ProductCategory> existingProdDict = MainBusinessEntity.
getProductDetailsforMainEntitybyIdDB(mainEntId);
Label_Status.Text = "Product/Service Details Created Successfully";
Label_Status.Visible = true;
Label_Status.ForeColor = System.Drawing.Color.Green;
DropDownList_Level1.SelectedIndex = -1;
DropDownList_Level2.SelectedIndex = -1;
DropDownList_Level3.SelectedIndex = -1;
if (!existingProdDict.ContainsKey(DropDownList_Level1.SelectedValue))
{
ArrayList newMainProdCat = new ArrayList();
newMainProdCat.Add(DropDownList_Level1.SelectedValue);
MainBusinessEntity.insertProductDetailsforEntityDB(mainEntId, newMainProdCat);
Label_Status.Text += "...New Product category added to your product list";
}
DataTable dt = (DataTable)Session[SessionFactory.ALL_PRODUCT_PROD_DATA_GRID];
dt.Rows.Add();
int count = dt.Rows.Count - 1;
dt.Rows[count]["ProdCatId"] = childProdObj.getProdCatId();
dt.Rows[count]["ProdName"] = childProdObj.getProdName();
dt.Rows[count]["Stock"] = childProdObj.getQnty();
dt.Rows[count]["msrmnt"] = childProdObj.getMsrmntUnit();
dt.Rows[count]["srcPrice"] = childProdObj.getUnitSrcPrice();
dt.Rows[count]["listPrice"] = childProdObj.getUnitListPrice();
dt.Rows[count]["curr"] = DropDownList_Curr.SelectedItem.Text;
Session[SessionFactory.ALL_PRODUCT_PROD_DATA_GRID] = dt;
ScriptManager.RegisterStartupScript(this, typeof(string), "RefreshProdGrid", "RefreshParent();", true);
}
catch (Exception ex)
{
Label_Status.Text = "Product/Service Details Creation Failed";
Label_Status.Visible = true;
Label_Status.ForeColor = System.Drawing.Color.Red;
}
finally
{
Session.Remove(SessionFactory.CREATE_PRODUCT_CHILD_PROD_SPEC_MAP);
Session.Remove(SessionFactory.CREATE_PRODUCT_SELECTED_PRODUCT_CAT);
}
}
}