public LoadingPlan ScanLookUpStillage(StickerReq SR)
{
LoadingPlan SS = new LoadingPlan();
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_LadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "GetLoadingPlan");
dbcommand.Parameters.AddWithValue("@StickerId", SR.StickerNo);
dbcommand.Parameters.AddWithValue("@AssignedUser", 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)
{
List <ScanLoadingPlan> LoadingPlanList = new List <ScanLoadingPlan>();
foreach (DataRow row in dt.Tables[0].Rows)
{
ScanLoadingPlan A = new ScanLoadingPlan();
A.TLPHID = Convert.ToInt64(row["TLPHID"]);
A.LoadingPlanNo = row["LoadingPlanNo"].ToString();
A.CustomerId = row["CustomerId"].ToString();
LoadingPlanList.Add(A);
}
SS.ScanLoadingPlanList = LoadingPlanList;
SS.Status = "Success";
SS.Message = "Data retrived successfully";
}
else
{
SS.Status = "Failure";
SS.Message = "Invalid Stillage";
}
}
catch (Exception Ex)
{
SS.Status = "Failure";
SS.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SS);
}
public ScanMergeResponse ScanMergeStillage(StickerReq SR)
{
ScanMergeResponse SS = new ScanMergeResponse();
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_MergeStillage";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "ScanMergeStillage");
dbcommand.Parameters.AddWithValue("@StickerId", SR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", SR.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() != "2")
{
if (dt != null && dt.Rows.Count > 0)
{
SS.StickerID = dt.Rows[0]["StickerID"].ToString();
SS.StandardQty = Convert.ToDecimal(dt.Rows[0]["StandardQty"]);
SS.ItemId = dt.Rows[0]["ItemId"].ToString();
SS.Description = dt.Rows[0]["Description"].ToString();
SS.ItemStdQty = Convert.ToDecimal(dt.Rows[0]["ItemStdQty"]);
SS.WareHouseName = dt.Rows[0]["WareHouseName"].ToString();
SS.IsCounted = Convert.ToByte(dt.Rows[0]["IsCounted"]);
SS.WareHouseID = dt.Rows[0]["WareHouseID"].ToString();
SS.SiteID = dt.Rows[0]["SiteID"].ToString();
SS.IsAssignTransfer = Convert.ToByte(dt.Rows[0]["IsAssignTransfer"]);
SS.Status = "Success";
SS.Message = "Data retrived successfully";
}
else
{
SS.Status = "Failure";
SS.Message = "Stillage Id Invalid";
return(SS);
}
}
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 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 StillageStickerHold RejectedStillageDetail(StickerReq SR)
{
StillageStickerHold SM = new StillageStickerHold();
try
{
if (SR.StickerNo == "")
{
SM.Status = "Failure";
SM.Message = "Enter Sticker ID";
}
if (SR.UserId == 0)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
}
query = "Sp_RejectStillageWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "GetRejectedStillageDetails");
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)
{
StillageSticker SS = new StillageSticker();
SM.StickerID = dt.Tables[0].Rows[0]["StickerID"].ToString();
SM.StandardQty = Convert.ToDecimal(dt.Tables[0].Rows[0]["StandardQty"]);
SM.ItemId = dt.Tables[0].Rows[0]["ItemId"].ToString();
SM.WorkOrderNo = dt.Tables[0].Rows[0]["WorkOrderNo"].ToString();
SM.Description = dt.Tables[0].Rows[0]["Description"].ToString();
SM.ItemStdQty = Convert.ToDecimal(dt.Tables[0].Rows[0]["ItemStdQty"]);
SM.isHold = Convert.ToByte(dt.Tables[0].Rows[0]["isHold"]);
SM.IsCounted = Convert.ToByte(dt.Tables[0].Rows[0]["IsCounted"]);
SM.WareHouseID = Convert.ToString(dt.Tables[0].Rows[0]["WareHouseID"]);
SM.IsAssignTransfer = Convert.ToByte(dt.Tables[0].Rows[0]["IsAssignTransfer"]);
SM.WoStatus = Convert.ToString(dt.Tables[1].Rows[0]["WorkorderStatus"]);
SM.Prodstatus = Convert.ToInt16(dt.Tables[1].Rows[0]["Prodstatus"]);
SM.UOM = Convert.ToDecimal(dt.Tables[0].Rows[0]["UOM"]);
SM.Status = "Success";
SM.Message = "Data retrived successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "This stillage does not exist";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SM);
}
