public GetAssignTransferDataRes GetAssignTransferDetails(GetAssignTransferDataReq GATDReq)
{
GetAssignTransferDataRes GATDRes = new GetAssignTransferDataRes();
try
{
if (GATDReq.UserId == 0)
{
GATDRes.Status = "Failure";
GATDRes.Message = "Invalid UserId";
return(GATDRes);
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetAssignTransferDetails");
dbcommand.Parameters.AddWithValue("@UserId", GATDReq.UserId);
dbcommand.Parameters.AddWithValue("@TATHID1", GATDReq.TATHID);
dbcommand.Parameters.AddWithValue("@ActivityId", GATDReq.ActivityId);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
if (Convert.ToString(dsGetData.Tables[0].Rows[0]["value"]) == "0")
{
List <StillageList> StillageList = new List <StillageList>();
foreach (DataRow row in dsGetData.Tables[0].Rows)
{
StillageList A = new StillageList();
A.StillageID = row["StickerId"].ToString();
A.StillageQty = row["StillageQty"].ToString();
A.ItemID = row["ItemID"].ToString();
A.ItemDesc = row["ItemDesc"].ToString();
StillageList.Add(A);
}
GATDRes.StillageList = StillageList;
GATDRes.Status = "Success";
GATDRes.Message = "Data Send successfully";
}
else
{
GATDRes.Status = "Failure";
GATDRes.Message = "Stillages not found";
}
}
catch (Exception Ex)
{
GATDRes.Status = "Failure";
GATDRes.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(GATDRes);
}
public GetAssignTransferDataRes GetAssignTransferHeader(GetAssignTransferDataReq GATDReq)
{
GetAssignTransferDataRes GATDRes = new GetAssignTransferDataRes();
try
{
if (GATDReq.UserId == 0)
{
GATDRes.Status = "Failure";
GATDRes.Message = "Invalid UserId";
return(GATDRes);
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetAssignTransferData");
dbcommand.Parameters.AddWithValue("@UserId", GATDReq.UserId);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
if (Convert.ToString(dsGetData.Tables[0].Rows[0]["value"]) == "0")
{
List <TransferList> TransferList = new List <TransferList>();
foreach (DataRow row in dsGetData.Tables[0].Rows)
{
TransferList A = new TransferList();
A.ActivityId = row["ActivityId"].ToString();
A.IsTj = Convert.ToInt16(row["IsTj"]);
A.NoOfStillages = row["NoOfStillage"].ToString();
A.SiteId = row["SiteId"].ToString();
A.WareHouseId = row["WareHouseId"].ToString();
A.FromWareHouseId = row["FromWareHouseId"].ToString();
A.TATHID = row["TATHID"].ToString();
TransferList.Add(A);
}
GATDRes.TransferList = TransferList;
GATDRes.Status = "Success";
GATDRes.Message = "Data Send successfully";
}
else
{
GATDRes.Status = "Failure";
GATDRes.Message = "No assignments found";
}
}
catch (Exception Ex)
{
GATDRes.Status = "Failure";
GATDRes.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(GATDRes);
}