void btnSend_Click(object sender, EventArgs e) { try { Fatawa _fatwa = new Fatawa(); int? id = 0; _fatwa.Address = ""; _fatwa.Answer = ""; _fatwa.AnswerDate = DateTime.Now.ToString("dd/MM/yyyy"); //_fatwa.AnsweredBy = SecurityContext.LoggedInUser.ID.ToString(); _fatwa.AnsweredBy = ""; _fatwa.Email = txtEmail.Text; _fatwa.IsDeleted = false; _fatwa.Mobile = ""; _fatwa.Name = txtName.Text; _fatwa.Question = txtQuestion.Text; _fatwa.QuestionDate = DateTime.Now.ToString("dd/MM/yyyy"); _fatwa.CategoryID = 0; _fatwa.Status = 1; FatawaManager.Add(_fatwa); dvMessages.InnerText = Resources.ExpressCMS.YourFatwaHadbeenSend; AddEmailtoQueue(txtEmail.Text, txtName.Text); } catch (Exception ex) { dvMessages.InnerText = ex.Message; } }
public static void Update(Fatawa obj) { FatawaDataMapper objCaller = new FatawaDataMapper(); objCaller.Update(obj); }
public void PopulateFatawa(SqlDataReader _dtr, Fatawa obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_EMAIL); if (!_dtr.IsDBNull(columnIndex)) { obj.Email = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_MOBILE); if (!_dtr.IsDBNull(columnIndex)) { obj.Mobile = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ADDRESS); if (!_dtr.IsDBNull(columnIndex)) { obj.Address = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_QUESTION); if (!_dtr.IsDBNull(columnIndex)) { obj.Question = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ANSWER); if (!_dtr.IsDBNull(columnIndex)) { obj.Answer = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ANSWEREDBY); if (!_dtr.IsDBNull(columnIndex)) { obj.AnsweredBy = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_QUESTIONDATE); if (!_dtr.IsDBNull(columnIndex)) { obj.QuestionDate = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ANSWERDATE); if (!_dtr.IsDBNull(columnIndex)) { obj.AnswerDate = _dtr.GetString((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_STATUS); if (!_dtr.IsDBNull(columnIndex)) { obj.Status = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_ISDELETED); if (!_dtr.IsDBNull(columnIndex)) { obj.IsDeleted = _dtr.GetBoolean((columnIndex)); } columnIndex = _dtr.GetOrdinal(FatawaDataMapper.CN_CATEGORY_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.CategoryID = _dtr.GetInt32((columnIndex)); } }
public static int Add(Fatawa obj) { FatawaDataMapper objCaller = new FatawaDataMapper(); return objCaller.Add(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(); } }
void btnSaveUpdate_Click(object sender, EventArgs e) { if (ObjectID <= 0) { try { Fatawa _fatwa = new Fatawa(); _fatwa.Address = ""; _fatwa.Answer = txtAnswer.Text; _fatwa.AnswerDate = DateTime.Now.ToString("dd/MM/yyyy"); _fatwa.AnsweredBy = SecurityContext.LoggedInUser.Name; _fatwa.CategoryID = Convert.ToInt32(ddlCategories.SelectedValue); _fatwa.Email = txtEmail.Text; _fatwa.QuestionDate = DateTime.Now.ToString("dd/MM/yyyy"); _fatwa.IsDeleted = false; _fatwa.Mobile = ""; _fatwa.Name = txtName.Text; _fatwa.Question = txtQuestion.Text; _fatwa.Status = 1; FatawaManager.Add(_fatwa); AddMode(); ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), Guid.NewGuid().ToString().Substring(0, 8), "alert('Saved Successfully');", true); } catch (Exception ex) { dvProblems.InnerText = ex.ToString(); } } else { try { Fatawa _fatwa = new Fatawa(); _fatwa = FatawaManager.GetByID(ObjectID); if (null == _fatwa) { dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures); return; } _fatwa.Address = ""; _fatwa.Answer = txtAnswer.Text; _fatwa.AnswerDate = DateTime.Now.ToString("dd/MM/yyyy"); _fatwa.AnsweredBy = SecurityContext.LoggedInUser.Name; _fatwa.CategoryID = Convert.ToInt32(ddlCategories.SelectedValue); _fatwa.Email = txtEmail.Text; _fatwa.IsDeleted = false; _fatwa.Mobile = ""; _fatwa.Name = txtName.Text; _fatwa.Question = txtQuestion.Text; _fatwa.Status = Convert.ToInt32(ddlStatus.SelectedValue); FatawaManager.Update(_fatwa); EditMode(); if (_fatwa.Status == Convert.ToInt32(RootEnums.FatawaStatus.Resolved)) { AddEmailtoQueue(_fatwa.Email, _fatwa.Name, _fatwa.Question, _fatwa.Answer); } ScriptManager.RegisterStartupScript(upnall, upnall.GetType(), Guid.NewGuid().ToString().Substring(0, 8), "alert('Saved Successfully');", true); } catch (Exception ex) { dvProblems.InnerText = ex.ToString(); } } }
public Fatawa GetFatawa(SqlDataReader _dtr, IList<Fatawa> colobj) { Fatawa obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new Fatawa(); colobj.Add(obj); } return obj; }
public int Add(Fatawa obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = INSERTFatawa; #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 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 parameterAddress = new SqlParameter(PN_ADDRESS, SqlDbType.NVarChar); parameterAddress.Value = obj.Address; parameterAddress.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterAddress); SqlParameter parameterQuestion = new SqlParameter(PN_QUESTION, SqlDbType.NVarChar); parameterQuestion.Value = obj.Question; parameterQuestion.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterQuestion); SqlParameter parameterAnswer = new SqlParameter(PN_ANSWER, SqlDbType.NVarChar); parameterAnswer.Value = obj.Answer; parameterAnswer.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterAnswer); SqlParameter parameterAnsweredBy = new SqlParameter(PN_ANSWEREDBY, SqlDbType.NVarChar); parameterAnsweredBy.Value = obj.AnsweredBy; parameterAnsweredBy.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterAnsweredBy); SqlParameter parameterQuestionDate = new SqlParameter(PN_QUESTIONDATE, SqlDbType.NVarChar); parameterQuestionDate.Value = obj.QuestionDate; parameterQuestionDate.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterQuestionDate); SqlParameter parameterAnswerDate = new SqlParameter(PN_ANSWERDATE, SqlDbType.NVarChar); parameterAnswerDate.Value = obj.AnswerDate; parameterAnswerDate.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterAnswerDate); SqlParameter parameterStatus = new SqlParameter(PN_STATUS, SqlDbType.Int); parameterStatus.Value = obj.Status; parameterStatus.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterStatus); SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Bit); parameterIsDeleted.Value = obj.IsDeleted; parameterIsDeleted.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterIsDeleted); SqlParameter paramCategoryID = new SqlParameter(PN_CATEGORY_ID, SqlDbType.Int); paramCategoryID.Value = obj.CategoryID; paramCategoryID.Direction = ParameterDirection.Input; _command.Parameters.Add(paramCategoryID); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(parameterID.Value); return obj.ID; }
public IList<Fatawa> GetAllByCategoryByPaging(int catid, int from, int to, ref int totalrows, int status, string keyword) { Fatawa obj = null; IList<Fatawa> colobj = new List<Fatawa>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = "FatawaGetAllByCategoryPaging"; SqlParameter paramCategoryID = new SqlParameter(PN_CATEGORY_ID, SqlDbType.Int); paramCategoryID.Value = catid; paramCategoryID.Direction = ParameterDirection.Input; _command.Parameters.Add(paramCategoryID); SqlParameter pTotalRows = new SqlParameter("TotalRows", SqlDbType.Int); pTotalRows.Value = totalrows; pTotalRows.Direction = ParameterDirection.Output; _command.Parameters.Add(pTotalRows); SqlParameter pFrom = new SqlParameter("From", SqlDbType.Int); pFrom.Value = from; pFrom.Direction = ParameterDirection.Input; _command.Parameters.Add(pFrom); SqlParameter pTo = new SqlParameter("To", SqlDbType.Int); pTo.Value = to; pTo.Direction = ParameterDirection.Input; _command.Parameters.Add(pTo); SqlParameter Pstatus = new SqlParameter("STATUS", SqlDbType.Int); Pstatus.Value = status; Pstatus.Direction = ParameterDirection.Input; _command.Parameters.Add(Pstatus); SqlParameter pKeyword = new SqlParameter("@Keyword", SqlDbType.NVarChar); pKeyword.Value = keyword; pKeyword.Direction = ParameterDirection.Input; _command.Parameters.Add(pKeyword); _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Fatawa(); colobj = new List<Fatawa>(); while (_dtreader.Read()) { obj = GetFatawa(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { totalrows = Convert.ToInt32(pTotalRows.Value); _dtreader.Close(); _connection.Close(); } return colobj; }
public IList<Fatawa> GetAll() { Fatawa obj = null; IList<Fatawa> colobj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = FatawaGetAll; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Fatawa(); colobj = new List<Fatawa>(); while (_dtreader.Read()) { obj = GetFatawa(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
private void GetEntityFromReader(SqlDataReader _dtr, Fatawa obj) { PopulateFatawa(_dtr, obj); }
public IList<Fatawa> Search(string keyword, int catid) { Fatawa obj = null; IList<Fatawa> colobj = new List<Fatawa>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = "[FatawaSearch]"; #region [Parameters] SqlParameter paramkeyword = new SqlParameter("KEYWORD", SqlDbType.NVarChar); paramkeyword.Value = keyword; paramkeyword.Direction = ParameterDirection.Input; _command.Parameters.Add(paramkeyword); SqlParameter paramcatid = new SqlParameter(PN_CATEGORY_ID, SqlDbType.Int); paramcatid.Value = catid; paramcatid.Direction = ParameterDirection.Input; _command.Parameters.Add(paramcatid); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Fatawa(); colobj = new List<Fatawa>(); while (_dtreader.Read()) { obj = GetFatawa(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
public Fatawa GetByID(int ID) { Fatawa obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTFatawa; #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 Fatawa(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }