Ejemplo n.º 1
0
 public void InformSellerOfContactRequest(SellerDetails det)
 {
     GetAdminEmailDetails();
     if (AdminEmailAdd != null || AdminEmailAdd != "")
     {
         CustomerSendEmail(det);
     }
 }
 public ActionResult Create(TABusinessLayer.SellerDetails collection)
 {
     if (ModelState.IsValid)
     {
         dbset.AddSellerDetailsToDB(collection);
         return(RedirectToAction("Index"));
     }
     return(View());
 }
        //
        // GET: /CatalogueMasterSeller/Edit/5

        public ActionResult Edit(int id)
        {
            TABusinessLayer.SellerDetails ctitem = dbset.SellerDetailss.Single(emp => emp.sellerId == id);
            if (ctitem == null)
            {
                return(HttpNotFound());
            }

            return(View(ctitem));
        }
        public ActionResult Edit(TABusinessLayer.SellerDetails collection)
        {
            if (ModelState.IsValid)
            {
                var num = collection.sellerId;
                dbset.SaveChangesSellerDetailsToDB(collection);
                return(RedirectToAction("Index"));
            }

            return(View(collection));
        }
Ejemplo n.º 5
0
        public void SaveChangesSellerDetailsToDB(SellerDetails collection)
        {
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand("spSaveChangesSellerDetails", con);
                cmd.CommandType = CommandType.StoredProcedure;

                SqlParameter paramsellerAddress = new SqlParameter();
                paramsellerAddress.ParameterName = "@sellerAddress";
                paramsellerAddress.Value         = collection.sellerAddress;
                cmd.Parameters.Add(paramsellerAddress);

                SqlParameter paramsellerExpiryDate = new SqlParameter();
                paramsellerExpiryDate.ParameterName = "@sellerExpiryDate";
                paramsellerExpiryDate.Value         = collection.sellerExpiryDate;
                cmd.Parameters.Add(paramsellerExpiryDate);

                SqlParameter paramsellerName = new SqlParameter();
                paramsellerName.ParameterName = "@sellerName";
                paramsellerName.Value         = collection.sellerName;
                cmd.Parameters.Add(paramsellerName);

                SqlParameter paramsellerPhone = new SqlParameter();
                paramsellerPhone.ParameterName = "@sellerPhone";
                paramsellerPhone.Value         = collection.sellerPhone;
                cmd.Parameters.Add(paramsellerPhone);

                SqlParameter paramsellerEmail = new SqlParameter();
                paramsellerEmail.ParameterName = "@sellerEmail";
                paramsellerEmail.Value         = collection.sellerEmail;
                cmd.Parameters.Add(paramsellerEmail);

                SqlParameter paramsellerId = new SqlParameter();
                paramsellerId.ParameterName = "@sellerId";
                paramsellerId.Value         = collection.sellerId;
                cmd.Parameters.Add(paramsellerId);

                SqlParameter paramsellerWebsite = new SqlParameter();
                paramsellerWebsite.ParameterName = "@sellerWebsite";
                paramsellerWebsite.Value         = collection.sellerWebsite;
                cmd.Parameters.Add(paramsellerWebsite);

                con.Open();
                cmd.ExecuteNonQuery();
            }
        }
Ejemplo n.º 6
0
        public void CheckExpiredRegistration()
        {
            GetAdminEmailDetails();
            // List<SellerDetails> cods = new List<SellerDetails>();

            if (AdminEmailAdd != null || AdminEmailAdd != "")
            {
                using (SqlConnection con = new SqlConnection(connectionString))
                {
                    SqlCommand cmd2 = new SqlCommand("spGetAboutToExpiredClients", con);
                    cmd2.CommandType = CommandType.StoredProcedure;

                    con.Open();
                    SqlDataReader rd2 = cmd2.ExecuteReader();

                    if (rd2.HasRows)
                    {
                        while (rd2.Read())
                        {
                            SellerDetails cod = new SellerDetails();
                            cod.sellerEmail      = (string)rd2["SellerEmail"].ToString();
                            cod.sellerName       = (string)rd2["sellerName"].ToString();
                            cod.daysLeftToExpire = rd2["daysLeftToExpire"].ToString();
                            cod.AcctBank         = AcctBank;
                            cod.AcctName         = AcctName;
                            cod.AcctNumber       = AcctNumber;
                            cod.AdminPhone       = AdminPhone;
                            cod.SubscriptionFee  = SubscriptionFee;
                            ExpiryWarningsToClient(cod);
                            //cods.Add(cod);
                        }
                    }
                    rd2.Dispose();
                }
                //Send emails
            }
        }
Ejemplo n.º 7
0
        public void AdvertExpiryWarningsToClient(SellerDetails model)
        {
            try
            {
                string Customertemplate =
                    @"<html>
<head>
<style>
table {
    width:100%;
}
table, th, td {
    border: 1px solid #e56e94;
    border-collapse: collapse;
}
th, td {
    padding: 5px;
    text-align: left;
}
table#t01 tr:nth-child(even) {
    background-color: #ffffff;
}
table#t01 tr:nth-child(odd) {
   background-color:#ffdfdd;
}
table#t01 th	{
    background-color: #810541;
    color: white;
}
</style>
</head>
<body>

<body >
<div style='position:absolute; height:50px; font-size:15px; font face = 'cursive';
width:600px; background-color:#FBBBB9; padding:30px;'> 

<font color='#F6358A'; face='fantasy'>TRENDAFRIK</font><font color='#F6358A'; face='ar hermann'> AFRICAN FASHION FABRIQS!</font>
        </div>
        <br />


<div style='background-color: #ece8d4;style='color:grey; font-size:15px;'
    font face='Helvetica, Arial, sans-serif'
width:600px; height:600px; padding:30px; margin-top:30px;'>

<p>Dear @Model.sellerName,<p>
<br />

            <p>Please Be informed that Your Advert Slot Subscribtion expires in @Model.daysLeftToExpire day(s)</p>
            
            <br />
            <p>Call our Contact Number on @Model.AdminPhone for Renewal Details OR 
 Pay  into the following Account
<br/>
        Account Name: @Model.AcctName <br/>
        Account Number: @Model.AcctNumber <br/>
        Bank : @Model.AcctBank <br/>
        Subscription Fee: @Model.SubscriptionFee</p>
    <p><b>Please Use Your Registerd Name with us as Depositor Name. For Online Transfers
 use Your registered Name as Remark or Reference</b>
</p>

            <p>Thank you for allowing us serve you...</p><br />
            <a href='www.trendafrik.com'><b>TrendAfrik</b></a>

</body>
</html>"

                ;
                string mailBody = RazorEngine.Razor.Parse(Customertemplate, model);
//send to client
                MailMessage mailMessage = new MailMessage(LogonEmailAdd, model.sellerEmail);//mailDefinition.CreateMailMessage(mailTo, ldReplacements, control); //(mailTo, ldReplacements,emailmessage,this );
                mailMessage.From       = new MailAddress(LogonEmailAdd, "TrendAfrik");
                mailMessage.IsBodyHtml = true;
                mailMessage.Subject    = "Your Advert Subscription will soon Expire...";
                mailMessage.Body       = mailBody;

                SmtpClient smtpClient = new SmtpClient("mail.trendafrik.com", 25);
                smtpClient.Credentials = new System.Net.NetworkCredential()
                {
                    UserName = LogonEmailAdd,
                    Password = LogonPwd
                };
                smtpClient.EnableSsl = false;
                smtpClient.Send(mailMessage);

                //send to admin
                mailMessage            = new MailMessage(LogonEmailAdd, AdminEmailAdd);//mailDefinition.CreateMailMessage(mailTo, ldReplacements, control); //(mailTo, ldReplacements,emailmessage,this );
                mailMessage.From       = new MailAddress(LogonEmailAdd, "TrendAfrik");
                mailMessage.IsBodyHtml = true;
                mailMessage.Subject    = "Customers Advert Subscription will soon Expire...";
                mailMessage.Body       = mailBody;

                smtpClient             = new SmtpClient("mail.trendafrik.com", 25);
                smtpClient.Credentials = new System.Net.NetworkCredential()
                {
                    UserName = LogonEmailAdd,
                    Password = LogonPwd
                };
                smtpClient.EnableSsl = false;
                smtpClient.Send(mailMessage);
            }
            catch (Exception ex)
            {
                ex.StackTrace.ToString();
                throw;
            }
        }
Ejemplo n.º 8
0
        public void CustomerSendEmail(SellerDetails model)
        {
            try
            {
                string Customertemplate =
                    @"<html>
<head>
<style>
table {
    width:100%;
}
table, th, td {
    border: 1px solid #e56e94;
    border-collapse: collapse;
}
th, td {
    padding: 5px;
    text-align: left;
}
table#t01 tr:nth-child(even) {
    background-color: #ffffff;
}
table#t01 tr:nth-child(odd) {
   background-color:#ffdfdd;
}
table#t01 th	{
    background-color: #810541;
    color: white;
}
</style>
</head>


<body >
<div style='position:absolute; height:50px; font-size:15px; font face = 'cursive';
width:600px; background-color:#FBBBB9; padding:30px;'> 

<font color='#F6358A'; face='fantasy'>TRENDAFRIK</font><font color='#F6358A'; face='ar hermann'> AFRICAN FASHION FABRIQS!</font>
        </div>
        <br />


<div style='background-color: #ece8d4;style='color:grey; font-size:15px;'
    font face='Helvetica, Arial, sans-serif'
width:600px; height:600px; padding:30px; margin-top:30px;'>

<p>Dear @Model.sellerName,<p>
<br />

            <p>Please Be informed that Your Contact Details have been passed onto a Viewer on the Website</p>
            <p> With the following details:<br />
                <p>Name: @Model.sellerName <br />
                  Phone: @Model.sellerPhone
                      </p>  
<br />

<p> Your Address was not given so Customers from ALL Locations call you First! </p>

            <p>Thank you for allowing us serve you...</p><br />
            <a href='www.trendafrik.com'><b>TrendAfrik</b></a>

</body>
</html>"

                ;
                //string mailBody = RazorEngine.Razor.Parse(Customertemplate, model);
                string mailBody = "<html> <head> <style> table {    width:100%;} table, th, td {    border: 1px solid #e56e94;     border-collapse: collapse;} th, td {    padding: 5px;     text-align: left;} table#t01 tr:nth-child(even) {    background-color: #ffffff; } table#t01 tr:nth-child(odd) {   background-color:#ffdfdd; } table#t01 th	{    background-color: #810541;     color: white; } </style> </head> <body > <div style='position:absolute; height:50px; font-size:15px; font face = 'cursive'; width:600px; background-color:#FBBBB9; padding:30px;'> <font color='#F6358A'; face='fantasy'>TRENDAFRIK</font><font color='#F6358A'; face='ar hermann'> BEAUTIFULLY AFRICAN!!</font> </div> <br /> <div style='background-color: #ece8d4;style='color:grey; font-size:15px;' font face='Helvetica, Arial, sans-serif' width:600px; height:600px; padding:30px; margin-top:30px;'> <p>Dear " + model.sellerName + ",<p> <br /> <p>Please Be informed that Your Contact Details have been passed onto a Viewer on the Website</p> <p> With the following details:<br /> <p>Name: " + model.sellerName + " <br /> Phone: " + model.sellerPhone + "  </p> <br />  <p> Your Address was not given so Customers from ALL Locations call you First! </p> <p>Thank you for allowing us serve you...</p><br /> <a href='www.trendafrik.com'><b>TrendAfrik</b></a> </body >";



                MailMessage mailMessage = new MailMessage(LogonEmailAdd, model.sellerEmail);//mailDefinition.CreateMailMessage(mailTo, ldReplacements, control); //(mailTo, ldReplacements,emailmessage,this );
                mailMessage.From       = new MailAddress(LogonEmailAdd, "TrendAfrik");
                mailMessage.IsBodyHtml = true;
                mailMessage.Subject    = "Your Online Picture Has Been Viewed";
                mailMessage.Body       = mailBody;

                SmtpClient smtpClient = new SmtpClient("mail.trendafrik.com", 25);
                smtpClient.Credentials = new System.Net.NetworkCredential()
                {
                    UserName = LogonEmailAdd,
                    Password = LogonPwd
                };
                smtpClient.EnableSsl = false;
                smtpClient.Send(mailMessage);
            }
            catch (Exception ex)
            {
                ex.StackTrace.ToString();
                throw;
            }
        }