public void AddEmailSubscriber(OiiONewsLetter EmailSubscribe)
{
try
{
DatabaseHelper.Insert <OiiONewsLetter>(EmailSubscribe);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
public void UpdateEmailSubscribe(OiiONewsLetter EmailSubscribe)
{
try
{
OiiOHaatDCDataContext msDC = DatabaseHelper.GetDataModelDataContext();
OiiONewsLetter Emailsubscribe = msDC.OiiONewsLetters.Single(d => d.UserEmail == EmailSubscribe.UserEmail);
DatabaseHelper.Update <OiiONewsLetter>(msDC, EmailSubscribe, Emailsubscribe);
msDC.Dispose();
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
//public OiiONewsLetter GetEmailSubscribrByEmail(string p)
//{
// throw new NotImplementedException();
//}
public OiiONewsLetter GetEmailSubscribrIDByEmail(string EmailSubscribr)
{
try
{
OiiOHaatDCDataContext dbContext = DatabaseHelper.GetDataModelDataContext();
OiiONewsLetter Emailsubscribr = new OiiONewsLetter();
Emailsubscribr = dbContext.OiiONewsLetters.Single(d => d.UserEmail == EmailSubscribr && d.IsSubscribe == true);
dbContext.Dispose();
return(Emailsubscribr);
}
catch (Exception ex) { throw new Exception(ex.Message, ex); }
}
private OiiONewsLetter CreateEmailSubscriber()
{
Session["EmailID"] = "1";
OiiONewsLetter EmailSubscriber = new OiiONewsLetter();
try
{
if (hdIsEdit.Value == "true")
{
EmailSubscriptionRT receiverTransfer = new EmailSubscriptionRT();
OiiONewsLetter emailSubscription = receiverTransfer.GetEmailSubscribrIDByEmail(txtEmailSubscription.Text);
Session[sessEmailSubscribe] = emailSubscription;
// OiiONewsLetter EmailSubscribe = (OiiONewsLetter)Session[sessEmailSubscribe];
EmailSubscriber.IID = emailSubscription.IID;
}
EmailSubscriber.UserEmail = txtEmailSubscription.Text.Trim();
EmailSubscriber.SubscribeDate = DateTime.Now;
if (EmailSubscriber.IID <= 0)
{
EmailSubscriber.CreatedBy = Convert.ToInt64(Session["EmailID"]);
EmailSubscriber.CreatedDate = GlobalRT.GetServerDateTime();
}
else
{
OiiONewsLetter EmailSubscribe = (OiiONewsLetter)Session[sessEmailSubscribe];
EmailSubscriber.CreatedBy = EmailSubscribe.CreatedBy;;
EmailSubscriber.CreatedDate = EmailSubscribe.CreatedDate;
EmailSubscriber.ModifiedBy = Convert.ToInt64(Session["EmailID"]);
EmailSubscriber.ModifiedDate = GlobalRT.GetServerDateTime();
}
if (hdIsDelete.Value != "true")
{
EmailSubscriber.IsSubscribe = true;
}
else
{
EmailSubscriber.IsSubscribe = false;
}
}
catch (Exception ex)
{
lblEmailSubscribe.Text = "Error : " + ex.Message;
lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
}
return(EmailSubscriber);
}
protected void btnSubscribeUnsubcbe_Click(object sender, EventArgs e)
{
//if (ChkEmailUnsubcribe.Checked == false)
//{
try
{
lblEmailSubscribe.Text = string.Empty;
using (EmailSubscriptionRT receiverTransfer = new EmailSubscriptionRT())
{
List <OiiONewsLetter> EmailSubscriberList = new List <OiiONewsLetter>();
EmailSubscriberList = receiverTransfer.GetEmailSubscriber(txtEmailSubscription.Text);
if (EmailSubscriberList != null && EmailSubscriberList.Count > 0)
{
string msg = "" + txtEmailSubscription.Text + " Already Subscribed!";
lblEmailSubscribe.Text = msg;
lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
lblEmailSubscribe.BackColor = System.Drawing.Color.Blue;
return;
}
OiiONewsLetter EmailSubscribe = CreateEmailSubscriber();
receiverTransfer.AddEmailSubscriber(EmailSubscribe);
if (EmailSubscribe.IID > 0)
{
lblEmailSubscribe.Text = "Data successfully saved...";
lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
lblEmailSubscribe.BackColor = System.Drawing.Color.Blue;
}
else
{
lblEmailSubscribe.Text = "Data not saved...";
lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
lblEmailSubscribe.BackColor = System.Drawing.Color.Blue;
}
}
ClearEmailField();
//LoadUserGrp();
}
catch (Exception ex)
{
lbLogStatus.Text = "Error : " + ex.Message;
lbLogStatus.ForeColor = System.Drawing.Color.Red;
}
//}
//else if(ChkEmailUnsubcribe.Checked==true && txtEmailSubscription.Text!=null)
//{
// try
// {
// lblEmailSubscribe.Text = string.Empty;
// using (EmailSubscriptionRT receiverTransfer = new EmailSubscriptionRT())
// {
// List<OiiONewsLetter> EmailSubscriberList = new List<OiiONewsLetter>();
// EmailSubscriberList = receiverTransfer.GetEmailSubscriber(txtEmailSubscription.Text);
// if (EmailSubscriberList != null && EmailSubscriberList.Count > 0)
// {
// hdIsDelete.Value = "true";
// hdIsEdit.Value = "true";
// OiiONewsLetter EmailSubscribe = CreateEmailSubscriber();
// if (EmailSubscribe != null)
// {
// receiverTransfer.UpdateEmailSubscribe(EmailSubscribe);
// lblEmailSubscribe.Text = "Data successfully deleted...";
// lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
// lblEmailSubscribe.BackColor = System.Drawing.Color.Blue;
// }
// else
// {
// lblEmailSubscribe.Text = "Data not deleted...";
// lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
// }
// }
// else
// {
// lblEmailSubscribe.Text = "You Should Subscribe First";
// lblEmailSubscribe.ForeColor = System.Drawing.Color.YellowGreen;
// }
// }
// ClearEmailField();
// }
// catch (Exception ex)
// {
// lblEmailSubscribe.Text = "Error : " + ex.Message;
// lblEmailSubscribe.ForeColor = System.Drawing.Color.White;
// }
//}
//else
//{
// lblEmailSubscribe.Text = "Can Not Subscribe Or Unsubscribe";
//}
}