public HttpResponseMessage Get()
{
ReasonList ReasonList = new ReasonList();
try
{
var list = GInfraEntities.sp_ReasonsList().ToList();
if (list.Count > 0)
{
foreach (var k in list)
{
ReasonListResponse ReasonListResponse = new ReasonListResponse();
ReasonListResponse.id = k.id.ToString();
ReasonListResponse.Reasons = k.reasons.ToString();
ReasonList.Data.Add(ReasonListResponse);
}
ReasonList.Status = true;
ReasonList.Message = "Data Fetched Successfully";
return(Request.CreateResponse(HttpStatusCode.OK, ReasonList));
}
else
{
ReasonList.Status = false;
ReasonList.Message = "No Record Found";
return(Request.CreateResponse(HttpStatusCode.OK, ReasonList));
}
}
catch (Exception ex)
{
ReasonList.Status = false;
ReasonList.Message = "" + ex + "";
return(Request.CreateResponse(HttpStatusCode.InternalServerError, ReasonList));
}
}
public override bool IsValid(object o, ref ReasonList reasons, params object[] additionalArgs)
{
base.IsValid(o, ref reasons, additionalArgs);
if (!(o is string))
{
throw new ArgumentException("CERootPathValidationRule was called without using a string.");
}
ResetRequiredFolders();
m_sPathToCheck = o as string;
var pathValidationRule = new CEPathValidationRule(true, true);
pathValidationRule.IsValid(m_sPathToCheck, ref m_reasons);
// If the path itself is faulty we cannot check the contents
if (!m_reasons.ContainsError)
{
CheckFolders();
}
reasons = m_reasons;
return(!m_reasons.ContainsError);
}
private async void btnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Text == "Add")
{
if (IsValid())
{
ReasonList obj = new ReasonList();
obj.ListReason = txtReason.Text;
await reasonList.Create(obj);
frmSurveyQuestionnaire questionnaire = (frmSurveyQuestionnaire)Application.OpenForms["frmSurveyQuestionnaire"];
this.Close();
}
}
if (btnAdd.Text == "Update")
{
if (IsValidUpdate())
{
ReasonList obj = await reasonList.Get(frmSettings.ReasonID);
obj.ListReason = txtReason.Text;
await reasonList.Update(obj);
frmSettings setting = (frmSettings)Application.OpenForms["frmSettings"];
await setting.LoadReason();
this.Close();
}
}
}
private async void frmAddReason_Load(object sender, EventArgs e)
{
await CallLoad();
if (frmSettings.OnEdit == true)
{
this.Text = "Update Info";
btnAdd.Text = "Update";
ReasonList obj = await reasonList.Get(frmSettings.ReasonID);
txtReason.Text = obj.ListReason;
}
}
public virtual bool IsValid(object o, ref ReasonList reasons, params object[] additionalArgs)
{
if (o == null)
{
throw new ArgumentNullException("o");
}
if (reasons == null)
{
reasons = new ReasonList();
}
m_reasons = reasons;
return(true);
}
public ReasonRepositoryTests()
{
//arrange
_options = new DbContextOptionsBuilder <ReasonContext>()
.UseInMemoryDatabase(databaseName: "Reasons").Options;
// Insert seed data into the database using one instance of the context
using (var context = new ReasonContext(_options))
{
foreach (var item in ReasonList.ListOfReasons())
{
context.Reason.Add(item);
}
context.SaveChanges();
}
}
/// <summary>
/// Checks whether the given path is valid
/// </summary>
/// <param name="o">The path to check</param>
/// <param name="reasons">Filled with reason why it is not valid</param>
/// <param name="additionalArgs">Expects one parameter of type string which is the path to the CE root folder</param>
/// <returns></returns>
public override bool IsValid(object o, ref ReasonList reasons, params object[] additionalArgs)
{
base.IsValid(o, ref reasons, additionalArgs);
if (o is string == false)
{
throw new ArgumentException("o is not a string");
}
if (additionalArgs.Count() <= 0)
{
throw new ArgumentException("additionalArg does not contain the expected CE root path");
}
if (additionalArgs[0] is string == false)
{
throw new ArgumentException("additionalArgs element 0 is not a string");
}
m_sCERootPath = additionalArgs[0] as string;
m_sPathToCheck = o as string;
// Check root folder first
if (!m_rootPathValidationRule.IsValid(m_sCERootPath))
{
var r = new Reason()
{
HumanReadableExplanation = Properties.ValidationReasons.CEGameCannotCheckRootInvalid,
ReasonType = EReason.eR_CheckGameRootInvalid,
Severity = EReasonSeverity.eRS_error
};
r.HumanReadableSolutions.Add(Properties.ValidationReasons.SolCEGameCannotCheckRootInvalid);
m_reasons.Add(r);
}
else
{
CheckName();
}
reasons = m_reasons;
return(!m_reasons.ContainsError);
}
public override bool IsValid(object o, ref ReasonList reasons, params object[] additionalArgs)
{
base.IsValid(o, ref reasons, additionalArgs);
if (o is string == false)
{
throw new ArgumentException("o is not a project name");
}
m_sNameToCheck = o as string;
CheckIsEmpty();
CheckAlreadyExists();
reasons = m_reasons;
return(!m_reasons.ContainsError);
}
private void DisplayCEGameIssues(ReasonList reasons)
{
m_ceGameIssuesPopup = Utillities.CreateIssueToolTip(reasons);
m_ceGameIssuesPopup.PlacementTarget = ceGameIssuesImage;
if (reasons.Count == 0)
{
ceGameIssuesImage.Source = Utillities.CheckmarkBitmap;
}
else
{
if (reasons.ContainsError)
{
ceGameIssuesImage.Source = Utillities.ErrorBitmap;
}
else
{
ceGameIssuesImage.Source = Utillities.WarningBitmap;
}
}
}
private void DisplayProjectNameIssues(ReasonList list)
{
m_projectNameIssuesPopup = Utillities.CreateIssueToolTip(list);
m_projectNameIssuesPopup.PlacementTarget = projectNameIssuesImage;
if (list.Count == 0)
{
projectNameIssuesImage.Source = Utillities.CheckmarkBitmap;
}
else
{
if (list.ContainsError)
{
projectNameIssuesImage.Source = Utillities.ErrorBitmap;
}
else
{
projectNameIssuesImage.Source = Utillities.WarningBitmap;
}
}
}
private void DisplayTemplateIssues(ReasonList reasonList)
{
if (reasonList != null && reasonList.Count > 0)
{
if (reasonList.ContainsError)
{
gameTemplateIssuesImage.Source = Utillities.ErrorBitmap;
}
else
{
gameTemplateIssuesImage.Source = Utillities.WarningBitmap;
}
m_gameTemplateIssuesPopup = Utillities.CreateIssueToolTip(reasonList);
m_gameTemplateIssuesPopup.PlacementTarget = gameTemplateIssuesImage;
}
else
{
gameTemplateIssuesImage.Source = Utillities.CheckmarkBitmap;
m_gameTemplateIssuesPopup = null;
}
}
private void CheckSaveTemplateInstallation(bool bIsDefaultTemplate)
{
if (CEGame == null || CEGame == "")
{
var reasons = new ReasonList();
reasons.Add(new Reason()
{
HumanReadableExplanation = Properties.ValidationReasons.CEGameNameIsEmpty,
ReasonType = EReason.eR_CheckGameNameEmpty,
Severity = EReasonSeverity.eRS_error
});
DisplayTemplateIssues(reasons);
}
else if (!bIsDefaultTemplate)
{
var dir = new DirectoryInfo(CERoot + "\\" + CEGame);
if (dir.Exists)
{
var reasonList = new Analytics.ReasonList();
reasonList.Add(new Reason()
{
HumanReadableExplanation = Properties.ValidationReasons.TemplateMightOverride,
Severity = EReasonSeverity.eRS_warning,
ReasonType = EReason.eR_GameNotEmptyTemplateOverride
});
DisplayTemplateIssues(reasonList);
}
}
else
{
DisplayTemplateIssues(null);
}
}
public override bool IsValid(object o, ref ReasonList reasons, params object[] additionalArgs)
{
base.IsValid(o, ref reasons, additionalArgs);
if (!(o is string))
{
throw new ArgumentException("CEPathvValidationRule was called without using a string.");
}
m_sPathToCheck = o as string;
if (m_bShouldCheckIfExists)
{
DoPathExistenceCheck();
}
CheckSpaces();
CheckCharacters();
return(!m_reasons.ContainsError);
}
public LoadingPlanDetails LoadingPlanDetails(LoadingPlanReq LPR)
{
LoadingPlanDetails SS = new LoadingPlanDetails();
try
{
if (LPR.LPID == "0")
{
SS.Status = "Failure";
SS.Message = "Invalid ID";
}
if (LPR.UserId == "0")
{
SS.Status = "Failure";
SS.Message = "Invalid UserId";
}
query = "Sp_LadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "LoadingPlanDetails");
dbcommand.Parameters.AddWithValue("@TLPHID", LPR.LPID);
dbcommand.Parameters.AddWithValue("@UserId", LPR.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet dt = new DataSet();
da.Fill(dt);
if (dt != null && dt.Tables[0].Rows.Count > 0)
{
SS.TruckID = dt.Tables[0].Rows[0]["TruckID"].ToString();
SS.DriverName = dt.Tables[0].Rows[0]["DriverName"].ToString();
SS.GateNo = Convert.ToInt16(dt.Tables[0].Rows[0]["GateNo"]);
SS.LoadingPlanNo = dt.Tables[0].Rows[0]["LoadingPlanNo"].ToString();
SS.DriverID = dt.Tables[0].Rows[0]["DriverId"].ToString();
SS.TruckNo = dt.Tables[0].Rows[0]["TruckNo"].ToString();
List <LoadingPlanDetailsList> LoadingPlanList = new List <LoadingPlanDetailsList>();
foreach (DataRow row in dt.Tables[0].Rows)
{
LoadingPlanDetailsList A = new LoadingPlanDetailsList();
A.WorkOrderQty = Convert.ToDecimal(row["WorkOrderQty"]);
A.ItemName = row["ItemName"].ToString();
A.ItemId = row["ItemId"].ToString();
A.SiteName = row["SiteName"].ToString();
A.Aisle = row["Aisle"].ToString();
A.Rack = row["Rack"].ToString();
A.Bin = row["Bin"].ToString();
A.StillageQty = Convert.ToDecimal(row["StillageQty"]);
A.StillageStdQty = Convert.ToDecimal(row["StillageStdQty"]);
A.WareHouseID = Convert.ToInt64(row["WareHouseID"]);
A.StickerID = row["StickerID"].ToString();
A.PickingQty = Convert.ToDecimal(row["PickingQty"]);
A.Zone = row["Zone"].ToString();
LoadingPlanList.Add(A);
}
SS.LoadingPlanList1 = LoadingPlanList;
List <ReasonList> ReasonList = new List <ReasonList>();
foreach (DataRow row in dt.Tables[1].Rows)
{
ReasonList A = new ReasonList();
A.id = Convert.ToString(row["id"]);
A.name = row["name"].ToString();
ReasonList.Add(A);
}
SS.ReasonList = ReasonList;
SS.Status = "Success";
SS.Message = "Data retrived successfully";
}
else
{
SS.Status = "Failure";
SS.Message = "There is no more stillage in this loading plan.";
}
}
catch (Exception Ex)
{
SS.Status = "Failure";
SS.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SS);
}
private void SelectionChanged(string property)
{
switch (property)
{
case "SelectedTransactionNumber":
resetValidProperties();
if (selectedTransactionNumber == latestTransNo)
{
IsFirstLoad = true;
updateTransNo = true;
//clear the form
IndexTransactionType = 0;
DocumentNumber = "";
TransactionDate = DateTime.Now.ToString("MM/dd/yyyy");
IndexSourceWarehouse = 0;
IndexSourceLocation = 0;
IndexPriceCategory = 0;
IndexPriceType = 0;
IndexDestinationWarehouse = 0;
IndexDestinationLocation = 0;
IndexReason = 0;
Comment = "";
}
else
{
IsFirstLoad = false;
updateTransNo = false;
fillForm();
}
if (string.IsNullOrEmpty(selectedTransactionNumber))
{
validProperties[0] = "";
IsLineable = false;
}
else
{
validProperties[0] = null;
}
break;
case "SelectedTransactionType":
IsDestinationEnabled(SelectedTransactionType.Code);
ReasonList.Clear();
ReasonList = reason.FetchAll();
CmbReason.Clear();
CmbReason.Add(new ReasonsModel());
if (SelectedTransactionType != null)
{
if (!string.IsNullOrEmpty(SelectedTransactionType.Code))
{
foreach (var item in ReasonList)
{
if (item.TransactionType == SelectedTransactionType.Code)
{
CmbReason.Add(item);
}
}
}
}
if (string.IsNullOrEmpty(SelectedTransactionType.Code))
{
validProperties[1] = "";
IsLineable = false;
}
else
{
validProperties[1] = null;
}
break;
case "DocumentNumber":
if (string.IsNullOrEmpty(DocumentNumber))
{
validProperties[2] = "";
IsLineable = false;
}
else
{
validProperties[2] = null;
}
break;
case "TransactionDate":
if (string.IsNullOrEmpty(transactionDate))
{
validProperties[3] = "";
IsLineable = false;
}
else
{
validProperties[3] = null;
}
break;
case "SelectedSourceWarehouse":
if (SelectedSourceWarehouse != null)
{
if (string.IsNullOrEmpty(SelectedSourceWarehouse.Code))
{
validProperties[4] = "";
IsLineable = false;
}
else
{
validProperties[4] = null;
}
}
break;
case "SelectedSourceLocation":
if (SelectedSourceLocation != null)
{
if (string.IsNullOrEmpty(SelectedSourceLocation.Code))
{
validProperties[5] = "";
IsLineable = false;
}
else
{
validProperties[5] = null;
}
}
break;
case "SelectedPriceCategory":
if (string.IsNullOrEmpty(SelectedPriceCategory))
{
validProperties[6] = "";
IsLineable = false;
}
else
{
validProperties[6] = null;
}
break;
case "selectedPriceType":
if (string.IsNullOrEmpty(selectedPriceType))
{
validProperties[7] = "";
IsLineable = false;
}
else
{
validProperties[7] = null;
}
break;
case "SelectedDestinationWarehouse":
if (EnableDestination)
{
if (SelectedDestinationWarehouse != null)
{
if (string.IsNullOrEmpty(SelectedDestinationWarehouse.Code))
{
validProperties[8] = "";
IsLineable = false;
}
else
{
validProperties[8] = null;
}
}
}
break;
case "SelectedDestinationLocation":
if (EnableDestination)
{
if (SelectedDestinationLocation != null)
{
if (string.IsNullOrEmpty(SelectedDestinationLocation.Code))
{
validProperties[9] = "";
IsLineable = false;
}
else
{
validProperties[9] = null;
}
}
}
break;
case "SelectedReason":
if (SelectedReason != null)
{
if (string.IsNullOrEmpty(SelectedReason.ReasonCode))
{
validProperties[10] = "";
IsLineable = false;
}
else
{
validProperties[10] = null;
}
}
break;
}
isValid();
}
public ScanStillageResponse ScanLookUpStillage(StickerReq SR)
{
ScanStillageResponse SS = new ScanStillageResponse();
try
{
if (SR.StickerNo == "")
{
SS.Status = "Failure";
SS.Message = "Enter Sticker ID";
}
if (SR.UserId == 0)
{
SS.Status = "Failure";
SS.Message = "Invalid UserId";
}
query = "Sp_NewLoadingPlan";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "GetScanStillage");
dbcommand.Parameters.AddWithValue("@StickerId", SR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", SR.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet dt = new DataSet();
da.Fill(dt);
if (dt != null && dt.Tables[0].Rows.Count > 0)
{
if (dt.Tables[6].Rows[0]["result"].ToString() == "2")
{
SS.Status = "close";
SS.Message = "This loading plan is discarded";
}
else if (dt.Tables[6].Rows[0]["result"].ToString() == "3")
{
SS.Status = "close";
SS.Message = "This loading plan is finished";
}
else
{
SS.StickerID = dt.Tables[0].Rows[0]["StickerID"].ToString();
SS.StandardQty = Convert.ToDecimal(dt.Tables[0].Rows[0]["StandardQty"]);
SS.ItemId = dt.Tables[0].Rows[0]["ItemId"].ToString();
SS.Description = dt.Tables[0].Rows[0]["Description"].ToString();
SS.ItemStdQty = Convert.ToDecimal(dt.Tables[0].Rows[0]["ItemStdQty"]);
SS.Location = dt.Tables[0].Rows[0]["Location"].ToString();
SS.IsTransfered = Convert.ToByte(dt.Tables[0].Rows[0]["IsTransfered"]);
SS.WareHouseID = dt.Tables[3].Rows[0]["WareHouseID"].ToString();
SS.WareHouseName = dt.Tables[0].Rows[0]["WareHouseName"].ToString();
SS.TransferId = dt.Tables[0].Rows[0]["TransferId"].ToString();
SS.IsShiped = dt.Tables[0].Rows[0]["IsShiped"].ToString();
SS.isHold = Convert.ToByte(dt.Tables[0].Rows[0]["isHold"]);
SS.IsCounted = Convert.ToByte(dt.Tables[0].Rows[0]["IsCounted"]);
SS.ToBeTransferWHID = dt.Tables[0].Rows[0]["ToBeTransferWHID"].ToString();
SS.STRP = Convert.ToInt16(dt.Tables[0].Rows[0]["STRP"]);
SS.UOM = Convert.ToString(dt.Tables[0].Rows[0]["UOM"]);
if (DBNull.Value.Equals(dt.Tables[2].Rows[0]["Prodstatus"]))
{
SS.Prodstatus = 0;
SS.WoStatus = "N/A";
}
else
{
SS.Prodstatus = Convert.ToInt16(dt.Tables[2].Rows[0]["Prodstatus"]);
SS.WoStatus = dt.Tables[2].Rows[0]["WorkorderStatus"].ToString();
}
List <SiteList> SiteList = new List <SiteList>();
foreach (DataRow row in dt.Tables[1].Rows)
{
SiteList A = new SiteList();
A.id = row["id"].ToString();
A.name = row["name"].ToString();
SiteList.Add(A);
}
List <ReasonList> ReasonList = new List <ReasonList>();
foreach (DataRow row in dt.Tables[4].Rows)
{
ReasonList A = new ReasonList();
A.id = Convert.ToString(row["id"]);
A.name = row["name"].ToString();
ReasonList.Add(A);
}
SS.ReasonList = ReasonList;
if (dt.Tables[5].Rows.Count > 0)
{
SS.isLoaded = 1;
List <StillageLoadedResponse> StillageLoadedResponse = new List <StillageLoadedResponse>();
foreach (DataRow row in dt.Tables[5].Rows)
{
StillageLoadedResponse A = new StillageLoadedResponse();
A.PickingPlanNo = Convert.ToString(row["PickingPlanNo"]);
A.LoadedQty = Convert.ToDecimal(row["LoadQty"]);
StillageLoadedResponse.Add(A);
}
SS.LoadedPickingPlanList = StillageLoadedResponse;
}
else
{
SS.isLoaded = 0;
}
SS.SiteListData = SiteList;
SS.Status = "Success";
SS.Message = "Data retrived successfully";
}
}
else
{
SS.Status = "Failure";
SS.Message = "This stillage does not exist";
return(SS);
}
}
catch (Exception Ex)
{
SS.Status = "Failure";
SS.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SS);
}
public static Popup CreateIssueToolTip(ReasonList reasons)
{
var tip = new Popup();
tip.Opened += delegate
{
tip.MouseLeave += delegate
{
tip.IsOpen = false;
};
};
var scrollViewer = new ScrollViewer()
{
MaxWidth = 400, VerticalScrollBarVisibility = ScrollBarVisibility.Auto, HorizontalScrollBarVisibility = ScrollBarVisibility.Auto
};
tip.Child = scrollViewer;
var headerIconImage = new Image()
{
Width = ToolTipIconWidth, Height = ToolTipIconWidth
};
var listView = new ListView();
scrollViewer.Content = listView;
var headerWrapPanel = new WrapPanel();
var headerTextBlock = new TextBlock()
{
VerticalAlignment = System.Windows.VerticalAlignment.Center,
FontWeight = System.Windows.FontWeights.Bold
};
headerTextBlock.FontSize *= 1.2;
headerWrapPanel.Children.Add(headerIconImage);
headerWrapPanel.Children.Add(headerTextBlock);
var headerItem = new ListViewItem();
headerItem.Content = headerWrapPanel;
listView.Items.Add(headerItem);
if (reasons.Count == 0)
{
headerIconImage.Source = CheckmarkBitmap;
headerTextBlock.Text = Properties.ValidationReasons.CommonEverythingGood;
}
else
{
if (reasons.ContainsError)
{
headerIconImage.Source = ErrorBitmap;
}
else
{
headerIconImage.Source = WarningBitmap;
}
headerTextBlock.Text = Properties.ValidationReasons.CommonThereAreIssues;
foreach (var reason in reasons)
{
var reasonExpander = new Expander()
{
IsExpanded = false
};
var reasonStackPanel = new StackPanel()
{
Orientation = Orientation.Horizontal
};
var reasonImage = new Image()
{
Width = ToolTipIconWidth, Height = ToolTipIconWidth
};
if (reason.Severity == EReasonSeverity.eRS_error)
{
reasonImage.Source = ErrorBitmap;
}
else
{
reasonImage.Source = WarningBitmap;
}
var reasonTextBlock = new TextBlock
{
Text = reason.HumanReadableExplanation,
VerticalAlignment = System.Windows.VerticalAlignment.Center
};
reasonStackPanel.Children.Add(reasonImage);
reasonStackPanel.Children.Add(reasonTextBlock);
reasonExpander.Header = reasonStackPanel;
if (reason.HumanReadableSolutions.Count > 0)
{
var reasonSolutions = new ListView();
reasonExpander.Content = reasonSolutions;
foreach (var item in reason.HumanReadableSolutions)
{
var solStackPanel = new StackPanel()
{
Orientation = Orientation.Horizontal
};
var solImage = new Image()
{
Width = ToolTipIconWidth, Height = ToolTipIconWidth, Source = InfoBitmap
};
var solText = new TextBlock()
{
Text = item, VerticalAlignment = System.Windows.VerticalAlignment.Center
};
solStackPanel.Children.Add(solImage);
solStackPanel.Children.Add(solText);
var solListItem = new ListViewItem()
{
Content = solStackPanel, IsEnabled = false
};
reasonSolutions.Items.Add(solListItem);
}
}
var reasonListItem = new ListViewItem()
{
Content = reasonExpander
};
listView.Items.Add(reasonListItem);
}
}
return(tip);
}
public bool IsValid(object o, params object[] additionalArgs)
{
ReasonList list = null;
return(IsValid(o, ref list, additionalArgs));
}
public NewLoadingPlanDetails LoadingPlanDetails(NewLoadingPlanReq LPR)
{
NewLoadingPlanDetails SS = new NewLoadingPlanDetails();
try
{
if (LPR.LPID == "0")
{
SS.Status = "Failure";
SS.Message = "Invalid ID";
}
if (LPR.UserId == "0")
{
SS.Status = "Failure";
SS.Message = "Invalid UserId";
}
query = "Sp_NewLoadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "LoadingPlanDetails");
dbcommand.Parameters.AddWithValue("@TLPHID", LPR.LPID);
dbcommand.Parameters.AddWithValue("@UserId", LPR.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet dt = new DataSet();
da.Fill(dt);
if (dt != null && dt.Tables[0].Rows.Count > 0)
{
if (dt.Tables[2].Rows[0]["result"].ToString() == "2")
{
SS.Status = "close";
SS.Message = "This loading plan is discarded";
}
else if (dt.Tables[2].Rows[0]["result"].ToString() == "3")
{
SS.Status = "close";
SS.Message = "This loading plan is finished";
}
else
{
SS.TruckID = dt.Tables[0].Rows[0]["TruckID"].ToString();
SS.DriverName = dt.Tables[0].Rows[0]["DriverName"].ToString();
SS.GateNo = Convert.ToInt16(dt.Tables[0].Rows[0]["GateNo"]);
SS.LoadingPlanNo = dt.Tables[0].Rows[0]["LoadingPlanNo"].ToString();
SS.DriverID = dt.Tables[0].Rows[0]["DriverId"].ToString();
SS.TruckNo = dt.Tables[0].Rows[0]["TruckNo"].ToString();
List <NewLoadingPlanDetailsList> LoadingPlanList = new List <NewLoadingPlanDetailsList>();
foreach (DataRow row in dt.Tables[0].Rows)
{
NewLoadingPlanDetailsList A = new NewLoadingPlanDetailsList();
A.ItemName = row["ItemName"].ToString();
A.ItemId = row["ItemId"].ToString();
A.ToBeLoadedQty = Convert.ToDecimal(row["PickingQty"]);
A.DeliveryReminderQty = Convert.ToDecimal(row["PDSCWDELIVERYREMINDER"]);
A.LoadedQty = Convert.ToDecimal(row["LoadedQuantity"]);
A.PickingPlanNo = row["PlanningID"].ToString();
A.SalesOrder = row["SalesOrder"].ToString();
LoadingPlanList.Add(A);
}
SS.ItemList = LoadingPlanList;
List <ReasonList> ReasonList = new List <ReasonList>();
foreach (DataRow row in dt.Tables[1].Rows)
{
ReasonList A = new ReasonList();
A.id = Convert.ToString(row["id"]);
A.name = row["name"].ToString();
ReasonList.Add(A);
}
SS.ReasonList = ReasonList;
SS.Status = "Success";
SS.Message = "Data retrived successfully";
}
}
else
{
SS.Status = "Failure";
SS.Message = "There is no more stillage in this loading plan.";
}
}
catch (Exception Ex)
{
SS.Status = "Failure";
SS.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SS);
}
