public int Add(InQuiry obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = INSERTInQuiry; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = obj.ID; parameterID.Direction = ParameterDirection.Output; _command.Parameters.Add(parameterID); SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar); parameterName.Value = obj.Name; parameterName.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterName); SqlParameter parameterDescription = new SqlParameter(PN_DESCRIPTION, SqlDbType.NVarChar); parameterDescription.Value = obj.Description; parameterDescription.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterDescription); SqlParameter parameterEmail = new SqlParameter(PN_EMAIL, SqlDbType.NVarChar); parameterEmail.Value = obj.Email; parameterEmail.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterEmail); SqlParameter parameterPhone = new SqlParameter(PN_PHONE, SqlDbType.NVarChar); parameterPhone.Value = obj.Phone; parameterPhone.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterPhone); SqlParameter parameterCountry = new SqlParameter(PN_COUNTRY, SqlDbType.NVarChar); parameterCountry.Value = obj.Country; parameterCountry.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterCountry); 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); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(parameterID.Value); return obj.ID; }
public void PopulateInQuiry(SqlDataReader _dtr, InQuiry obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_DESCRIPTION); if (!_dtr.IsDBNull(columnIndex)) { obj.Description = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_EMAIL); if (!_dtr.IsDBNull(columnIndex)) { obj.Email = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_PHONE); if (!_dtr.IsDBNull(columnIndex)) { obj.Phone = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_COUNTRY); if (!_dtr.IsDBNull(columnIndex)) { obj.Country = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_STATUS); if (!_dtr.IsDBNull(columnIndex)) { obj.Status = (TG.ExpressCMS.DataLayer.Enums.RootEnums.InQuiryStatus)_dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(InQuiryDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } }
public static void Update(InQuiry obj) { InQuiryDataMapper objCaller = new InQuiryDataMapper(); objCaller.Update(obj); }
public static int Add(InQuiry obj) { InQuiryDataMapper objCaller = new InQuiryDataMapper(); return objCaller.Add(obj); }
public InQuiry GetInQuiry(SqlDataReader _dtr, IList<InQuiry> colobj) { InQuiry obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new InQuiry(); colobj.Add(obj); } return obj; }
public IList<InQuiry> GetAll() { InQuiry obj = null; IList<InQuiry> colobj = new List<InQuiry>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTALLInQuiry; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new InQuiry(); colobj = new List<InQuiry>(); while (_dtreader.Read()) { obj = GetInQuiry(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
private void GetEntityFromReader(SqlDataReader _dtr, InQuiry obj) { PopulateInQuiry(_dtr, obj); }
public InQuiry GetByID(int ID) { InQuiry obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTInQuiry; #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 InQuiry(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
void btnSaveUpdate_Click(object sender, EventArgs e) { if (NoBot2.IsValid()) { if (cu.Checked) { string result = string.Empty; InQuiry _quiry = new InQuiry(); _quiry.Country = HttpUtility.HtmlEncode(txtCountry.Text); _quiry.Email = HttpUtility.HtmlEncode(txtEmail.Text); _quiry.Description = HttpUtility.HtmlEncode(txtDescription.Text); _quiry.Name = HttpUtility.HtmlEncode(txtName.Text); _quiry.Phone = HttpUtility.HtmlEncode(txtPhone.Text); _quiry.IsDeleted = false; _quiry.Status = DataLayer.Enums.RootEnums.InQuiryStatus.Pending; InQuiryManager.Add(_quiry); ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString().Substring(0, 4), "alert('" + Resources.ExpressCMS.SuccessfullySent + "');", true); if (_quiry.ID > 0) dvMessage.InnerText = Resources.ExpressCMS.ResourceManager.GetString("SuccessfullySent"); else dvMessage.InnerText = Resources.ExpressCMS.ResourceManager.GetString("FormSubmitFailed"); } else if (fa.Checked) { try { Fatawa _fatwa = new Fatawa(); int? id = 0; _fatwa.Address = ""; _fatwa.Answer = ""; _fatwa.AnswerDate = DateTime.Now.ToShortDateString(); //_fatwa.AnsweredBy = SecurityContext.LoggedInUser.ID.ToString(); _fatwa.AnsweredBy = ""; _fatwa.Email = txtEmail.Text; _fatwa.IsDeleted = false; _fatwa.Mobile = ""; _fatwa.Name = txtName.Text; _fatwa.Question = txtDescription.Text; _fatwa.QuestionDate = DateTime.Now.ToString("dd/MM/yyyy"); _fatwa.CategoryID = -1; _fatwa.Status = 0; FatawaManager.Add(_fatwa); AddEmailtoQueue(txtEmail.Text, txtName.Text); dvMessage.InnerText = Resources.ExpressCMS.YourFatwaHadbeenSend; ScriptManager.RegisterStartupScript(this, this.GetType(), Guid.NewGuid().ToString().Substring(0, 4), "alert('" + Resources.ExpressCMS.YourFatwaHadbeenSend + "');", true); } catch (Exception ex) { dvMessage.InnerText = ex.Message; } } ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), Guid.NewGuid().ToString().Substring(0, 6), "alert('" + dvMessage.InnerText + "');", true); AddMode(); } }