public CommodityDepositeRequestBLL GetCommodityDepositeDetailByTrackingNo(string TrackingNo)
{
CommodityDepositRequest objCommDepReq = new CommodityDepositRequest();
DataSet dsResult = new DataSet();
dsResult = objCommDepReq.getCommodityDepositRequestByTrackingNo(TrackingNo);
if (dsResult.Tables[0].Rows.Count > 0)
{
CommodityDepositeRequestBLL obj = new CommodityDepositeRequestBLL();
obj.Id = new Guid(dsResult.Tables[0].Rows[0]["Id"].ToString());
obj.ClientId = new Guid(dsResult.Tables[0].Rows[0]["ClientId"].ToString());
if (dsResult.Tables[0].Rows[0]["ProductionYear"] != DBNull.Value)
{
obj.ProductionYear = Convert.ToInt32(dsResult.Tables[0].Rows[0]["ProductionYear"].ToString());
}
obj.DateTimeRecived = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"].ToString());
obj.TrackingNo = dsResult.Tables[0].Rows[0]["TransactionId"].ToString();
obj.WarehouseId = new Guid(dsResult.Tables[0].Rows[0]["WarehouseId"].ToString());
obj.CommodityId = new Guid(dsResult.Tables[0].Rows[0]["CommodityId"].ToString());
return(obj);
}
else
{
return(null);
}
}
/// <summary>
/// Search Commodity deposite by TransqactionId
/// </summary>
/// <param name="trackingNo">The Transaction Id assiged and used by Traking no.</param>
/// <returns></returns>
public List <CommodityDepositeRequestBLL> SearchCommodityDeposite(string trackingNo, string VoucherNo, Nullable <Guid> Clientid, Nullable <Guid> CommodityId, Nullable <DateTime> from, Nullable <DateTime> to)
{
List <CommodityDepositeRequestBLL> list = new List <CommodityDepositeRequestBLL>();
list = CommodityDepositRequest.SearchCommodityDeposite(trackingNo, VoucherNo, Clientid, CommodityId, from, to);
if (list != null)
{
List <CommodityDepositeRequestBLL> listMerged = new List <CommodityDepositeRequestBLL>();
for (int x = 0; x < list.Count; x++)
{
list[x].ClientName = ClientBLL.GetClinetNameById(list[x].ClientId);
list[x].CommodityName = CommodityGradeBLL.GetCommodityById(list[x].CommodityId).Commodity;
}
return(list);
}
else
{
return(null);
}
}
/// <summary>
/// A Method to insert Commodity Deposite request.
/// </summary>
/// <param name="transactionId"></param>
/// <param name="clientId"></param>
/// <param name="commodityId"></param>
/// <param name="warehouseId"></param>
/// <param name="reprsentativeId"></param>
/// <param name="woredaId"></param>
/// <param name="productionYear"></param>
/// <param name="NumberOfBags"></param>
/// <param name="dateTimeRecived"></param>
/// <param name="weight"></param>
/// <param name="remark"></param>
/// <param name="status">Status of the CDR , 1- Apporved 0, Cancelled</param>
/// <param name="createdBy">The user who created the Record </param>
/// <returns>if Sucessfull returns True.</returns>
public Nullable <Guid> AddCommodityDepositRequest(Guid TransactionTypeId)
{
// validate
// 0-not saved
Nullable <Guid> Id = null;
SqlTransaction tran;
SqlConnection conn = Connection.getConnection();
tran = conn.BeginTransaction();
CommodityDepositRequest ObjCommDepositeRequest = new CommodityDepositRequest();
string TransactionNo = String.Empty;
int auditTrailStatus = -1;
try
{
TransactionNo = WFTransaction.GetTransaction(TransactionTypeId, tran);
if (string.IsNullOrEmpty(TransactionNo))
{
throw new Exception("Unbale to Get Tracking No for Transaction Type " + TransactionTypeId);
}
this.TransactionId = TransactionNo;
Id = ObjCommDepositeRequest.InsertCommodityDepositeRequest(this, tran);
this.Id = (Guid)Id;
if (Id != null)
{
AuditTrailBLL objAt = new AuditTrailBLL();
auditTrailStatus = objAt.saveAuditTrail(this, WFStepsName.AddArrival.ToString(), UserBLL.GetCurrentUser(), "Insert Arrival");
if (auditTrailStatus == -1)
{
if (TransactionNo != "")
{
WFTransaction.Remove(TransactionNo);
}
return(null);
}
else
{
HttpContext.Current.Session["TransactionNo"] = TransactionNo;
tran.Commit();
return(Id);
}
}
else
{
if (TransactionNo != "")
{
WFTransaction.Remove(TransactionNo);
}
tran.Rollback();
}
}
catch (Exception ex)
{
if (TransactionNo != "")
{
WFTransaction.Remove(TransactionNo);
}
tran.Rollback();
throw new Exception("TransactionNo -" + TransactionNo + "TransactionTypeId " + TransactionTypeId, ex);
}
finally
{
conn.Close();
tran.Dispose();
}
return(Id);
}
public bool EditCommodityDepositRequest(Guid ClientId, Guid commodityDepositRequestId, Guid commodityId, Guid representativeId,
int productionYear, Guid woreda, float weight, int numberofBags, DateTime dateTimeRecived, string remark,
int status, Guid lastModifiedBy, CommodityDepositeRequestBLL OldObject
)
{
int isSaved = 0;
#region Validations
//if (CommodityDepositRequestId == null)
//{
// throw new Exception("Invalid Commodity Deposit Request Id");
//}
//if (commodityId == null )
//{
// throw new Exception("Invalid Commodity Id");
//}
//if (representativeId == null)
//{
// throw new Exception("Invalid Representative Id");
//}
//if (woreda == null)
//{
// throw new Exception("Invalid Woreda");
//}
//if (dateTimeRecived == null)
//{
// throw new Exception("Invalid Date Time Recived");
//}
//if (remark == null || remark == "")
//{
// throw new Exception("Invalid Remark");
//}
//if (status == null || status == "")
//{
// throw new Exception("Invalid status");
//}
//if (lastModifiedBy == null )
//{
// throw new Exception("Invalid last Modified by");
//}
#endregion
// has GRN on Rdit mood
bool canBeEdited = false;
canBeEdited = CommodityDepositeRequestBLL.isGRNEditable(commodityDepositRequestId);
if (canBeEdited == false)
{
throw new GRNNotOnUpdateStatus("A GRN has already been created for this Deposit request, please request GRN the manger to edit this GRN.");
}
CommodityDepositeRequestBLL objEdit = new CommodityDepositeRequestBLL();
//NoClient
objEdit = objEdit.GetCommodityDepositeDetailById(commodityDepositRequestId);
string trNo = objEdit.TrackingNo;
objEdit.Id = commodityDepositRequestId;
objEdit.CommodityId = commodityId;
objEdit.RepresentativeId = representativeId;
objEdit.ProductionYear = productionYear;
objEdit.WoredaId = woreda;
objEdit.Weight = weight;
objEdit.NumberofBags = numberofBags;
objEdit.DateTimeRecived = dateTimeRecived;
objEdit.Remark = remark;
objEdit.Status = status;
objEdit.LastModifiedBy = lastModifiedBy;
objEdit.ClientId = ClientId;
bool returnstatus = false;
int atStatus = 0;
SqlTransaction tran;
SqlConnection conn = Connection.getConnection();
tran = conn.BeginTransaction();
try
{
isSaved = CommodityDepositRequest.UpdateCommodityDepositeRequest(objEdit, tran);
if (isSaved == 0)
{
returnstatus = false;
}
else
{
//NoClient
if (WFTransaction.GetMessage(trNo) == "UpdateClientNo")
{
if (objEdit.ClientId != Guid.Empty)
{
WFTransaction.UnlockTask(trNo);
WarehouseApplication.ECXWF.CMessage msg = WFTransaction.Request(trNo);
WFTransaction.WorkFlowManager(trNo, msg);
}
}
AuditTrailBLL objAT = new AuditTrailBLL();
atStatus = objAT.saveAuditTrail(OldObject, objEdit, WFStepsName.ArrivalUpdate.ToString(), UserBLL.GetCurrentUser(), "Update Arrival");
if (atStatus == 1)
{
returnstatus = true;
tran.Commit();
}
}
}
catch
{
tran.Rollback();
}
finally
{
tran.Dispose();
conn.Close();
}
return(returnstatus);
}
private void LoadData(Guid Id)
{
//get The Id from the qs
//Get the Commodity deposite Request form.
CommodityDepositeRequestBLL objEdit = new CommodityDepositeRequestBLL();
CommodityDepositRequest objCommDepReq = new CommodityDepositRequest();
DataSet dsResult = new DataSet();
objEdit.Id = Id;
dsResult = objCommDepReq.getCommodityDepositRequestById(Id);
Guid ClientGuid = new Guid(dsResult.Tables[0].Rows[0]["ClientId"].ToString());
objEdit.ClientId = ClientGuid;
this.hfClientId.Value = ClientGuid.ToString();
this.txtNumberOfBags.Text = dsResult.Tables[0].Rows[0]["NumberofBags"].ToString();
objEdit.NumberofBags = int.Parse((dsResult.Tables[0].Rows[0]["NumberofBags"].ToString()));
float weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString());
if (weight == 0)
{
this.txtWeight.Text = "";
}
else
{
this.txtWeight.Text = dsResult.Tables[0].Rows[0]["Weight"].ToString();
}
objEdit.Weight = float.Parse(dsResult.Tables[0].Rows[0]["Weight"].ToString());
this.txtRemark.Text = dsResult.Tables[0].Rows[0]["Remark"].ToString();
objEdit.Remark = this.txtRemark.Text;
this.dtDateTimeRecived.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToShortDateString();
this.txtTimeArrival.Text = Convert.ToDateTime(dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToLongTimeString();
objEdit.DateTimeRecived = Convert.ToDateTime((dsResult.Tables[0].Rows[0]["DateTimeRecived"]).ToString());
this.cboReprsentative.SelectedValue = dsResult.Tables[0].Rows[0]["RepresentativeId"].ToString();
objEdit.RepresentativeId = Guid.Empty;
if (dsResult.Tables[0].Rows[0]["WoredaId"] != DBNull.Value)
{
this.cboWoreda.SelectedValue = dsResult.Tables[0].Rows[0]["WoredaId"].ToString();
objEdit.WoredaId = new Guid(dsResult.Tables[0].Rows[0]["WoredaId"].ToString());
}
this.cboStatus.SelectedValue = dsResult.Tables[0].Rows[0]["Status"].ToString();
objEdit.Status = int.Parse(dsResult.Tables[0].Rows[0]["Status"].ToString());
//if (Convert.ToInt32((this.cboStatus.SelectedValue)) == 0 )
//{
// //this.btnEdit.Enabled = false;
//}
// Display the Client Id from this
// Id = dsResult.Tables[0].Rows[0]["ClientId"].ToString();
ECXLookUp.ECXLookup objLookUp = new WarehouseApplication.ECXLookUp.ECXLookup();
//Populate Drop down from server cboCommodity
this.cboCommodity.AppendDataBoundItems = true;
ECXLookUp.CCommodity[] objCommodity = objLookUp.GetActiveCommodities(WarehouseApplicationConfiguration.GetWorkingLanguage());
this.cboCommodity.DataSource = objCommodity;
this.cboCommodity.DataTextField = "Name";
this.cboCommodity.DataValueField = "UniqueIdentifier";
this.cboCommodity.DataBind();
this.cboCommodity.SelectedValue = dsResult.Tables[0].Rows[0]["CommodityId"].ToString();
objEdit.CommodityId = new Guid(dsResult.Tables[0].Rows[0]["CommodityId"].ToString());
//Populate Region
//ECXLookUp.CRegion[] objRegion = objLookUp.GetActiveRegions(WarehouseApplicationConfiguration.GetWorkingLanguage());
//this.cboRegion.DataSource = objRegion;
//this.cboRegion.DataTextField = "Name";
//this.cboRegion.DataValueField = "UniqueIdentifier";
//this.cboRegion.DataBind();
string SelectedWoreda = "";
SelectedWoreda = dsResult.Tables[0].Rows[0]["WoredaId"].ToString();
if (SelectedWoreda != "")
{
ECXLookUp.CWoreda objWoreda = objLookUp.GetWoreda(WarehouseApplicationConfiguration.GetWorkingLanguage(), new Guid(SelectedWoreda));
Guid SelectedZone = new Guid(objWoreda.ZoneUniqueIdentifier.ToString());
ECXLookUp.CZone objZoneSelected = objLookUp.GetZone(WarehouseApplicationConfiguration.GetWorkingLanguage(), SelectedZone);
Guid SelectedRegion = new Guid(objZoneSelected.RegionUniqueIdentifier.ToString());
this.cboRegion_CascadingDropDown.SelectedValue = SelectedRegion.ToString();
this.cboZone_CascadingDropDown.SelectedValue = SelectedZone.ToString();
this.cboWoreda_CascadingDropDown.SelectedValue = SelectedWoreda;
}
// Bind Clinet
ClientBLL objClient = new ClientBLL();
objClient = ClientBLL.GetClinet(ClientGuid);
if (objClient != null)
{
this.txtClient.Text = objClient.ClientName + " - " + objClient.ClientId;
this.txtClient.Enabled = false;
}
//Populate the Production Year
// set because we will not have Production year no latter than 2007
string strSelectedYear = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString();
int currYear = int.Parse(ConfigurationSettings.AppSettings["CurrentEthiopianYear"]);
this.cboProductionYear.Items.Add(new ListItem("Please Select Production Year.", ""));
this.cboProductionYear.AppendDataBoundItems = true;
if (strSelectedYear != "")
{
if (int.Parse(strSelectedYear) < currYear - 2)
{
this.cboProductionYear.Items.Add(new ListItem(strSelectedYear, strSelectedYear));
}
}
for (int i = currYear - 2; i <= currYear; i++)
{
this.cboProductionYear.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
this.cboProductionYear.SelectedValue = dsResult.Tables[0].Rows[0]["ProductionYear"].ToString();
if (dsResult.Tables[0].Rows[0]["ProductionYear"] != DBNull.Value)
{
objEdit.ProductionYear = int.Parse(dsResult.Tables[0].Rows[0]["ProductionYear"].ToString());
}
ViewState["CommDepOld"] = objEdit;
}
