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;
}
