protected void Page_Load(object sender, EventArgs e)
{
WareShelfDAL shelfDAl = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var listAll = shelfDAl.GetAllShelfs();
Response.Write(AllShelfs(listAll));
}
public DisplayWShelfItemDetails LoadEditShelfItems(string shelfId)
{
var obj = new DisplayWShelfItemDetails();
WShelfItemDetailsDAL shelfDAl = new WShelfItemDetailsDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
obj = shelfDAl.GetDisplayWShelfItemDetailsBYId(Convert.ToInt32(shelfId));
WareShelfDAL shelRow = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var shelf = shelRow.GetShelfById(obj.LocationId);
obj.LocationColumnName = shelf.ColumnName;
return(obj);
}
protected void LoadShelfDetails()
{
WareShelfDAL shelfDAl = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var listAll = shelfDAl.GetAllShelfs();
var listRow = new List <LocationManageRow>();
Dictionary <string, string> list = new Dictionary <string, string>();
foreach (var item in listAll)
{
if (!list.ContainsValue(item.ColumnName))
{
list.Add(item.Id.ToString(), (item.ColumnName));
}
var obj = new LocationManageRow();
obj.Id = item.Id.ToString();
obj.RowName = item.RowNumber;
obj.ColName = item.ColumnName;
listRow.Add(obj);
}
Dictionary <string, string> listRowDrop = new Dictionary <string, string>();
if (listAll.Count() > 0)
{
var firstElement = listAll[0];
var filterRowsById = (from ro in listAll where ro.ColumnName == firstElement.ColumnName select ro).ToList();
foreach (var item in filterRowsById)
{
listRowDrop.Add(item.Id.ToString(), (item.RowNumber));
}
}
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
var serJsonDetails = javaScriptSerializer.Serialize(listRow);
rownamehidden.Value = serJsonDetails;
warehouselocationdropdownlist.DataSource = list;
warehouselocationdropdownlist.DataTextField = "Value";
warehouselocationdropdownlist.DataValueField = "Key";
warehouselocationdropdownlist.DataBind();
warehouselocationrowdropdownlist.DataSource = listRowDrop;
warehouselocationrowdropdownlist.DataTextField = "Value";
warehouselocationrowdropdownlist.DataValueField = "Key";
warehouselocationrowdropdownlist.DataBind();
}
public DisplayWShelfItemDetails LoadEditShelfItems(string suppItemCode)
{
var obj = new DisplayWShelfItemDetails();
WShelfItemDetailsDAL shelfDAl = new WShelfItemDetailsDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var supplierIdForInhouse = 8;
var itemHouse = shelfDAl.GetItemBySupplierIdAndItemCode(suppItemCode.Trim(), supplierIdForInhouse);
WareShelfDAL shelRow = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
if (itemHouse.ItemID > 0)
{
var listItmesShelf = shelfDAl.GetAllShelfItems();
var itemSelected = (from sh in listItmesShelf where sh.ItemId == itemHouse.ItemID select sh).ToList();
if (itemSelected.Count() > 0)
{
obj.ItemId = itemSelected[0].ItemId;
obj.Boxing = listItmesShelf[0].Boxing;
obj.Brand = listItmesShelf[0].Brand;
obj.COG = listItmesShelf[0].COG;
obj.Damaged = listItmesShelf[0].Damaged;
obj.Description = listItmesShelf[0].Description;
obj.DSB = listItmesShelf[0].DSB;
obj.Height = listItmesShelf[0].Height;
obj.Id = listItmesShelf[0].Id;
obj.Length = listItmesShelf[0].Length;
obj.LocationColumnName = listItmesShelf[0].LocationColumnName;
obj.LocationId = listItmesShelf[0].LocationId;
obj.LocationRowNumber = listItmesShelf[0].LocationRowNumber;
obj.ManagerUnitPrice = listItmesShelf[0].ManagerUnitPrice;
obj.Name = listItmesShelf[0].Name;
obj.Notes = listItmesShelf[0].Notes;
obj.OEMCode = listItmesShelf[0].OEMCode;
obj.Quantity = listItmesShelf[0].Quantity;
obj.RepUnitPrice = listItmesShelf[0].RepUnitPrice;
obj.SupplierItemCode = listItmesShelf[0].SupplierItemCode;
}
}
return(obj);
}
protected void LoadShelfDetails()
{
WareShelfDAL shelfDAl = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var listAll = shelfDAl.GetAllShelfs();
var listRow = new List <LocationManageSearchRow>();
foreach (var item in listAll)
{
var obj = new LocationManageSearchRow();
obj.Id = item.Id.ToString();
obj.RowName = item.RowNumber;
obj.ColName = item.ColumnName;
listRow.Add(obj);
}
JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
var serJsonDetails = javaScriptSerializer.Serialize(listRow);
rowlocationhidden.Value = serJsonDetails;
}
protected void Page_Load(object sender, EventArgs e)
{
String rowNumber = Request.Form["RowNumber"].ToString().Trim();
String columnName = Request.Form["ColumnName"].ToString().Trim();
WareShelfDAL shelfDAl = new WareShelfDAL(ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString);
var checkAldearyExistObj = shelfDAl.ISRowAndColumnExist(columnName, rowNumber);
if (checkAldearyExistObj.Id > 0)
{
Response.Write("-1");
}
else
{
// var vsoid;
var obj = new WShelf();
obj.ColumnName = columnName;
obj.RowNumber = rowNumber;
shelfDAl.CreateShelf(obj);
Response.Write("1");
}
}
