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); }