public AllMasterData GetMasterData() { AllMasterData res = new AllMasterData(); try { query = "Sp_MasterDataWebApi"; dbcommand = new SqlCommand(query, conn); dbcommand.Connection.Open(); dbcommand.CommandType = CommandType.StoredProcedure; dbcommand.Parameters.AddWithValue("@QueryType", "GetMasterData"); SqlDataAdapter da = new SqlDataAdapter(dbcommand); DataSet dt = new DataSet(); da.Fill(dt); List <SiteList> SiteList = new List <SiteList>(); foreach (DataRow row in dt.Tables[7].Rows) { SiteList A = new SiteList(); A.id = row["id"].ToString(); A.name = row["name"].ToString(); SiteList.Add(A); } res.SiteListData = SiteList; List <Aisle> AisleList = new List <Aisle>(); foreach (DataRow row in dt.Tables[0].Rows) { Aisle A = new Aisle(); A.id = Convert.ToInt64(row["id"]); A.name = row["name"].ToString(); AisleList.Add(A); } List <Rack> RackList = new List <Rack>(); foreach (DataRow row in dt.Tables[1].Rows) { Rack R = new Rack(); R.id = Convert.ToInt64(row["id"]); R.name = row["name"].ToString(); RackList.Add(R); } List <Bin> BinList = new List <Bin>(); foreach (DataRow row in dt.Tables[2].Rows) { Bin A = new Bin(); A.id = Convert.ToInt64(row["id"]); A.name = row["name"].ToString(); BinList.Add(A); } List <Reason> ReasonList = new List <Reason>(); foreach (DataRow row in dt.Tables[3].Rows) { Reason A = new Reason(); A.id = Convert.ToInt64(row["id"]); A.name = row["name"].ToString(); ReasonList.Add(A); } List <FLTList> FLTList = new List <FLTList>(); foreach (DataRow row in dt.Tables[4].Rows) { FLTList A = new FLTList(); A.id = Convert.ToInt64(row["id"]); A.name = row["name"].ToString(); FLTList.Add(A); } List <WareHouseList> WareHouseList = new List <WareHouseList>(); foreach (DataRow row in dt.Tables[5].Rows) { WareHouseList A = new WareHouseList(); A.id = row["id"].ToString();; A.name = row["name"].ToString(); WareHouseList.Add(A); } res.AisleList = AisleList; res.RackList = RackList; res.BinList = BinList; res.ReasonList = ReasonList; res.FLTList = FLTList; res.WareHouseList = WareHouseList; res.Status = "Success"; res.Message = "Data retrived successfully"; } catch (Exception ex) { res.Status = "Failure"; res.Message = ex.Message; } finally { dbcommand.Connection.Close(); } return(res); }
public AssigningResponse AssignData(AssigningReq CMR) { AssigningResponse res = new AssigningResponse(); try { if (CMR == null) { res.Status = "Failure"; res.Message = "Object reference not set to an instance of an object."; } else if (CMR.StickerNo == "") { res.Status = "Failure"; res.Message = "Invalid Sticker No."; } else { query = "Sp_AssignWebApi"; dbcommand = new SqlCommand(query, conn); dbcommand.Connection.Open(); dbcommand.CommandType = CommandType.StoredProcedure; dbcommand.Parameters.AddWithValue("@QueryType", "GetAssignedData"); dbcommand.Parameters.AddWithValue("@StickerId", CMR.StickerNo); dbcommand.Parameters.AddWithValue("@UserId", CMR.UserId); dbcommand.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(dbcommand); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows[0]["value"].ToString() != "3") { res.StillageLocation = Convert.ToString(ds.Tables[0].Rows[0]["StillageLocation"]); if (ds != null && ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["value"].ToString() == "1") { res.Status = "Failure"; res.Message = "Don't have access to get the details"; } //else if (res.StillageLocation != "NPRO-000001") else { 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.WareHouseID = Convert.ToString(ds.Tables[0].Rows[0]["WareHouseID"]); res.IsAssignTransfer = Convert.ToByte(ds.Tables[0].Rows[0]["IsAssignTransfer"]); 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; List <FLTList> FLTList = new List <FLTList>(); foreach (DataRow row in ds.Tables[3].Rows) { FLTList A = new FLTList(); A.name = row["name"].ToString(); A.id = Convert.ToInt64(row["id"]); FLTList.Add(A); } res.FLTList = FLTList; res.Status = "Success"; res.Message = "Data retrived successfully"; } //else //{ // res.Status = "Operation Invalid"; // res.Message = "Stillage will only move to Loading Area."; //} } else { res.Status = "Failure"; res.Message = "Invalid Sticker Id"; } } else { res.Status = "Failure"; res.Message = "This stillage does not exist"; return(res); } } } catch (Exception Ex) { res.Status = "Failure"; res.Message = Ex.Message; } finally { dbcommand.Connection.Close(); } return(res); }