public MovingData StickerList(MovingReq Req)
{
MovingData SM = new MovingData();
try
{
if (Req.UserId == "" || Req.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
}
else
{
query = "Sp_MovingWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "GetMovingList");
dbcommand.Parameters.AddWithValue("@StickerId", Req.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", Req.UserId);
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)
{
List <MovingListData> StillageSticker = new List <MovingListData>();
foreach (DataRow row in dt.Rows)
{
MovingListData SS = new MovingListData();
SS.StickerID = row["StickerID"].ToString();
SS.StandardQty = Convert.ToDecimal(row["StandardQty"]);
SS.ItemId = row["ItemId"].ToString();
SS.Description = row["Description"].ToString();
SS.ItemStdQty = Convert.ToDecimal(row["ItemStdQty"]);
SS.AssignedLocation = row["AssignedLocation"].ToString();
SS.IsMovedFromProdLine = Convert.ToByte(row["IsMovedFromProdLine"]);
StillageSticker.Add(SS);
}
SM.Status = "Success";
SM.Message = "Data retrived successfully";
SM.StillageList = StillageSticker;
}
else
{
SM.Status = "Failure";
SM.Message = "No Stillage is assigned to this user.";
return(SM);
}
}
else
{
SM.Status = "Failure";
SM.Message = "This Stillage Does Not Exist";
return(SM);
}
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SM);
}
public ItemMovingResponse StillageMoving(MovingReq movingReq)
{
ItemMovingResponse res = new ItemMovingResponse();
try
{
if (movingReq.StickerNo == "" || movingReq.StickerNo == null)
{
res.Status = "Failure";
res.Message = "Enter StickerNo";
return(res);
}
if (movingReq.UserId == "" || movingReq.UserId == null)
{
res.Status = "Failure";
res.Message = "Invalid UserId";
return(res);
}
query = "Sp_MovingWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "GetMovingData");
dbcommand.Parameters.AddWithValue("@StickerId", movingReq.StickerNo);
dbcommand.Parameters.AddWithValue("@UserID", movingReq.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["value"].ToString() != "2")
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <AisleList> AisleList = new List <AisleList>();
foreach (DataRow row in ds.Tables[1].Rows)
{
AisleList A = new AisleList();
A.name = row["name"].ToString();
A.id = row["id"].ToString();
AisleList.Add(A);
}
res.AisleList = AisleList;
//List<BinList> BinList = new List<BinList>();
//foreach (DataRow row in ds.Tables[3].Rows)
//{
// BinList A = new BinList();
// A.name = row["name"].ToString();
// A.id = row["id"].ToString();
// BinList.Add(A);
//}
//res.BinList = BinList;
//List<RackList> RackList = new List<RackList>();
//foreach (DataRow row in ds.Tables[2].Rows)
//{
// RackList A = new RackList();
// A.name = row["name"].ToString();
// A.id = row["id"].ToString();
// RackList.Add(A);
//}
//res.RackList = RackList;
List <ZoneList> ZoneList = new List <ZoneList>();
foreach (DataRow row in ds.Tables[2].Rows)
{
ZoneList A = new ZoneList();
A.name = row["name"].ToString();
A.id = row["id"].ToString();
ZoneList.Add(A);
}
res.ZoneList = ZoneList;
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
res.AssignedAisleId = Convert.ToString(ds.Tables[3].Rows[0]["AssignedAisleId"]);
res.AssignedBinId = Convert.ToString(ds.Tables[3].Rows[0]["AssignedBinId"]);
res.AssignedRackId = Convert.ToString(ds.Tables[3].Rows[0]["AssignedRackId"]);
res.AssignedAisleName = Convert.ToString(ds.Tables[3].Rows[0]["AssignedAisleName"]);
res.AssignedBinName = Convert.ToString(ds.Tables[3].Rows[0]["AssignedBinName"]);
res.AssignedRackName = Convert.ToString(ds.Tables[3].Rows[0]["AssignedRackName"]);
res.AssignedZoneName = Convert.ToString(ds.Tables[3].Rows[0]["ZoneName"]);
res.AssignedZoneId = Convert.ToString(ds.Tables[3].Rows[0]["ZONEID"]);
}
else
{
res.AssignedAisleId = "";
res.AssignedBinId = "";
res.AssignedRackId = "";
}
res.WareHouseID = ds.Tables[0].Rows[0]["WareHouseID"].ToString();
res.StickerID = ds.Tables[0].Rows[0]["StickerID"].ToString();
res.StandardQty = Convert.ToDecimal(ds.Tables[0].Rows[0]["StandardQty"]);
res.ItemId = ds.Tables[0].Rows[0]["ItemId"].ToString();
res.Description = ds.Tables[0].Rows[0]["Description"].ToString();
res.ItemStdQty = Convert.ToDecimal(ds.Tables[0].Rows[0]["ItemStdQty"]);
res.AssignedLocation = ds.Tables[0].Rows[0]["AssignedLocation"].ToString();
res.IsMovedFromProdLine = Convert.ToByte(ds.Tables[0].Rows[0]["IsMovedFromProdLine"]);
res.StillageLocationName = Convert.ToString(ds.Tables[0].Rows[0]["StillageLocationName"]);
res.IsAssignTransfer = Convert.ToByte(ds.Tables[0].Rows[0]["IsAssignTransfer"]);
if (res.StillageLocationName == "Production Line")
{
res.LoadingAreaId = res.LoadingAreaId = Convert.ToString(ds.Tables[4].Rows[0]["ZONEID"]);
}
else
{
res.LoadingAreaId = "";
}
res.Status = "Success";
res.Message = "Data retrived successfully";
}
else
{
res.Status = "Failure";
res.Message = "Invalid Sticker Number.";
}
}
else
{
res.Status = "Failure";
res.Message = "This Stillage Does not Exist";
return(res);
}
}
else
{
res.Status = "Failure";
res.Message = "This stillage is assigned to another user";
}
}
catch (Exception ex)
{
res.Status = "Failure";
res.Message = ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(res);
}
