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); }