private static MamutOrder GetDatesFromMamut(Iorderheader orderheader) { List <MamutOrder> list = new List <MamutOrder>(); SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStringMamut"].ConnectionString); SqlDataSource sqlDataSource = new SqlDataSource(); sqlDataSource.ConnectionString = sqlConnection.ConnectionString; sqlDataSource.SelectCommand = "SELECT [LINKID], [STATUSID] , [ORDERID], [CONTNAME], [ADRDELIV], [DATEDELIV], [DATEPROD], [REFYOUR], [LORDERPICKED] FROM [G_ORDER] WHERE LINKID = '" + orderheader.Linkid + "'"; sqlDataSource.DataBind(); IEnumerable iteratorObject = sqlDataSource.Select (DataSourceSelectArguments.Empty); try { list.AddRange(from DataRowView record in iteratorObject select new MamutOrder( Convert.ToInt32(record["LINKID"].ToString()), Convert.ToInt32(record["STATUSID"].ToString()), Convert.ToInt32(record["ORDERID"].ToString()), record["CONTNAME"].ToString(), record["ADRDELIV"].ToString(), record["DATEDELIV"].ToString(), record["DATEPROD"].ToString(), record["REFYOUR"].ToString(), Convert.ToBoolean(record["LORDERPICKED"].ToString()))); } catch { return(null); } return(list[0]); }
private static MamutOrder GetDatesFromMamut(Iorderheader orderheader) { List<MamutOrder> list = new List<MamutOrder>(); SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionStringMamut"].ConnectionString); SqlDataSource sqlDataSource = new SqlDataSource(); sqlDataSource.ConnectionString = sqlConnection.ConnectionString; sqlDataSource.SelectCommand = "SELECT [LINKID], [STATUSID] , [ORDERID], [CONTNAME], [ADRDELIV], [DATEDELIV], [DATEPROD], [REFYOUR], [LORDERPICKED] FROM [G_ORDER] WHERE LINKID = '" + orderheader.Linkid + "'"; sqlDataSource.DataBind(); IEnumerable iteratorObject = sqlDataSource.Select (DataSourceSelectArguments.Empty); try { list.AddRange(from DataRowView record in iteratorObject select new MamutOrder( Convert.ToInt32(record["LINKID"].ToString()), Convert.ToInt32(record["STATUSID"].ToString()), Convert.ToInt32(record["ORDERID"].ToString()), record["CONTNAME"].ToString(), record["ADRDELIV"].ToString(), record["DATEDELIV"].ToString(), record["DATEPROD"].ToString(), record["REFYOUR"].ToString(), Convert.ToBoolean(record["LORDERPICKED"].ToString()))); } catch { return null; } return list[0]; }