void btnSaveUpdate_Click(object sender, EventArgs e) { string result = string.Empty; TG.ExpressCMS.DataLayer.Entities.Contact _contact = new TG.ExpressCMS.DataLayer.Entities.Contact(); _contact = ContactManager.GetByEmail(txtEmail.Text); if (null != _contact) { dvMessage.InnerText = Resources.ExpressCMS.YouEmailAlreadyregistered; return; } _contact = new DataLayer.Entities.Contact(); _contact.Country = HttpUtility.HtmlEncode(txtCountry.Text); _contact.Email = HttpUtility.HtmlEncode(txtEmail.Text); _contact.Notes = HttpUtility.HtmlEncode(txtDescription.Text); _contact.FirstName = HttpUtility.HtmlEncode(txtName.Text); _contact.SurName = HttpUtility.HtmlEncode(txtSurname.Text); _contact.Phone2 = ""; _contact.ZipCode = ""; _contact.Company = ""; _contact.Guid = Guid.NewGuid().ToString(); _contact.Mobile = HttpUtility.HtmlEncode(txtPhone.Text); _contact.IsDeleted = false; _contact.Status = TG.ExpressCMS.DataLayer.Enums.RootEnums.ContactStatus.InActive; ContactManager.Add(_contact); ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), Guid.NewGuid().ToString().Substring(0, 4), "alert('" + Resources.ExpressCMS.YouHadbeenRegisteredSuccessfully + "');", true); ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString().Substring(0, 4), "alert('" + Resources.ExpressCMS.YouHadbeenRegisteredSuccessfully + "');", true); if (_contact.ID > 0) { ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), "SSSd", "alert('" + Resources.ExpressCMS.ResourceManager.GetString("NewsLetterSuccessSubscribtion") + "');", true); EmailSender.EmailSenderSoapClient emailSender = new EmailSender.EmailSenderSoapClient(); // EmailSender emailSender = new EmailSender(); emailSender.AddemailtoQueueNow(_contact.ID, _contact.Email, _contact.FullName, EmailContext.GetConfirmationText(_contact.FirstName, _contact.Email), "NoTImeFORLove"); emailSender.ProcessAllPendingEmail("NoTImeFORLove"); dvMessage.InnerText = Resources.ExpressCMS.YouHadbeenRegisteredSuccessfully; ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), Guid.NewGuid().ToString().Substring(0, 4), "alert('" + Resources.ExpressCMS.YouHadbeenRegisteredSuccessfully + "');", true); } else { ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), "SSSd1", "alert('" + Resources.ExpressCMS.ResourceManager.GetString("NewsLetterFailedSubscribtion") + "');", true); } AddMode(); dvMessage.InnerText = Resources.ExpressCMS.ResourceManager.GetString("NewsLetterSuccessSubscribtion"); }
public void PopulateContact(SqlDataReader _dtr, Contact obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_FIRSTNAME); if (!_dtr.IsDBNull(columnIndex)) { obj.FirstName = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_SURNAME); if (!_dtr.IsDBNull(columnIndex)) { obj.SurName = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_EMAIL); if (!_dtr.IsDBNull(columnIndex)) { obj.Email = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_MOBILE); if (!_dtr.IsDBNull(columnIndex)) { obj.Mobile = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_PHONE2); if (!_dtr.IsDBNull(columnIndex)) { obj.Phone2 = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_ZIPCODE); if (!_dtr.IsDBNull(columnIndex)) { obj.ZipCode = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_GUID); if (!_dtr.IsDBNull(columnIndex)) { obj.Guid = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_STATUS); if (!_dtr.IsDBNull(columnIndex)) { obj.Status = (TG.ExpressCMS.DataLayer.Enums.RootEnums.ContactStatus)_dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_COUNTRY); if (!_dtr.IsDBNull(columnIndex)) { obj.Country = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_COMPANY); if (!_dtr.IsDBNull(columnIndex)) { obj.Company = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(ContactDataMapper.CN_NOTES); if (!_dtr.IsDBNull(columnIndex)) { obj.Notes = _dtr.GetString((columnIndex)); } }
public IList<Contact> GetByGroupID(int groupID) { Contact obj = null; IList<Contact> colobj = new List<Contact>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTContactbyGroupID; #region [Parameters] SqlParameter parameterID = new SqlParameter("Group" + GroupDataMapper.PN_ID, SqlDbType.Int); parameterID.Value = groupID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Contact(); while (_dtreader.Read()) { obj = GetContact(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
public Contact GetContact(SqlDataReader _dtr, IList<Contact> colobj) { Contact obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new Contact(); colobj.Add(obj); } return obj; }
private void GetEntityFromReader(SqlDataReader _dtr, Contact obj) { PopulateContact(_dtr, obj); }
public IList<Contact> GetAll() { Contact obj = null; IList<Contact> colobj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTALLContact; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Contact(); colobj = new List<Contact>(); while (_dtreader.Read()) { obj = GetContact(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
public Contact GetByEmail(string eMail) { Contact obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = "dbo.[usp_SelectContactByEmail]"; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_EMAIL, SqlDbType.NVarChar); parameterID.Value = eMail; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Contact(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public Contact GetByID(int ID) { Contact obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTContact; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = ID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Contact(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public void Update(Contact obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = UPDATEContact; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = obj.ID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); SqlParameter parameterFirstName = new SqlParameter(PN_FIRSTNAME, SqlDbType.NVarChar); parameterFirstName.Value = obj.FirstName; parameterFirstName.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterFirstName); SqlParameter parameterSurName = new SqlParameter(PN_SURNAME, SqlDbType.NVarChar); parameterSurName.Value = obj.SurName; parameterSurName.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterSurName); SqlParameter parameterEmail = new SqlParameter(PN_EMAIL, SqlDbType.NVarChar); parameterEmail.Value = obj.Email; parameterEmail.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterEmail); SqlParameter parameterMobile = new SqlParameter(PN_MOBILE, SqlDbType.NVarChar); parameterMobile.Value = obj.Mobile; parameterMobile.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterMobile); SqlParameter parameterPhone2 = new SqlParameter(PN_PHONE2, SqlDbType.NVarChar); parameterPhone2.Value = obj.Phone2; parameterPhone2.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterPhone2); SqlParameter parameterZipCode = new SqlParameter(PN_ZIPCODE, SqlDbType.NVarChar); parameterZipCode.Value = obj.ZipCode; parameterZipCode.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterZipCode); SqlParameter parameterGuid = new SqlParameter(PN_GUID, SqlDbType.NVarChar); parameterGuid.Value = obj.Guid; parameterGuid.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterGuid); SqlParameter parameterStatus = new SqlParameter(PN_STATUS, SqlDbType.Int); parameterStatus.Value = Convert.ToInt32(obj.Status); parameterStatus.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterStatus); SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Int); parameterIsDeleted.Value = obj.IsDeleted; parameterIsDeleted.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterIsDeleted); SqlParameter parameterCountry = new SqlParameter(PN_COUNTRY, SqlDbType.NVarChar); parameterCountry.Value = obj.Country; parameterCountry.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterCountry); SqlParameter parameterCompany = new SqlParameter(PN_COMPANY, SqlDbType.NVarChar); parameterCompany.Value = obj.Company; parameterCompany.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterCompany); SqlParameter parameterNotes = new SqlParameter(PN_NOTES, SqlDbType.NVarChar); parameterNotes.Value = obj.Notes; parameterNotes.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterNotes); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); }
public static void Update(Contact obj) { ContactDataMapper objCaller = new ContactDataMapper(); objCaller.Update(obj); }
public static int Add(Contact obj) { ContactDataMapper objCaller = new ContactDataMapper(); return objCaller.Add(obj); }