private void DisplayItemDetail(int grp = 1)
{
MySqlConnection conn = CMain.GetConnection(ApplicationSession.DBName);
ItemDetailCollection col = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().ItemDetails(conn, ApplicationSession.StoreID, ApplicationSession.OutletID);
List <CItemDetail> lst = col.ListBySelectionGroup(grp);
lvwModalListDetail.DataSource = lst;
lvwModalListDetail.DataBind();
btnPrev.Enabled = (grp > col.LBoundIndex());
btnPrev.Attributes.Add("idx", grp.ToString());
btnNext.Enabled = (grp < col.UBoundIndex());
btnNext.Attributes.Add("idx", grp.ToString());
lblMasterName.InnerText = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().TransName;
ShowModalDialog_ListDetail();
}
private void AddAutomaticSelectionGroup(decimal dQty)
{
MySqlConnection conn = CMain.GetConnection(ApplicationSession.DBName);
ItemDetailCollection col = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().ItemDetails(conn, ApplicationSession.StoreID, ApplicationSession.OutletID);
List <CItemDetail> lst = col.AutomaticSelection();
foreach (CItemDetail id in lst)
{
if (!id.IsEmpty())
{
ApplicationSession.idx += 1;
CSalesDetail sd = new CSalesDetail(ApplicationSession.idx, id.ID, id.ItemCode, id.ItemName, id.SelGrp.ToString(), (id.Qty * dQty),
id.Price, id.UnitSymbol, "", "", 0, ApplicationSession.StoreID, ApplicationSession.OutletID,
0, "");
ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().Children.Add(sd);
}
}
}
private decimal GetRemainingQty_currentGroup()
{
List <CItemDetail> lst = new List <CItemDetail>();
string sGrp = btnNext.Attributes["idx"];
bool isNumeric = int.TryParse(sGrp, out int iGrp);
if (isNumeric)
{
MySqlConnection conn = CMain.GetConnection(ApplicationSession.DBName);
ItemDetailCollection col = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().ItemDetails(conn, ApplicationSession.StoreID, ApplicationSession.OutletID);
lst = col.ListBySelectionGroup(iGrp);
}
decimal dTotItem = TotalItem_oneGroup(lst);
decimal dRmnQty = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().Qty - dTotItem;
return(dRmnQty);
}
private CMiniItem CheckIfAnyItemDetailMissing()
{
CMiniItem miniItem = new CMiniItem();
MySqlConnection conn = CMain.GetConnection(ApplicationSession.DBName);
ItemDetailCollection col = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().ItemDetails(conn, ApplicationSession.StoreID, ApplicationSession.OutletID);
int lbound = col.LBoundIndex();
int ubound = col.UBoundIndex();
for (int grp = lbound; grp <= ubound; grp++)
{
List <CItemDetail> lst = col.ListBySelectionGroup(grp);
decimal dTotItem = TotalItem_oneGroup(lst);
decimal dRmnQty = ApplicationSession.SalesMaster.CollectionSalesDetail().SelectedItem().Qty - dTotItem;
if (dRmnQty > 0)
{
miniItem = new CMiniItem(grp, "", dRmnQty, 0);
break;
}
}
return(miniItem);
}
public void StreamIn(RStrmIn reader)
{
while (reader.MoveNext())
{
int propertyId = reader.GetPropertyId(ModelSchema.BridgeAssignmentKeywordArray);
if (propertyId == -1)
{
propertyId = reader.GetPropertyId(ModelSchema.BridgeAssignmentKeywordArrayOld);
}
switch (propertyId)
{
case (int)BridgeAssignmentProperty.Tko:
{
var obj = new BridgeAssignmentTakeoffObjectSummary();
obj.StreamIn(reader);
TakeoffObjectCollection.Add(obj);
break;
}
case (int)BridgeAssignmentProperty.Res:
{
var obj = new BridgeAssignmentResourceSummary();
obj.StreamIn(reader);
ResourceCollection.Add(obj);
break;
}
case (int)BridgeAssignmentProperty.Pass:
{
var obj = new BridgeAssignmentPassSummary();
obj.StreamIn(reader);
AssignmentPassCollection.Add(obj);
break;
}
case (int)BridgeAssignmentProperty.Item:
{
var obj = new BridgeAssignmentEstItemSummary();
obj.StreamIn(reader);
ItemDetailCollection.Add(obj);
break;
}
case (int)BridgeAssignmentProperty.AsnId:
AssignmentId = reader.ReadString();
break;
}
}
foreach (var obj in AssignmentPassCollection)
{
if (obj.PrimaryTakeoffNumber >= 0)
{
var takeoffItem =
TakeoffObjectCollection.FirstOrDefault(tko => tko.TkoRefId == obj.PrimaryTakeoffNumber);
if (takeoffItem != null)
{
takeoffItem.TkoRefId = obj.PrimaryTakeoffNumber;
obj.PrimaryTakeoffObjectCollection.Add(takeoffItem);
}
}
}
}
