public static String GetServerName_RedReport()
{
DataTable DT = SqlFunctions_RedReport.GetData("select serverproperty('MachineName') ");
String servername = DT.Rows[0][0].ToString();
return(servername);
}
public static void InsertDefaultStore(String StoreName, String RegionID)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions_RedReport.ExecuteNonReturnSQL("Insert into redmarketstore(catmanstoreid,store,regionid,formatid,creationdate,romid,categoryid,squaremetres,discontinued,merged,mergedstoreid) values(0,'" + StoreName + "'," + RegionID + ",3," + DateTime.Now.ToShortDateString() + ",83,14,0,0,0," + p.Value + ")");
}
public static String GetTotalDepartmentSales(String Storeid, String ID_Day)
{
String Value = "0";
DataTable DT = SqlFunctions_RedReport.GetData("select sum(sales) from reddepartmentsales where storeid=" + Storeid + " and id_day =" + ID_Day);
if (DT.Rows.Count != 0)
{
Value = DT.Rows[0][0].ToString();
}
return(Value);
}
public static String GetStoreName(String StoreID)
{
String Name = "";
DataTable DT = SqlFunctions_RedReport.GetData("select store from redmarketstore where storeid=" + StoreID);
if (DT.Rows.Count != 0)
{
return(DT.Rows[0][0].ToString());
}
return(Name);
}
public static String GetPurchasesSales(String Storeid, String ID_Day)
{
String Value = "0";
DataTable DT = SqlFunctions_RedReport.GetData("select salesactual from redpurchasessales where storeid=" + Storeid + " and id_day =" + ID_Day);
if (DT.Rows.Count != 0)
{
Value = DT.Rows[0][0].ToString();
}
return(Value);
}
public static void UpdateMerged(String StoreID, String Merged)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set merged=" + Merged + " where storeid=" + StoreID);
if (Merged == "0")
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set mergedstoreid=" + p.Value + " where storeid=" + StoreID);
}
}
public static DataTable GetRomFullName(String RegionID, String Discontinued)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select RomID,Firstname,surname from redmarketroms where regionid=" + RegionID + " and discontinued=" + Discontinued + " order by firstname");
DataTable DTConcatinated = new DataTable();
DTConcatinated.Columns.Add("RomID");
DTConcatinated.Columns.Add("FullName");
foreach (DataRow row in DT.Rows)
{
DTConcatinated.Rows.Add(row["RomID"].ToString(), row["firstname"].ToString() + " " + row["surname"].ToString());
}
return(DTConcatinated);
}
public static void UpdateMergedS(String StoreID, String MergedStoreID)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set mergedstoreid=" + MergedStoreID + " where storeid=" + StoreID);
}
public static DataTable GetStoreList(String regionid, String discontinued)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select * from redmarketStore where regionid=" + regionid.ToString() + " and discontinued=" + discontinued.ToString() + " order by Store");
return(DT);
}
public static DataTable GetcurrentDates()
{
DataTable DT = SqlFunctions_RedReport.GetData("select distinct(id_day) from reddepartmentsales order by id_day");
return(DT);
}
public static DataTable GetRomDetails(String Romid)
{
DataTable DT = SqlFunctions_RedReport.GetData("select * from vRoms where romid=" + Romid);
return(DT);
}
public static DataTable GetRegion()
{
DataTable DT = SqlFunctions_RedReport.GetData("Select * from redMarketRegions");
return(DT);
}
public static DataTable GetCategories()
{
DataTable DT = SqlFunctions_RedReport.GetData("select * from redmarketcategories");
return(DT);
}
public static DataTable GetDepartmentStoreTypes()
{
DataTable DT = SqlFunctions_RedReport.GetData("Select DepartmentStoreTypeID,DepartmentStoreType from redDepartmentStoreType");
return(DT);
}
public static DataTable GetDepartmentSalesOverView()
{
DataTable DT = SqlFunctions_RedReport.GetData("Select * from vDepartmentSalesOverView");
return(DT);
}
public static DataTable Get_AllStoreID()
{
DataTable DT = SqlFunctions_RedReport.GetData("Select StoreID from redmarketstore");
return(DT);
}
public static DataTable Get_StoreIDStore(String regionid)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select StoreID,Store from redmarketStore where regionid=" + regionid.ToString() + " order by Store");
return(DT);
}
public static DataTable Get_StoreIDStore(String regionid, String discontinued, String Formatid)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select StoreID,Store from redmarketStore where regionid=" + regionid.ToString() + " and discontinued=" + discontinued.ToString() + " and formatid=" + Formatid + " order by Store");
return(DT);
}
public static DataTable GetCategory(String CategoryID)
{
DataTable DT = SqlFunctions_RedReport.GetData("select category from redmarketcategories where categoryid=" + CategoryID);
return(DT);
}
public static DataTable GetSalesByStoreIDDate(String StoreID, String ID_Day)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select * from redpurchasesSales where storeid=" + StoreID + " and ID_DAY=" + ID_Day);
return(DT);
}
public static DataTable GetRegion(String RegionID)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select RegionID,Region from redMarketRegions where regionid=" + RegionID);
return(DT);
}
public static void UpdateDiscontinued(String StoreID, String discontinued)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set discontinued=" + discontinued + " where storeid=" + StoreID);
}
public static DataTable GetRomDetails(String RomID)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select firstname,surname,contactnumber,regionid,discontinued from redMarketroms where romid=" + RomID);
return(DT);
}
public static void UpdateStore(String StoreID, String store)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set store='" + store + "' where storeid=" + StoreID);
}
public static void InsertDepartmentSale(String StoreID, String ID_Day, String Departmentid, String value)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Insert into redDepartmentsales(StoreID,ID_Day,DepartmentID,Sales) values(" + StoreID + "," + ID_Day + "," + Departmentid + "," + value + ")");
}
public static DataTable GetRomID(String StoreID)
{
DataTable DT = SqlFunctions_RedReport.GetData("Select romid from redmarketstore where StoreID=" + StoreID);
return(DT);
}
public static DataTable GetDepartmentSalesByStoreidIddayDepartmentID(String Storeid, String ID_DAY, String Departmentid)
{
DataTable DT = SqlFunctions_RedReport.GetData("select * from reddepartmentsales where storeid=" + Storeid + " and ID_day=" + ID_DAY + " and departmentID=" + Departmentid);
return(DT);
}
public static void UpdateSquareMetres(String StoreID, String SquareMetres)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set SquareMetres=" + SquareMetres + " where storeid=" + StoreID);
}
public static void UpdateRomID(String StoreID, String RomID)
{
SqlFunctions_RedReport.ExecuteNonReturnSQL("Update redmarketstore set RomID=" + RomID + " where storeid=" + StoreID);
}
public static DataTable GetStoreList()
{
DataTable DT = SqlFunctions_RedReport.GetData("Select * from redmarketStore order by Store");
return(DT);
}
