public static int BindNewSubscriber(DataGrid DL, int PageNo, int PageSize, string SortBy, string SearchQuery, string SearchBy, int TopRows) { int intTotalRows = 0; PageNo = PageNo + 1; try { Hashtable ht = new Hashtable(); clsData dataLayerObj = new clsData(); ht.Add("TableName", "viewNewSubscriber"); ht.Add("TableIDField", "RealtorID"); ht.Add("SortByField", SortBy); ht.Add("SearchIn", "1=1 " + SearchQuery + " and email"); ht.Add("SearchBy", SearchBy); ht.Add("PageSize", PageSize); ht.Add("PageNo", PageNo); ht.Add("TopRows", TopRows); DataSet ds = dataLayerObj.GetDataSetWithoutReplacingQute("usp_Paging", ht); if (ds.Tables.Count > 1) { DataTable DT = ds.Tables[1]; intTotalRows = (int)ds.Tables[0].Rows[0]["TotalRows"]; clsUI.BindData(DL, DT); } else { //HttpContext.Current.Response.Write("<table width=100%><tr><td Class='ErrorMsg' align=center width=100%>No Record found!</td></tr></table>"); } } catch (Exception e) { HttpContext.Current.Response.Write("<table width=100%><tr><td Class='ErrorMsg' align=center width=100%>" + e.Message + "!</td></tr></table>"); } return(intTotalRows); }
public string GetCountyForAssociation(string state, string association) { string strCounty = ""; try { Hashtable ht = new Hashtable(); clsData dataLayerObj = new clsData(); ht.Add("state", state); ht.Add("association", association); DataTable dt = dataLayerObj.GetDataTable("usp_GetCountyForAssociation", ht); StringBuilder sb = new StringBuilder(); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (sb.ToString() != "") { sb.Append(", " + dr["county"].ToString().Trim()); } else { sb.Append(dr["county"].ToString().Trim()); } } strCounty = sb.ToString(); } } catch (Exception e) { HttpContext.Current.Response.Write("<table width=100%><tr><td Class='ErrorMsg' align=center width=100%>" + e.Message + "!</td></tr></table>"); } return(strCounty); }
private void mnuLuu_Click(object sender, EventArgs e) { try { bool sucess = true; csData = new clsData(); if (trangthai == 1) { sucess = csData.Insert_table("Benhan_Insert", Benhan_Parameter()); } else { sucess = csData.Insert_table("Benhan_Update", Benhan_Parameter()); } if (sucess == true) { MessageBox.Show("Cập nhật thành công "); } else { MessageBox.Show("Cập nhật không thành công "); } } catch { MessageBox.Show("Cập nhật không thành công "); } finally { Hienthi(); trangthai = 0; Set_value(); } }
private void mnuXoa_Click(object sender, EventArgs e) { try { bool sucess = true; SqlParameter p1 = new SqlParameter("@MaBacsy", SqlDbType.VarChar, 15); p1.Value = dgvBacsy.CurrentRow.Cells["MaBacsy"].Value.ToString(); csData = new clsData(); sucess = csData.Delete_table("Bacsy_Delete", p1); if (sucess == true) { MessageBox.Show("Cập nhật thành công "); } else { MessageBox.Show("Cập nhật không thành công "); } } catch { MessageBox.Show("Cập nhật không thành công "); } finally { Hienthi(); trangthai = 0; Set_value(); } }
public static int BindFlyers(DataList DL, int PageNo, string SortBy, string SearchBy, string AddressSearch, string City, string State) { int intTotalRows = 0; PageNo = PageNo + 1; try { Hashtable ht = new Hashtable(); clsData dataLayerObj = new clsData(); ht.Add("TableName", "viewOrders"); ht.Add("TableIDField", "order_id"); ht.Add("SortByField", SortBy); ht.Add("SearchIn", "invoice_transaction_id <> '' and type='seller' and prop_address1 like '%" + AddressSearch + "%' and prop_city like '" + City + "%' and prop_state like '" + State + "%' and (prop_zipcode)"); ht.Add("SearchBy", SearchBy.Replace("'", "")); ht.Add("PageSize", 8); ht.Add("PageNo", PageNo); DataSet ds = dataLayerObj.GetDataSetWithoutReplacingQute("usp_Paging", ht); if (ds.Tables.Count > 1) { DataTable DT = ds.Tables[1]; intTotalRows = (int)ds.Tables[0].Rows[0]["TotalRows"]; clsUI.BindData(DL, DT); } else { //HttpContext.Current.Response.Write("<table width=100%><tr><td Class='ErrorMsg' align=center width=100%>No Record found!</td></tr></table>"); } } catch (Exception e) { HttpContext.Current.Response.Write("<table width=100%><tr><td Class='ErrorMsg' align=center width=100%>" + e.Message + "!</td></tr></table>"); } return(intTotalRows); }
public static void CheckOut(int id) { string query = "UPDATE HoaDon SET TrangThai = 1, NgayRa = GETDATE() WHERE id = " + id; clsData dt = new clsData(); dt.ExecuteNonQuery(query); }
private String GetPromoCode(MembershipUser user) { var result = String.Empty; var objData = new clsData(); var dtDiscount = new DataTable(); dtDiscount = objData.GetData("select fly_tblOfferDiscount.*, fly_tblDiscountType.DiscountType from fly_tblOfferDiscount inner join fly_tblDiscountType on fly_tblOfferDiscount.fkDiscountTypeID=fly_tblDiscountType.pkDiscountTypeID where DiscountType='New Registration Offer' and Active=1"); if (dtDiscount.Rows.Count > 0) { var htDiscount = new Hashtable(); htDiscount.Add("fkOfferDiscountID", Convert.ToInt32(dtDiscount.Rows[0]["pkOfferDiscountID"].ToString())); htDiscount.Add("Email", user.Email); htDiscount.Add("Code", dtDiscount.Rows[0]["Code"].ToString()); htDiscount.Add("InValue", dtDiscount.Rows[0]["InValue"].ToString()); htDiscount.Add("InPercentage", dtDiscount.Rows[0]["InPercentage"].ToString()); htDiscount.Add("Discount", dtDiscount.Rows[0]["Discount"].ToString()); htDiscount.Add("Active", dtDiscount.Rows[0]["Active"].ToString()); var dtResult = new DataTable(); dtResult = objData.GetDataTable("usp_InsertOfferDiscountDetails", htDiscount); if (String.Compare(dtResult.Rows[0]["result"].ToString(), "Inserted", true) == 0) { result = dtDiscount.Rows[0]["Code"].ToString(); } } return(result); }
protected void grid_RowDeleted(Object sender, RowDeletedEventArgs e) { try { var id = e.DataCellsList.GetCell(0).GetPropertyValue("Value"); Int32 @int32; if (!Int32.TryParse(id, out @int32)) { message.MessageText = "pkOfferDiscountID should be a number."; message.MessageClass = MessageClassesEnum.System; } if (message.MessageText.HasNoText()) { var objData = new clsData(); objData.strSql = "delete from fly_tblOfferDiscount where pkOfferDiscountID=" + id; objData.ExecuteSql(); message.MessageText = "Specified discount has been deleted successfully!"; message.MessageClass = MessageClassesEnum.Ok; } } catch (Exception ex) { message.MessageText = ex.Message; message.MessageClass = MessageClassesEnum.Error; } message.RedirectToShowMessage(); }
private void mnuLuu_Click(object sender, EventArgs e) { bool sucess = true; csData = new clsData(); if (trangthai == 1) { sucess = csData.Insert_table("TTBN_Insert", TTBN_Parameter()); } else { sucess = csData.Insert_table("TTBN_Update", TTBN_Parameter()); } if (sucess == false) { MessageBox.Show("Cập nhật không thành công "); } else { MessageBox.Show("Cập nhật thành công "); Hienthi(); trangthai = 0; Set_value(); } }
public void CarregarDatas() { clsData objData = new clsData(); MySqlDataReader sql_dr = objData.GetAllData(); bool j; int i; while (sql_dr.Read()) { j = false; for (i = 0; i < cmbAno.Items.Count; i++) { if (Equals(cmbAno.Items[i].ToString(), sql_dr["ano"].ToString())) { j = true; } } if (!j) { cmbAno.Items.Add(sql_dr["ano"].ToString()); } } i = 1; do { if (i < 10) { cmbMes.Items.Add("0" + (i++.ToString())); } else { cmbMes.Items.Add(i++.ToString()); } } while (i <= 12); }
public static clsData[] getData() { string qry = "select * from student"; string constr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; DataSet ds = new DataSet(); List <clsData> details = new List <clsData>(); using (MySqlConnection con = new MySqlConnection(constr)) { using (MySqlCommand cmd = new MySqlCommand(qry)) { cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); MySqlDataAdapter da = new MySqlDataAdapter(cmd); da.Fill(ds); foreach (DataRow dtrow in ds.Tables[0].Rows) { clsData log = new clsData(); log.id = Convert.ToInt32(dtrow["idStudent"]); log.FirstName = dtrow["FirstName"].ToString(); log.LastName = dtrow["LastName"].ToString(); details.Add(log); } con.Close(); return(details.ToArray()); } } }
private void Hienthi_TT_Benhan() { csData = new clsData(); SqlParameter p1 = new SqlParameter("@MaBenhan", SqlDbType.Int); p1.Value = intMaBA; DataSet ds = new DataSet(); ds = csData.Select_table("BenhAn_SelectByID", p1); DataTable dt = new DataTable(); dt = ds.Tables[0]; DataRow dr; dr = dt.Rows[0]; if (ds.Tables[0].Rows.Count > 0) { txtBenhnhan.Text = dr["Hoten"].ToString(); txtBacsy.Text = dr["TenBacsy"].ToString(); txtChuandoan.Text = dr["Chuandoan"].ToString(); lblMaBA.Text = dr["MaBA"].ToString(); } }
private void SaveCustomerTestimonialImage(Int32 customerTestimonialId) { try { if (inputImage.PostedFile != null && inputImage.PostedFile.ContentLength > 0) { var bytes = new Byte[16]; var random = new Random(); random.NextBytes(bytes); var fileName = Helper.GetHexademicalString(bytes); var relativePath = GetCustomerTestimonialImageRelativeDirectory(customerTestimonialId); var fileSystemDirectory = Server.MapPath(relativePath); Helper.HandleCustomerTestimonialsFileImage(fileName, fileSystemDirectory, inputImage.PostedFile.InputStream); var obj = new clsData(); var resizedImagePath = Helper.InjectNamePartToFileName(relativePath + "/" + fileName + ".jpg", Helper.CustomerTestimonialImagesSatteliteSuffix_RESIZED); obj.strSql = "UPDATE tblTestimonials SET ImagePath = N'" + resizedImagePath + "' WHERE pk_TestimonialID = " + customerTestimonialId.ToString(); obj.ExecuteSql(); } } catch (Exception ex) { message.MessageText = ex.Message; message.MessageClass = MessageClassesEnum.Error; } }
private void UpdateUserReferrals() { var objData = new clsData(); var dtUsers = objData.GetDataTable("usp_GetNewProfilesForReferrals"); ProfileCommon profile = null; foreach (DataRow dr in dtUsers.Rows) { profile = Profile.GetProfile(dr["Email"] as String); var ht = new Hashtable(); var RefferedBy = profile.ReferredBy.Split('|'); ht.Add("Email", dr["Email"] as String); if (RefferedBy.Length > 1) { ht.Add("ReferredSource", RefferedBy[0]); ht.Add("ReferredBy", RefferedBy[1]); } else { ht.Add("ReferredSource", String.Empty); ht.Add("ReferredBy", RefferedBy[0]); } ht.Add("CreatedDate", dr["createdate"].ToString()); objData.ExecuteSql("usp_InsertNewReferralProfile", ht); } }
public static int BindFlyers(Repeater rpt, Int32 PageNo, String SortBy, String SearchBy, String AddressSearch, String City, String State) { int intTotalRows = 0; PageNo = PageNo + 1; try { Hashtable ht = new Hashtable(); clsData dataLayerObj = new clsData(); ht.Add("TableName", "viewOrders"); ht.Add("TableIDField", "order_id"); ht.Add("SortByField", SortBy); ht.Add("SearchIn", "invoice_transaction_id <> '' and type='seller' and prop_address1 like '%" + AddressSearch + "%' and prop_city like '" + City + "%' and prop_state like '" + State + "%' and (prop_zipcode)"); ht.Add("SearchBy", SearchBy.Replace("'", "")); ht.Add("PageSize", 12); ht.Add("PageNo", PageNo); using (DataSet ds = dataLayerObj.GetDataSetWithoutReplacingQute("usp_Paging", ht)) { if (ds.Tables.Count > 1) { using (DataTable DT = ds.Tables[1]) { intTotalRows = (int)ds.Tables[0].Rows[0]["TotalRows"]; clsUI.BindData(rpt, DT); } } } } catch { throw; } return(intTotalRows); }
bool Login(string username, string pass) { string query = "USP_Login @userName , @pass"; clsData data = new clsData(); DataTable kt = data.ExecuteQuery(query, new object[] { username, pass }); return(kt.Rows.Count > 0); }
public static bool InsertDrink(string name, int idType, float price) { clsData dt = new clsData(); string query = string.Format("INSERT Nuoc (Ten, idLoai, Gia) VALUES ( N'{0}', {1}, {2})", name, idType, price); int result = dt.ExecuteNonQuery(query); return(result > 0); }
public static bool UpdateDrink(int id, string name, int idType, float price) { clsData dt = new clsData(); string query = string.Format("UPDATE Nuoc SET Ten = N'{0}', idLoai = {1}, Gia = {2} WHERE id = {3} ", name, idType, price, id); int result = dt.ExecuteNonQuery(query); return(result > 0); }
public void inserir() { clsData objData = new clsData(); objData.Ano = Convert.ToInt32(txtAno.Text); MessageBox.Show(objData.insertAno()); this.Close(); }
public void CarregarValores() { double quantia = 0; int quantosMoradores = 0; clsMoradores obj_moradores = new clsMoradores(); MySqlDataReader sql_dr = obj_moradores.GetAllMoradores(); while (sql_dr.Read()) { if (Convert.ToBoolean(sql_dr["ativo"].ToString())) { quantosMoradores++; } } sql_dr.Close(); clsData objData = new clsData(); int idData = objData.GetIdByData(Convert.ToInt32(cmbMes.Text), Convert.ToInt32(cmbAno.Text)); id_data = idData; clsContas objContas = new clsContas(); sql_dr = objContas.GetContasByFiltro("where id_data = " + idData); if (sql_dr.Read()) { //Buscando quantia total do { quantia += Convert.ToDouble(sql_dr["valor_conta"]); } while (sql_dr.Read()); sql_dr.Close(); sql_dr = objData.GetDataById(idData); sql_dr.Read(); txtTotal.Text = "R$" + Math.Round(quantia, 2).ToString(); txtIndividual.Text = "R$" + Math.Round((quantia / quantosMoradores), 2).ToString(); quantia = 0; quantia = Convert.ToDouble(sql_dr["quantia_recebida"]); txtRecebido.Text = "R$" + Math.Round(quantia, 2); sql_dr.Close(); clsPagamentos objPagamento = new clsPagamentos(); objPagamento.Id_Data = idData; sql_dr = objPagamento.GetPagamentosByIdDate(); while (sql_dr.Read()) { MySqlDataReader sql_dr2 = obj_moradores.GetMoradorByID(Convert.ToInt32(sql_dr["id_morador"])); sql_dr2.Read(); ListViewItem item = new ListViewItem(sql_dr2["nome"].ToString()); sql_dr2.Close(); item.SubItems.Add("R$" + sql_dr["valor_pago"].ToString()); item.SubItems.Add(sql_dr["contas"].ToString()); lstPagamentos.Items.Add(item); } btnRelatorio.Visible = true; } else { MessageBox.Show("Data não encontrada!", "Tente novamente"); } }
public static bool DeleteDrinks(int idDrink) { BillInfoDAO.DeleteBillInfoByDrinkID(idDrink); clsData dt = new clsData(); string query = string.Format("Delete Nuoc where id = {0}", idDrink); int result = dt.ExecuteNonQuery(query); return(result > 0); }
private PieSliceModel[] GetDataSource() { var pieSlices = new List <PieSliceModel>(); Int64 orderId; if (Int64.TryParse(Request["orderid"], out orderId) && orderId > 0) { using (var dataLayerObj = new clsData()) { dataLayerObj.objCon.Dispose(); dataLayerObj.objCon = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["fdeliveryDBConnectionString"].ConnectionString); PieSliceModel pieSlice; var ht = new Hashtable(); ht.Add("order_id", (Int32)orderId); try { var dt = dataLayerObj.GetDataTable("usp_GetOrderOverview", ht); if (dt.Rows.Count > 0) { pieSlice = new PieSliceModel("Sent (" + dt.Rows[0]["Email_Sent"].ToString() + ")", (Single)(Int32)dt.Rows[0]["Email_Sent"]); pieSlices.Add(pieSlice); pieSlice = new PieSliceModel("Opened (" + dt.Rows[0]["Email_Opened"].ToString() + ")", (Single)(Int32)dt.Rows[0]["Email_Opened"]); pieSlices.Add(pieSlice); pieSlice = new PieSliceModel("Bounce Back (" + dt.Rows[0]["Email_Bounce_Back"].ToString() + ")", (Single)(Int32)dt.Rows[0]["Email_Bounce_Back"]); pieSlices.Add(pieSlice); message.MessageText = String.Format("Chart data successfully generated for flyer ID={0}.", orderId.ToString()); message.MessageClass = Admin.Controls.MessageClassesEnum.Ok; } else { message.MessageText = String.Format("Data for flyer ID={0} not found.", orderId.ToString()); message.MessageClass = Admin.Controls.MessageClassesEnum.System; } } catch (Exception ex) { message.MessageText = ex.Message; message.MessageClass = Admin.Controls.MessageClassesEnum.Error; } } } else { message.MessageText = String.Format("Flyer ID should be a positive integral number."); message.MessageClass = Admin.Controls.MessageClassesEnum.System; } message.ShowMessage(); var result = pieSlices.ToArray(); return(result); }
private void btnTim_Click(object sender, EventArgs e) { csData = new clsData(); DataSet ds = new DataSet(); ds = csData.Search_table("Tim_BN", TKBN_Parameter()); DataTable dt = new DataTable(); dgvShowBN.DataSource = ds; dgvShowBN.DataMember = ds.Tables[0].TableName.ToString(); }
public void CarregarValores() { clsMoradores obj_moradores = new clsMoradores(); clsData objData = new clsData(); int idData = objData.GetIdByData(Convert.ToInt32(cmbMes.Text), Convert.ToInt32(cmbAno.Text)); if (idData == 0) { MessageBox.Show("Data não encontrada!", "Tente novamente"); } }
private void Hienthi() { csData = new clsData(); DataSet ds = new DataSet(); ds = csData.Select_table("TTBN_SelectAll"); dgvShowBN.DataSource = ds; dgvShowBN.DataMember = ds.Tables[0].TableName.ToString(); }
public static int GetBillByTable(int id) // id cua ban { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT * FROM HoaDon WHERE idBan = " + id + " AND TrangThai = 0"); if (data.Rows.Count > 0) { Bill bill = new Bill(data.Rows[0]); return(bill.Id); } return(-1); }
protected void btnEnter_Click(Object sender, EventArgs e) { String message = null; inputLogin.Attributes.Remove("class"); inputPassword.Attributes.Remove("class"); if (inputLogin.Value.HasNoText()) { message = "Login is required."; inputLogin.Attributes.Add("class", "error"); } else if (inputPassword.Value.HasNoText()) { message = "Password is required"; inputPassword.Attributes.Add("class", "error"); } if (message.HasNoText()) { var objData = new clsData(); var ht = new Hashtable(); ht.Add("UserEmailID", inputLogin.Value); ht.Add("Password", inputPassword.Value); var dt = objData.GetDataTable("usp_getAdminUser", ht); if (dt.Rows.Count > 0) { AdminUserModel.SetAdminUserModelToSession(dt); var url = "~/admin/default.aspx"; if (Request["returnurl"].HasText()) { url = Server.UrlDecode(Request["returnurl"]).Replace(Environment.NewLine, " "); } Response.Redirect(url, true); } else { message = "Your login attempt was not successful. Please try again."; } } if (message.HasText()) { divSummaryError.Visible = true; ltlMessage.Text = message; } }
/// <summary> /// update changes to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { //validate information if (txtLastName.Text == "") { MessageBox.Show("Error: Enter Last Name: "); txtLastName.Focus(); } else if (txtGivenName.Text == "") { MessageBox.Show("Error: Enter Given Name: "); txtGivenName.Focus(); } else if (txtEmail.Text == "") { MessageBox.Show("Error: Enter E-mail: "); txtEmail.Focus(); } else { //verify existing customer if (txtLastName.Tag.ToString() != "N") { clsData myUpdateData = new clsData(); //update local datatable dtUpdate.Rows[0]["LastName"] = txtLastName.Text; dtUpdate.Rows[0]["GivenName"] = txtGivenName.Text; dtUpdate.Rows[0]["Address"] = txtAddress.Text; dtUpdate.Rows[0]["Phone"] = txtPhone.Text; dtUpdate.Rows[0]["Email"] = txtEmail.Text; dtUpdate.Rows[0]["CurrentClass"] = txtCurrentClass.Text; dtUpdate.Rows[0]["StartDate"] = dtpStart.Text; dtUpdate.Rows[0]["EndDate"] = dtpEnd.Text; dtUpdate.Rows[0]["BirthDate"] = dtpBirth.Text; dtUpdate.Rows[0]["Notes"] = txtNotes.Text; //send update to database myUpdateData.UpdateData(dtUpdate, "SELECT ID, LastName, GivenName, Address, Phone, Email, CurrentClass, StartDate, EndDate, BirthDate, Notes FROM tblStuInfo WHERE ID = " + int.Parse(txtLastName.Tag.ToString())); } //assume new student else { //create new instance of clsData clsData myNewData = new clsData(); //call update method, passing values myNewData.CreateRecord(txtLastName.Text, txtGivenName.Text, txtAddress.Text, txtPhone.Text, txtEmail.Text, txtCurrentClass.Text, dtpStart.Value, dtpEnd.Value, dtpBirth.Value, txtNotes.Text); } } //data update. close form this.Close(); }
protected void btnTransferOrders_Command(Object sender, CommandEventArgs e) { try { if (ddlDays.SelectedValue.HasNoText()) { message.MessageText = "Select days."; message.MessageClass = MessageClassesEnum.System; } else if (ddlDays.Items.FindByValue(ddlDays.SelectedValue) == null) { message.MessageText = "Days value should be taken from list."; message.MessageClass = MessageClassesEnum.System; } if (message.MessageText.HasNoText()) { var obj = new clsData(); var ht = new Hashtable(); ht.Add("Days", ddlDays.SelectedValue); var dt = obj.GetDataTable("usp_TransferOrders", ht); var result = dt.Rows[0][0] as String; if (String.Compare(result, "success", true) == 0) { message.MessageText = "Flyers has been transferred successfully."; message.MessageClass = MessageClassesEnum.Ok; } else { message.MessageText = "Data related error occured while transferring orders. Please try again later."; message.MessageClass = MessageClassesEnum.System; } } } catch (Exception ex) { message.MessageText = ex.Message; message.MessageClass = MessageClassesEnum.Error; } if (message.MessageClass == MessageClassesEnum.Ok) { message.RedirectToShowMessage(); } else { message.ShowMessage(); } }
public static Object GetMarkets(String state) { var result = new { Counties = new List <String>(), Associations = new List <String>(), Msa = new List <String>() }; String message = null; if (state.HasText()) { Action <List <String>, DataRowCollection> fillList = (l, drc) => { foreach (DataRow r in drc) { l.Add(r["market"] as String); } }; try { DataTable dt; using (var dataObj = new clsData()) { dataObj.strSql = String.Format("SELECT DISTINCT [market] FROM [fly_county_listsize] where state='{0}' order by market", state); dt = dataObj.GetDataTable(); fillList(result.Counties, dt.Rows); dataObj.strSql = String.Format("SELECT DISTINCT [market] FROM [fly_association_listsize] where state='{0}' order by market", state); dt = dataObj.GetDataTable(); fillList(result.Associations, dt.Rows); dataObj.strSql = String.Format("SELECT DISTINCT [market] FROM [fly_msa_listsize] where state='{0}' order by market", state); dt = dataObj.GetDataTable(); fillList(result.Msa, dt.Rows); } } catch (Exception ex) { message = ex.Message; } } if (message.HasText()) { return(new { Message = message }); } return(result); }
/// <summary> /// ส่งเมล์จาก EmailTemplate โดยระบุค่าตัวแปรได้ /// </summary> /// <param name="TemplateName">ชื่อ Template</param> /// <param name="From">เมล์ต้นทาง</param> /// <param name="To">เมล์ปลายทาง</param> /// <param name="Parameter">ค่าที่ใช้แทนในเมล์ เช่น [Username],nithi.re</param> /// <param name="outMessage">ข้อความแจ้งเตือนเมื่อเกิดข้อผิดพลาด</param> /// <param name="FromAliasName">ชื่อเมล์ต้นทาง</param> /// <param name="Cc">เมล์แนบ</param> /// <param name="Bcc">เมล์ไม่เปิดเผย</param> /// <param name="Signature">ข้อความท้ายเมล์</param> /// <returns>true=ส่งผ่าน , false=ส่งไม่ผ่าน</returns> /// <example> /// clsMail clsMail=new clsMail(); /// string outMessage; /// clsMail.SendTemplate( /// "UserRegisterConfirm", /// "*****@*****.**", /// "*****@*****.**", /// new string[,] { { "[Username]", "ยูสเซอร์เนม" }, { "[UIDEncrypt]", "ยูไอดีเอ็นคริบ" } }, /// out outMessage); /// </example> public bool SendTemplate(string TemplateName, string From, string To, string[,] Parameter, out string outMessage, string FromAliasName = "", string Cc = "", string Bcc = "", string Signature = "") { #region Variable bool rtnValue = false; outMessage = ""; StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); clsSQL clsSQL = new clsSQL(); clsLanguage clsLanguage = new clsLanguage(); clsData clsData=new clsData(); clsDefault clsDefault = new clsDefault(); #endregion #region Found Language #region SQL Query strSQL.Append("SELECT "); strSQL.Append("EmailTemplate.UID,Language.Name LanguageName,EmailTemplate.Subject,EmailTemplate.Message "); strSQL.Append("FROM "); strSQL.Append("EmailTemplate "); strSQL.Append("INNER JOIN Language ON EmailTemplate.LanguageUID=Language.UID "); strSQL.Append("AND Language.Active='1' "); //strSQL.Append("AND Language.Name='" + clsLanguage.LanguageCurrent + "' "); strSQL.Append("WHERE "); strSQL.Append("EmailTemplate.Active='1' "); strSQL.Append("AND EmailTemplate.Name='" + TemplateName + "' "); strSQL.Append("ORDER BY "); strSQL.Append("Language.Sort ASC"); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; #endregion if (dt != null && dt.Rows.Count > 0) { #region Find LanguageRow bool languageMatch = false; int i; for (i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["LanguageName"].ToString() == clsLanguage.LanguageCurrent) { languageMatch = true; break; } } if (!languageMatch) i = 0; #endregion #region Parameter Replace string subject = dt.Rows[i]["Subject"].ToString(); string message = dt.Rows[i]["Message"].ToString(); subject = clsData.Replacer(subject, Parameter); message = clsData.Replacer(message, Parameter); if (Send(From, To, subject, message, out outMessage, FromAliasName, Cc, Bcc, Signature)) { SendTemplateLog(dt.Rows[i]["UID"].ToString(), From, To, Cc, Bcc, "Complete"); rtnValue = true; } else { SendTemplateLog(dt.Rows[i]["UID"].ToString(), From, To, Cc, Bcc, clsDefault.Left(outMessage,90)); rtnValue = false; } #endregion } else { outMessage = "ไม่พบข้อมูล EmailTemplate"; return false; } return rtnValue; }