public static void UpdateCatmanTopsToSpar(int topsID)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set catmanstoreid=" + p.Value + " where topsid=" + topsID);
}
public static void SetDefaultCatmanStoreid_NULL(string topsid)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set defaultCatmanStoreid=" + p.Value + " where topsid=" + topsid);
}
public static void InsertTopsStorewithDefaultValues(string store, int regionID)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("insert into dimmarkettopsstore(RegionID,Store,CatmanStoreID,POS,BackOffice,Merged) values(" + regionID + ",'" + store + "'," + p.Value + ",'N/A','N/A',0)");
}
public static void RemoveRomByTopsID(int TopsID)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set Personalid=" + p.Value + " where topsid=" + TopsID);
}
public static void InsertBlankProduct(String Barcode, String Description, String Size)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("Insert into dimProdNPL(Barcode,Nationalid,Description,ManuID,BrandID,Uos,Unit,SizeDesc,CasePack,Sparid,Supplierid,merchid,Reg,RegionalID,Divisionid,Height,Width,Depth,Discontinued,newlinedate,CreationDate) " +
" values('" + Barcode + "','0','" + Description + "',0,0,0,' ','" + Size + "',0,0,0,0," + p.Value + ",0,0,0,0,0,0," + p.Value + ",'" + DateTime.Now.ToShortDateString() + "')");
}
public static void RemoveMediaGroupByTopsID(string Topsid)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set mediaGroupid=" + p.Value + " where topsid=" + Topsid);
}
public static void InsertRomPersonalIDInmanRom_Store_Allocation(int RomID, int TopsID)
{
DataTable DTcatmanstoreid = LookUp.LU_dimMarketTopsStore.GetCatmanStoreIDByTopsID(TopsID);
String catmanStoreid = DTcatmanstoreid.Rows[0][0].ToString();
DataTable DTPersonalIDvsStoreID = SqlFunctions.GetData("select personalid,storeid from manRom_Store_Allocation where Personalid=" + RomID.ToString() + " and storeid=" + catmanStoreid);
if (DTPersonalIDvsStoreID.Rows.Count == 0)
{
SqlFunctions.ExecuteNonReturnSQL("insert into manRom_Store_Allocation(Personalid,storeid) values(" + RomID + "," + catmanStoreid + ")");
}
}
public static void DeleteRom(int TopsID)
{
System.Data.SqlTypes.SqlInt32 x = System.Data.SqlTypes.SqlInt32.Null;
DbParameter p = new SqlParameter();
p.DbType = DbType.Int32;
p.Value = x;
DataTable DTCatmanstoreid = LookUp.LU_dimMarketTopsStore.GetCatmanStoreIDByTopsID(TopsID);
String CatmanStoreID = DTCatmanstoreid.Rows[0][0].ToString();
String Personalid = LookUp.LU_manRom_Store_Allocation.GetRomPersonalidByCatmanStoreID(CatmanStoreID);
SqlFunctions.ExecuteNonReturnSQL("Delete from manrom_store_allocation where storeid=" + CatmanStoreID + " and Personalid=" + Personalid);
}
public static Boolean Update_pos_backoffice_merged_ByTopsID(int topsid, string pos, string backOffice, int merged)
{
Boolean saveSuccess = true;
try
{
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set pos='" + pos + "', backOffice='" + backOffice + "', merged=" + merged + " where topsid=" + topsid);
}
catch (Exception ex1)
{
saveSuccess = false;
}
return(saveSuccess);
}
public static void InsertEmpolyeeInManEmployee(string Name, string Surname, string Alias_Username, string GenderID, string RegionID, string IDno, string Jobtitle, string LevelID, string EmploymentDate, string EvaluationDate, string CellPhone, string Alias_Username_12)
{
SqlFunctions.ExecuteNonReturnSQL("insert into manemployee(Name,surname,username,genderid,regionid,idno,jobtitleid,levelid,Employmentdate,evaluationdate,cellphone,alias,Discontinued) values('" + Name + "','" + Surname + "','" + Alias_Username + "'," + GenderID + "," + RegionID + ",'" + IDno + "'," + Jobtitle + "," + LevelID + ",'" + EmploymentDate + "','" + EvaluationDate + "','" + CellPhone + "','" + Alias_Username_12 + "',0)");
}
public static void UpdateEmployeeDetails(string pID, string p, string p_2, string p_3, string p_4, string p_5, string p_6, string p_7, string p_8, string p_9, string p_10, string p_11, string p_12)
{
SqlFunctions.ExecuteNonReturnSQL("update manemployee set name='" + p + "' , surname='" + p_2 + "' ,username='******' ,Genderid=" + p_4 + " ,Regionid=" + p_5 + " ,idno='" + p_6 + "' ,Jobtitleid=" + p_7 + " ,levelid=" + p_8 + " ,EmploymentDate='" + p_9 + "' ,EvaluationDate='" + p_10 + "' ,Cellphone='" + p_11 + "' ,alias='" + p_3 + "' ,Discontinued=" + p_12 + " where personalid=" + pID);
}
public static void InsertBuyertoCategoryMap(string Personalid, string merchid)
{
SqlFunctions.ExecuteNonReturnSQL("Insert into buyercategorymapping(Personalid,merchid) values(" + Personalid + "," + merchid + ")");
}
public static void DeleteBuyertoCATMapped(string Personalid, string Merchid)
{
SqlFunctions.ExecuteNonReturnSQL("delete from buyercategorymapping where Personalid=" + Personalid + " and merchid=" + Merchid);
}
public static void MapCatmanTopsToSpar(int CatmanID, int TopsID)
{
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set catmanstoreid=" + CatmanID + " where topsid=" + TopsID);
}
public static void UpdateCasePack(String ProductID, String RegionID, String CasePack)
{
SqlFunctions.ExecuteNonReturnSQL("update dimprodstatus set CasePack=" + CasePack + " where RegionID=" + RegionID + " and Productid=" + ProductID);
}
public static void InsertRomtoStoreMap(string Personalid, string StoreID)
{
SqlFunctions.ExecuteNonReturnSQL("Insert into manrom_store_allocation(Personalid,Storeid) values(" + Personalid + "," + StoreID + ")");
}
public static void InsertRomPersonalIDInDimmarkettopsstore(int RomID, int TopsID)
{
SqlFunctions.ExecuteNonReturnSQL("Update dimmarkettopsstore set Personalid=" + RomID.ToString() + " where topsID=" + TopsID.ToString());
}
public static void InsertNewProduct(String barcode, String Description, String Size, String warehouseCasePack, String RegionID_)
{
SqlFunctions.ExecuteNonReturnSQL("insert into dimProdPendingClassifications(Barcode,Description,Size,WarehouseCasePack) values(" + barcode + ",'" + Description + "','" + Size + "'," + warehouseCasePack + "," + RegionID_ + ")");
}
public static void InsertNewCasePack(String ProductID, String RegionID, String StatusID, String casePack)
{
SqlFunctions.ExecuteNonReturnSQL("insert into dimprodstatus(Productid,Regionid,Statusid,Status_Date,casePack) values(" + ProductID + "," + RegionID + "," + StatusID + "," + DateTime.Now.ToShortDateString() + "," + casePack + ")");
}
public static void DeleteSale(String financialYear, String financialMonth, String financialWeek, String RegionID, String SourceID)
{
SqlFunctions.ExecuteNonReturnSQL("delete from factSalesCurr_DC_Weekly where financialYear=" + financialYear + " and financialMonth=" + financialMonth + " and financialWeek=" + financialWeek + " and storeid in (Select StoreID from dimmarketstore where regionid=" + RegionID + " and sourceid=" + SourceID + ")");
}
public static void UpdateDefaultCatmanStoreid(string topsid, string catmanstoreid)
{
SqlFunctions.ExecuteNonReturnSQL("update dimmarkettopsstore set defaultcatmanstoreid=" + catmanstoreid + " where topsid=" + topsid);
}
public static void AddNextToGroceryStoreTrue_False(String nextToGroceryStore, String TopsID)
{
SqlFunctions.ExecuteNonReturnSQL("update dimMarketTopsStore set nexttogrocerystore=" + nextToGroceryStore.ToString() + " where TopsID=" + TopsID);
}
public static void InsertSpecialisttoCategoryMap(string Personalid, string merchid)
{
SqlFunctions.ExecuteNonReturnSQL("Insert into manSpecialistMerchMapping(Personalid,merchid) values(" + Personalid + "," + merchid + ")");
}
public static void UpdateRom_StoreMapping(string Personalid, string StoreID)
{
SqlFunctions.ExecuteNonReturnSQL("update manrom_store_allocation set personalid=" + Personalid + " where storeid=" + StoreID);
}
public static void DeleteEntireSparTopsStore(int topsID)
{
SqlFunctions.ExecuteNonReturnSQL("delete from dimmarkettopsstore where topsid=" + topsID);
}
public static void InsertMediaGroupIDInDimMarketTopsStore(int MediaGroupID, int TopsID)
{
SqlFunctions.ExecuteNonReturnSQL("Update dimmarkettopsstore set MediagroupID=" + MediaGroupID.ToString() + " where topsID=" + TopsID.ToString());
}
public static void InsertNewDcSale(String StoreID, String ID_Day, String ActualYear, String ActualMonth, String ActualWeek, String FinancialYear, String FinancialMonth, String FinancialWeek, String ProductID, String Units, String DCSales)
{
SqlFunctions.ExecuteNonReturnSQL("Insert into factSalesCurr_DC_Weekly(StoreID,ID_Day,actualYear,actualMonth,actualWeek,financialYear,financialMonth,financialWeek,productid,units,Dcsales) " +
" values(" + StoreID + "," + ID_Day + "," + ActualYear + "," + ActualMonth + "," + ActualWeek + "," + FinancialYear + "," + FinancialMonth + "," + FinancialWeek + "," + ProductID + "," + Units + "," + DCSales + ")");
}
public static void DeleteEmployeeByPersonalid(string p)
{
SqlFunctions.ExecuteNonReturnSQL("Delete from manemployee where personalid=" + p);
}
public static void UpdateCasePack(String barcode, String Description, String Size, String Warehousecasepack, String RegionID_Warehousecasepack)
{
SqlFunctions.ExecuteNonReturnSQL("Update dimProdPendingClassifications set Description='" + Description + "',size='" + Size + "', warehousecasepack=" + Warehousecasepack + ", RegionID_warehousecasepack=" + RegionID_Warehousecasepack + " where barcode=" + barcode);
}
public static void DeleteSpecialisttoCATMapped(string Personalid, string Merchid)
{
SqlFunctions.ExecuteNonReturnSQL("delete from manSpecialistMerchMapping where Personalid=" + Personalid + " and merchid=" + Merchid);
}
