public string CustomerImport(int store_id, int LoggedInUserId, int customer_group_id, DataTable CustomerTable, string UserPassword) { string CustomerXml = GeneralMethods.ConvertDatatableToXML(CustomerTable); try { SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("store_id", store_id); param[1] = new SqlParameter("LoggedInUserId", LoggedInUserId); param[2] = new SqlParameter("customer_group_id", customer_group_id); param[3] = new SqlParameter("CustomerXml", CustomerXml); //var result = CustomerEntityGenericRepository.ExecuteSQL<string>("EXEC ImportCustomerXml", param).FirstOrDefault(); var listPasswordOfCustomer = CustomerEntityGenericRepository.ExecuteSQL <ImportCustomerEmailEntity>("EXEC ImportCustomerXml", param).ToList(); //if (listPasswordOfCustomer != null && listPasswordOfCustomer.Count > 0) if (string.IsNullOrWhiteSpace(listPasswordOfCustomer.FirstOrDefault().ErrorLog)) { SendCustomerImportMailToCustomer(listPasswordOfCustomer, store_id, UserPassword); } var result = string.IsNullOrWhiteSpace(listPasswordOfCustomer.FirstOrDefault().ErrorLog) ? string.Empty : listPasswordOfCustomer.FirstOrDefault().ErrorLog; return(result); } catch (Exception) { throw; } }
public List <PointsAuditEntity> PointsImporter(int store_id, int LoggedInUserId, bool IsSendEmail, DataTable PointsTable) { string PointsXml = GeneralMethods.ConvertDatatableToXML(PointsTable); try { SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("store_id", store_id); param[1] = new SqlParameter("IsSendEmail", IsSendEmail); param[2] = new SqlParameter("PointsXml", PointsXml); List <PointsAuditEntity> result = CustomerEntityGenericRepository.ExecuteSQL <PointsAuditEntity>("EXEC ImportPointsXml", param).ToList(); //if (IsSendEmail && string.IsNullOrWhiteSpace(result.FirstOrDefault().invalidEmail)) if (IsSendEmail) { SendPointImportMailToCustomer(PointsXml, store_id); } return(result); } catch (Exception) { throw; } }