public static void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@itemId", insertNotificationObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@costVariantValuesIds", insertNotificationObj.VariantID));
parameter.Add(new KeyValuePair<string, object>("@itemSKU", insertNotificationObj.ItemSKU));
parameter.Add(new KeyValuePair<string, object>("@customer", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair<string, object>("@email", insertNotificationObj.Email));
SQLHandler sqlH = new SQLHandler();
sqlH.ExecuteNonQuery("usp_Aspx_InsertNotification", parameter);
}
public static void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSPU(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("itemId", insertNotificationObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("costVariantValuesIds", insertNotificationObj.VariantID));
parameter.Add(new KeyValuePair <string, object>("itemSKU", insertNotificationObj.ItemSKU));
parameter.Add(new KeyValuePair <string, object>("customer", aspxCommonObj.UserName));
parameter.Add(new KeyValuePair <string, object>("email", insertNotificationObj.Email));
OracleHandler sqlH = new OracleHandler();
sqlH.ExecuteNonQuery("usp_Aspx_InsertNotification", parameter);
}
public List<Notification> GetAllNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo getNotificationObj)
{
List<Notification> lstNotification = AspxOutStockNotifyController.GetAllNotification(aspxCommonObj, getNotificationObj);
return lstNotification;
}
public void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj)
{
AspxOutStockNotifyController.InsertNotification(aspxCommonObj, insertNotificationObj);
}
public static List <Notification> GetAllNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo getNotificationObj)
{
List <Notification> lstNotification = AspxOutStockNotifyProvider.GetAllNotification(aspxCommonObj, getNotificationObj);
return(lstNotification);
}
public static void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj)
{
AspxOutStockNotifyProvider.InsertNotification(aspxCommonObj, insertNotificationObj);
}
public static List <Notification> GetAllNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo getNotificationObj)
{
List <KeyValuePair <string, object> > parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair <string, object>("itemId", getNotificationObj.ItemID));
parameter.Add(new KeyValuePair <string, object>("costVariantValuesIds", getNotificationObj.VariantID));
parameter.Add(new KeyValuePair <string, object>("ItemSKU", getNotificationObj.ItemSKU));
parameter.Add(new KeyValuePair <string, object>("UserEmail", getNotificationObj.Email));
OracleHandler sqlH = new OracleHandler();
List <Notification> lstNotification = sqlH.ExecuteAsList <Notification>("usp_Aspx_GetAllNotification", parameter);
return(lstNotification);
}
public static List<Notification> GetAllNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo getNotificationObj)
{
List<KeyValuePair<string, object>> parameter = CommonParmBuilder.GetParamSP(aspxCommonObj);
parameter.Add(new KeyValuePair<string, object>("@itemId", getNotificationObj.ItemID));
parameter.Add(new KeyValuePair<string, object>("@costVariantValuesIds", getNotificationObj.VariantID));
parameter.Add(new KeyValuePair<string, object>("@ItemSKU", getNotificationObj.ItemSKU));
parameter.Add(new KeyValuePair<string, object>("@UserEmail", getNotificationObj.Email));
SQLHandler sqlH = new SQLHandler();
List<Notification> lstNotification= sqlH.ExecuteAsList<Notification>("usp_Aspx_GetAllNotification", parameter);
return lstNotification;
}
public static void InsertNotification(AspxCommonInfo aspxCommonObj, InsertNotificationInfo insertNotificationObj)
{
AspxOutStockNotifyProvider.InsertNotification(aspxCommonObj, insertNotificationObj);
}
