private void rptSampleTicketCoffee_DataInitialize(object sender, EventArgs e)
{
this.txtDateGenerated.Text = DateTime.Today.ToString("dd MMM-yyyy");
//Load Sample ticket with data.
if (HttpContext.Current.Session["Sample"] != null)
{
SamplingBLL objSampling = new SamplingBLL();
objSampling = (SamplingBLL)HttpContext.Current.Session["Sample"];
objSampling = objSampling.GetSampleDetail(objSampling.Id);
this.txtDateSampled.Text = objSampling.GeneratedTimeStamp.ToString("dd MMM-yyyy");
this.txtCode.Text = objSampling.SampleCode.ToString();
EmployeeAttendanceBLL objEmployee = new EmployeeAttendanceBLL();
this.txtSamplerName.Text = UserRightBLL.GetUserNameByUserId(objSampling._sampler.SamplerId);
VoucherInformationBLL objVoucher = new VoucherInformationBLL();
objVoucher = objVoucher.GetVoucherInformationByCommodityDepositRequestId(objSampling.ReceivigRequestId);
if (objVoucher != null)
{
this.txtNoBags.Text = objVoucher.NumberofBags.ToString();
this.txtPlompTruck.Text = objVoucher.NumberOfPlomps.ToString();
this.txtPlompTrailer.Text = objVoucher.NumberOfPlompsTrailer.ToString();
}
//Get Driver information.
List <DriverInformationBLL> list = new List <DriverInformationBLL>();
DriverInformationBLL obj = new DriverInformationBLL();
list = obj.GetActiveDriverInformationByReceivigRequestId(objSampling.ReceivigRequestId);
if (list != null)
{
if (list.Count == 1)
{
obj = list[0];
this.txtPlateNo.Text = obj.PlateNumber.ToString();
this.txtTrailerPlateNo.Text = obj.TrailerPlateNumber.ToString();
}
}
}
HttpContext.Current.Session["Sample"] = null;
HttpContext.Current.Session["Sampler"] = null;
}
protected void gvStackUnloaded_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
StackUnloadedBLL obj = (StackUnloadedBLL)e.Row.DataItem;
if (this.gvStackUnloaded.EditIndex == -1)
{
Label lblInv = (Label)e.Row.FindControl("lblInvetoryCont");
Label lblStaclg = (Label)e.Row.FindControl("lblStackNo");
lblInv.Text = UserRightBLL.GetUserNameByUserId(obj.UserId);
lblStaclg.Text = obj.StackNo;
}
else
{
//Label lblEditstat = (Label)e.Row.FindControl("lblEditstatus");
//DropDownList cboInv = (DropDownList)e.Row.FindControl("cboStackUnloadedStatus");
//cboInv.SelectedValue = lblEditstat.Text;
}
}
}
private IDictionary <object, string> GetWorkersLookup(string role)
{
CachedDictionary <string> workers = new CachedDictionary <string>(
delegate(string user)
{
return(user);
},
delegate(object key)
{
//return UserRightBLL.GetUsersWithRight(role).Find(u => u.UserId == (Guid)key).FullName;
return(UserRightBLL.GetUserNameByUserId((Guid)key));
},
delegate()
{
return(new List <KeyValuePair <object, string> >(
from user in UserRightBLL.GetUsersWithRight(role)
select new KeyValuePair <object, string>(user.UserId, user.FullName)));
});
ICollection <object> keys = workers.Keys;
return(workers);
}
private void CoffeeCodingReport_FetchData(object sender, FetchEventArgs eArgs)
{
string t = "";
try
{
reader.Read();
if (reader["UserId"] != DBNull.Value)
{
t = UserRightBLL.GetUserNameByUserId(new Guid(reader["UserId"].ToString()));
Fields["Grader"].Value = UserRightBLL.GetUserNameByUserId(new Guid(reader["UserId"].ToString()));
}
if (reader["isSupervisor"] != DBNull.Value)
{
Fields["IsSuper"].Value = reader["isSupervisor"].ToString();
}
eArgs.EOF = false;
}
catch (Exception ex)
{
eArgs.EOF = true;
}
}
private void rptGRN_ReportStart(object sender, EventArgs e)
{
if (HttpContext.Current.Session["GRNIDPrint"] == null)
{
throw new Exception("Session expired");
}
Guid GRNId = Guid.Empty;
GRNId = new Guid(HttpContext.Current.Session["GRNIDPrint"].ToString());
Guid GradingId = Guid.Empty;
GRNBLL objGRN = new GRNBLL();
objGRN = objGRN.GetbyGRN_Number(GRNId);
GradingId = objGRN.GradingId;
this.lblGRN_No.Text = objGRN.GRN_Number;
this.lblClient.Text = ClientBLL.GetClinetNameById(objGRN.ClientId);
this.lblCommodityGrade.Text = CommodityGradeBLL.GetCommodityGradeNameById(objGRN.CommodityGradeId);
this.lblWarehouse.Text = WarehouseBLL.GetWarehouseNameById(objGRN.WarehouseId);
this.lblOriginalQuantity.Text = objGRN.OriginalQuantity.ToString();
this.lblNetWeight.Text = objGRN.NetWeight.ToString();
this.lblDateDeposited.Text = objGRN.DateDeposited.ToShortDateString();
this.lblTimeDeposited.Text = objGRN.DateDeposited.ToShortTimeString();
this.lblNoBags.Text = objGRN.TotalNumberOfBags.ToString();
//Bag Type
BagTypeBLL objBt = new BagTypeBLL();
objBt.GetBagTypeById(objGRN.BagTypeId);
lblBagType.Text = objBt.BagTypeName;
//Driver Information
List <DriverInformationBLL> list = null;
DriverInformationBLL objDI = new DriverInformationBLL();
list = objDI.GetActiveDriverInformationByReceivigRequestId(objGRN.CommodityRecivingId);
if (list != null)
{
string driverName = "";
string plateNo = "";
string driverLicense = "";
string licensceIssuedPlace = "";
foreach (DriverInformationBLL o in list)
{
if (driverName == "")
{
driverName = o.DriverName;
}
else
{
driverName += "," + o.DriverName;
}
if (plateNo == "")
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo = o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo = o.PlateNumber;
}
}
else
{
if (String.IsNullOrEmpty(o.TrailerPlateNumber) != true)
{
plateNo += " , " + o.PlateNumber + "-" + o.TrailerPlateNumber;
}
else
{
plateNo += " , " + o.PlateNumber;
}
}
if (driverLicense == "")
{
driverLicense = o.LicenseNumber;
}
else
{
driverLicense += " , " + o.LicenseNumber;
}
if (licensceIssuedPlace == "")
{
licensceIssuedPlace = o.LicenseIssuedPlace;
}
else
{
licensceIssuedPlace += " , " + o.LicenseIssuedPlace;
}
}
this.lblDriverName.Text = driverName;
this.lblPlateNo.Text = plateNo;
this.lblDriverLicense.Text = driverLicense;
this.lblPlaceIssued.Text = licensceIssuedPlace;
}
// Scaling
ScalingBLL objScaling = new ScalingBLL();
objScaling = objScaling.GetById(objGRN.ScalingId);
if (objScaling != null)
{
if (objScaling.WeigherId != null)
{
try
{
this.lblWeigherName.Text = UserRightBLL.GetUserNameByUserId(objScaling.WeigherId);
}
catch
{
}
}
}
// Sampler
SamplerBLL objSampler = new SamplerBLL();
objSampler = objSampler.GetActiveSamplingSupBySamplingId(objGRN.SamplingTicketId);
if (objSampler != null)
{
this.lblSampler.Text = UserRightBLL.GetUserNameByUserId(objSampler.SamplerId);
}
//Graders
GradingByBLL objGrader = new GradingByBLL();
this.lblGrader.Text = objGrader.GetSupGraderNameByGradingId(objGRN.GradingId);
if (objGRN.ApprovedBy != null)
{
try
{
this.lblApprovedBy.Text = UserRightBLL.GetUserNameByUserId(objGRN.ApprovedBy);
}
catch
{
}
}
if (objGRN.ApprovedTimeStamp != null)
{
this.lblDateAproved.Text = objGRN.ApprovedTimeStamp.ToShortDateString();
}
rpt = new rptGrading(GradingId);
rptGS = new rptGRNService(GRNId);
this.txtDateGenerated.Text = DateTime.Now.ToString();
ScalingBLL objSacling = new ScalingBLL();
objSacling = objSacling.GetById(objGRN.ScalingId);
if (objSacling != null)
{
this.lblScaleTicketNo.Text = objSacling.ScaleTicketNumber;
}
this.subReport1.Report = rpt;
this.subReport2.Report = this.rptGS;
}
//private CachedDictionary<ECXLookUp.CNIDType> nidTypeLookup = new CachedDictionary<ECXLookUp.CNIDType>(
// delegate(ECXLookUp.CNIDType nidType)
// {
// return nidType.Name;
// },
// delegate(object key)
// {
// return null;
// },
// delegate()
// {
// ECXLookUp.ECXLookup ecxLookup = new WarehouseApplication.ECXLookUp.ECXLookup();
// ECXLookUp.CNIDType[] nidTypes = ecxLookup.GetActiveNIDTypes(BLL.Utility.GetWorkinglanguage());
// List<KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>> kvps = new List<KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>>();
// foreach (ECXLookUp.CNIDType nidType in nidTypes)
// {
// kvps.Add(new KeyValuePair<object, WarehouseApplication.ECXLookUp.CNIDType>(nidType.Id, nidType));
// }
// return kvps;
// });
//private Dictionary<object, string> shedLookup = new Dictionary<object,string>();
//private Dictionary<object, string> stackLookup = new Dictionary<object,string>();
//private CachedDictionary<BagTypeBLL> bagTypeLookup = new CachedDictionary<BagTypeBLL>(
// delegate(BagTypeBLL bagType)
// {
// return bagType.BagTypeName;
// },
// delegate(object key)
// {
// return BagTypeBLL.GetBagType((Guid)key);
// },
// delegate()
// {
// List<KeyValuePair<object, BagTypeBLL>> kvps = new List<KeyValuePair<object, BagTypeBLL>>();
// foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes())
// {
// kvps.Add(new KeyValuePair<object, BagTypeBLL>(bagType.Id, bagType));
// }
// return kvps;
// });
//private WarehouseBLL currentWareHouse = new WarehouseBLL() {
// Code = "102",
// WarehouseId = new Guid("fa0a52e8-9308-4d5e-b323-88ca5ba232ed")
//};
#region ILookupSource Members
public IDictionary <object, string> GetLookup(string lookupName)
{
try
{
Dictionary <object, string> lookup = new Dictionary <object, string>();
switch (lookupName)
{
case "CommodityGrade":
return(new CachedDictionary <CommodityGradeBLL>(
delegate(CommodityGradeBLL commodityGrade)
{
return commodityGrade.GradeName;
},
delegate(object key)
{
return CommodityGradeBLL.GetCommodityGrade((Guid)key);
},
delegate()
{
List <KeyValuePair <object, CommodityGradeBLL> > kvps = new List <KeyValuePair <object, CommodityGradeBLL> >();
foreach (CommodityGradeBLL commodityGrade in CommodityGradeBLL.GetAllCommodityDetail())
{
kvps.Add(new KeyValuePair <object, CommodityGradeBLL>(commodityGrade.CommodityGradeId, commodityGrade));
}
return kvps;
}));
case "Client":
return(new CachedDictionary <ClientBLL>(
clientLookup,
delegate(ClientBLL client)
{
return client.ClientName;
},
delegate(object key)
{
return ClientBLL.GetClinet((Guid)key);
}));
case "ClientId":
return(new CachedDictionary <ClientBLL>(
clientLookup,
delegate(ClientBLL client)
{
return client.ClientId;
},
delegate(object key)
{
return ClientBLL.GetClinet((Guid)key);
}));
case "Warehouse":
return(new CachedDictionary <WarehouseBLL>(
warehouseLookup,
delegate(WarehouseBLL warehouse)
{
return warehouse.WarehouseName;
},
delegate(object key)
{
return WarehouseBLL.GetById((Guid)key);
}));
case "WarehouseManager":
return(new CachedDictionary <string>(
delegate(string warehouseManager)
{
return warehouseManager;
},
delegate(object key)
{
//return UserRightBLL.GetUsersWithRight("WHPWM").Find(u => u.UserId == (Guid)key).FullName;
return UserRightBLL.GetUserNameByUserId((Guid)key);
}));
case "NIDType":
//ICollection<object> keys = nidTypeLookup.Keys;
//return nidTypeLookup;
List <NIDTypeBLL> nidTypes = NIDTypeBLL.GetAllNIDTypes();
nidTypes.ForEach(nidType => lookup.Add(nidType.Id, nidType.Name));
break;
case "VerifyingClerk":
//return GetWorkersLookup("VerifyingClerk");
UserRightBLL.GetUsersWithRight("VerifyingClerk").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "InventoryController":
//return GetWorkersLookup("InventoryController");
UserRightBLL.GetUsersWithRight("InventoryController").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Loader":
//return GetWorkersLookup("Loader");
UserRightBLL.GetUsersWithRight("Loader").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Weigher":
//return GetWorkersLookup("Weigher");
UserRightBLL.GetUsersWithRight("Weigher").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Sampler":
//return GetWorkersLookup("Sampler");
UserRightBLL.GetUsersWithRight("Sampler").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Grader":
//return GetWorkersLookup("Grader");
UserRightBLL.GetUsersWithRight("Grader").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Gatekeeper":
//return GetWorkersLookup("Gatekeeper");
UserRightBLL.GetUsersWithRight("Gatekeeper").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "Inspector":
//return GetWorkersLookup("Gatekeeper");
UserRightBLL.GetUsersWithRight("WHPCT").ForEach(user => lookup.Add(user.UserId, user.FullName));
break;
case "BagType":
foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes())
{
lookup.Add(bagType.Id, bagType.BagTypeName);
}
break;
case "BagWeight":
foreach (BagTypeBLL bagType in BagTypeBLL.GetAllBagTypes())
{
lookup.Add(bagType.Id, bagType.Tare.ToString());
}
break;
case "CurrentWarehouse":
lookup.Add("Id", WarehouseBLL.CurrentWarehouse.WarehouseId.ToString());
lookup.Add("WarehouseCode", WarehouseBLL.CurrentWarehouse.Code);
//lookup.Add("WarehouseManagerId", currentWareHouse.WarehouseId.ToString());
//lookup.Add("WarehouseManagerName", "");
break;
case "CurrentUser":
lookup.Add("Id", UserBLL.GetCurrentUser().ToString());
lookup.Add("Name", UserBLL.GetName(UserBLL.GetCurrentUser()));
break;
case "WorkerStatus":
lookup.Add(0, "Status 1");
lookup.Add(1, "Status 2");
break;
case "EmployeeRole":
lookup.Add(WorkType.GINGrading, "0e604921-ee27-4406-97ce-846b47b1cd75");
lookup.Add(WorkType.GINLoading, "0e604921-ee27-4406-97ce-846c47b1cd75");
lookup.Add(WorkType.GINSampling, "0e604921-ee27-4406-97ce-84db47b1cd75");
lookup.Add(WorkType.GINScaling, "0e604921-ee27-4406-97ce-846e47b1cd75");
break;
case "Shed":
foreach (ShedBLL shed in new ShedBLL().GetActiveShedByWarehouseId(WarehouseBLL.CurrentWarehouse.WarehouseId))
{
lookup.Add(shed.Id, shed.ShedNumber);
}
break;
case "Stack":
foreach (Guid shedId in GetLookup("Shed").Keys)
{
foreach (StackBLL stack in new StackBLL().GetActiveStackbyShedId(shedId))
{
lookup.Add(stack.Id, stack.StackNumber);
}
}
break;
case "TruckType":
lookup.Add(Guid.Empty, "Not Registred");
TruckTypeBLL objTT = new TruckTypeBLL();
List <TruckTypeBLL> list = objTT.GetActiveTrucksTypes();
list.Sort(TruckTypeComp);
list.ForEach(tt => lookup.Add(tt.Id, tt.TruckTypeName));
break;
}
lookup.OrderBy(lkup => lkup.Value);
return(lookup);
}
catch (Exception ex)
{
throw new Exception(string.Format("Item not found for the {0} lookup.", lookupName), ex);
}
}