protected void btnSignIn_Click(object sender, ImageClickEventArgs e)
{
if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "")
lblMessage.Text = "Both fields are required";
else
{
query = "select usertype from Login where username='******' AND Password='******'";
reader = db.data_read(query);
if (reader.Read())
{
if (reader.GetString(0).Trim() == "Employee") // Go to employee's home page
{
Session["username"] = txtUsername.Text;
reader.Close();
Response.Redirect("~/employee/EmployeeHome.aspx");
}
else if (reader.GetString(0).Trim() == "Employer")// Go to employer's home page
{
Session["username"] = txtUsername.Text;
reader.Close();
Response.Redirect("~/employer/EmployerHome.aspx");
}
else // Go to admin's home page
{
Session["username"] = txtUsername.Text;
Response.Redirect("~/admin/Home.aspx");
}
}
else
{
lblMessage.Text = "Invalid Username/Password or no such user exists";
}
}
}
public User getUser(string _username, string _pass)
{
User user = null;
try
{
conn = db.openConn();
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append(" SELECT ID,UserName,Password,Ulevel FROM tbUser ");
sb.Append(" WHERE (UserName='******')");
sb.Append(" AND (Password='******')");
string sql;
sql = sb.ToString();
comm = new SqlCommand();
comm.CommandText = sql;
comm.CommandType = CommandType.Text;
comm.Connection = conn;
dr = comm.ExecuteReader();
if (dr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(dr);
int index = 1;
foreach (DataRow drw in dt.Rows)
{
user = new User();
user.UID = drw["ID"].ToString();
user.UserName = drw["UserName"].ToString();
user.Password = drw["Password"].ToString();
user.level = drw["Ulevel"].ToString();
}
}
dr.Close();
}
catch (Exception ex)
{
dr.Close();
conn.Close();
return null;
throw ex;
}
finally
{
conn.Close();
}
return user;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn.Open();
com.Connection = conn;
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@UserName", tbxUserName.Text);
com.Parameters.AddWithValue("@Email", tbxEmail.Text);
com.CommandText = "CheckUsers";
//string checkUsers = "SELECT UserName from UserTbl where UserName = @UserName OR Email = @Email";
//SqlCommand checkCom = new SqlCommand(checkUsers, conn);
//checkCom.Parameters.AddWithValue("@UserName", tbxUserName.Text);
//checkCom.Parameters.AddWithValue("@Email", tbxEmail.Text);
reader = com.ExecuteReader();
if (reader.Read())
{
lblError.Text = "User name or Email is unavailable";
reader.Close();
}
else
{
reader.Close();
com.Connection = conn;
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "RegisterUser";
com.Parameters.Clear();
com.Parameters.AddWithValue("@UserName", tbxUserName.Text);
com.Parameters.AddWithValue("@Email", tbxEmail.Text);
com.Parameters.AddWithValue("@Password", Utilities.GetMD5Hash(tbxPassword.Text));
com.Parameters.AddWithValue("@DOB", tbxDOB.Text);
com.Parameters.AddWithValue("@ContactNo", tbxContactNum.Text);
com.ExecuteNonQuery();
reader = com.ExecuteReader();
Response.Redirect("LogIn.aspx");
}
}
catch(Exception ex)
{
Response.Write("Error: " + ex.ToString());
}
finally
{
reader.Close();
conn.Close();
}
}
internal static string GetCampaignContent(Guid campaignId, Guid objectId, UserDataContext udc, string word, string type)
{
string campaignContent = "";
float costPerPopupView = 0;
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_Filter_AdCampaigns_LoadById";
sqlConnection.Command.Parameters.Add(new SqlParameter("@CampaignId", SqlDbType.UniqueIdentifier));
sqlConnection.Command.Parameters["@CampaignId"].Value = campaignId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
if (sqlDataReader.Read())
{
campaignContent = sqlDataReader["FAC_Content"].ToString();
costPerPopupView = float.Parse(sqlDataReader["FAC_CostPerPopupView"].ToString());
}
sqlDataReader.Close();
}
finally
{
sqlConnection.Close();
}
if (AddView(udc.IsAuthenticated ? udc.UserID : udc.AnonymousUserId, udc.UserIP, campaignId, type) > 0)
{
IncreaseCreditsUsed(udc, campaignId, costPerPopupView);
AddLog(campaignId, objectId, udc.UserID, word, type);
}
return(campaignContent);
}
protected void Btnpreview_Click(object sender, EventArgs e)
{
imgprofile_pic.Visible = true;
int uid = int.Parse(Session["uid"].ToString());
if (fluplod.HasFile == true)
{
cn.Open();
cmd = new SqlCommand("Select Email_id from Registration_Master Where User_Id=" + uid,cn);
dr = cmd.ExecuteReader();
dr.Read();
string email = dr["Email_Id"].ToString();
dr.Close();
if(!Directory.Exists(Server.MapPath("~/User/"+email+"/Images")))
{
Directory.CreateDirectory(Server.MapPath("~/Users/"+email+"/Profilepic"));
}
string fpath = "~/Users/"+email+"/Profilepic/" + fluplod.FileName;
fluplod.PostedFile.SaveAs(Server.MapPath(fpath));
cmd = new SqlCommand("Update Registration_Master set User_Photo=@user_photo where User_Id=" + uid, cn);
cmd.Parameters.AddWithValue("user_photo", fpath);
cmd.ExecuteNonQuery();
cn.Close();
}
//int uid = int.Parse(Session["uid"].ToString());
cn.Open();
cmd = new SqlCommand("select * from Registration_Master where User_Id=" + uid, cn);
dr = cmd.ExecuteReader();
dr.Read();
imgprofile_pic.ImageUrl = dr["User_Photo"].ToString();
fluplod.Enabled = false;
btnchoose.Enabled = true;
cn.Close();
}
/// <summary>
/// SqlDataReaderתDataTableTable
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
public static DataTable Convertdrtodt(SqlDataReader dr, DataTable dataTable)
{
//DataTable dataTable = new DataTable();//��һ���µ�ʵ��
for (int i = 0; i < dr.FieldCount; i++)
{
DataColumn mydc = new DataColumn();//�ؼ���һ��
mydc.DataType = dr.GetFieldType(i);
mydc.ColumnName = dr.GetName(i);
dataTable.Columns.Add(mydc);//�ؼ��ĵڶ���
}
while (dr.Read())
{
DataRow mydr = dataTable.NewRow();//�ؼ��ĵ�����
for (int i = 0; i < dr.FieldCount; i++)
{
mydr[i] = dr[i];//.ToString();
}
dataTable.Rows.Add(mydr);//�ؼ��ĵ��IJ�
mydr = null;
}
dr.Close();
return (dataTable);//������Ҫ����datatable���������
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MIP_MSG_NO, MSG_TARGET, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, MSG_STATE, LDATE, LUSER, SELECTALL, PROCESSED, ISNEW FROM MIP_MSG_MAIN WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mIP_MSG_NO = reader.GetInt32(0);
_mSG_TARGET = reader.GetString(1);
_rESERVATION = reader.GetString(2);
_oNLINE_TIME = reader.GetDateTime(3);
_oFFLINE_TIME = reader.GetDateTime(4);
_dOPUSH = reader.GetString(5);
_mSG_KIND_1 = reader.GetString(6);
_mSG_KIND_2 = reader.GetString(7);
_mSG_TITLE = reader.GetString(8);
_mSG_CONTENT = reader.GetString(9);
_mSG_STATE = reader.GetString(10);
_lDATE = reader.GetDateTime(11);
_lUSER = reader.GetString(12);
_sELECTALL = reader.GetInt32(13);
_pROCESSED = reader.GetInt32(14);
_iSNEW = reader.GetInt32(15);
}
reader.Close();
}
}
private void btnConvertExcel_Click(object sender, EventArgs e)
{
//Class.ExportToExcel.Export2Excel(dgvPrintSaleDayExcel);
com = new SqlCommand();
com.Parameters.Clear();
com.Parameters.Add("@saleDate", SqlDbType.DateTime).Value = Convert.ToDateTime(saleDate);
com.CommandText = strExcelToFormula;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
DataTable dtFormula = new DataTable();
dtFormula.Load(dr);
dtFormula.Columns["ProductId"].ColumnName = "รหัสสินค้า";
dtFormula.Columns["SaleHeadId"].ColumnName = "ใบยืม";
dtFormula.Columns["SaleDetailQuantity"].ColumnName = "จำนวน";
dtFormula.Columns["SaleDetailPriceUnit"].ColumnName = "ราคาขาย";
dtFormula.Columns["Cash"].ColumnName = "ขายสด";
ds = new DataSet();
ds.Tables.Add(dtFormula);
dr.Close();
Class.ExportToExcel.Export2Excel(ds);
frmCheckSaleDaily frm = new frmCheckSaleDaily();
frm.Close();
}
internal static List <string> GetCampaignObjectIds(Guid objectId)
{
List <string> campaignObjectIds = new List <string>();
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_Filter_CampaignObjects_LoadIds";
sqlConnection.Command.Parameters.Add(new SqlParameter("@ObjectId", SqlDbType.UniqueIdentifier));
sqlConnection.Command.Parameters["@ObjectId"].Value = objectId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
while (sqlDataReader.Read())
{
for (int i = 1; i <= int.Parse(sqlDataReader["FAO_NumberPopupLinks"].ToString()); i++)
{
campaignObjectIds.Add(sqlDataReader["FAC_ID"].ToString() + "_" + sqlDataReader["OBJ_ID"].ToString() + "_" + sqlDataReader["FAO_Word"].ToString() + "_" + i);
}
}
sqlDataReader.Close();
}
finally
{
sqlConnection.Close();
}
return(campaignObjectIds);
}
public IEnumerable <IDictionary <string, object> > GetRows(string selectStatement)
{
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
if (!selectStatement.StartsWith("SELECT"))
{
throw new ArgumentException($"ILLEGAL STATEMENT!!! IT IS NOT A SELECT: '{selectStatement}'");
}
SqlCommand command = new SqlCommand(selectStatement, connection);
connection.Open();
System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
yield return(Enumerable.Range(0, reader.FieldCount)
.ToDictionary(reader.GetName, reader.GetValue));
}
}
finally
{
reader.Close();
}
}
}
public static void BacaCombo(ComboBox cbRelasi, string cmd)
{
cbRelasi.Items.Clear();
BukaDatabase();
//Conn.Open()
SqlCommand cm = new SqlCommand(cmd, conn);
try
{
System.Data.SqlClient.SqlDataReader rdr = cm.ExecuteReader();
if (rdr.Read())
{
cbRelasi.Items.Add(rdr[0].ToString());
}
rdr.Close();
}
catch (Exception salah)
{
MessageBox.Show("PERHATIAN.. " + salah.Message, "Kesalahan");
}
finally
{
conn.Close();
}
}
public List <ChartDataPair> GetUserTagWordCount()
{
List <ChartDataPair> chartDataPairList = new List <ChartDataPair>();
SqlConnection sqlConnection = new SqlConnection();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandText = "SELECT TOP 20 dbo.hitbl_Tagword_TGW.TGW_WordLower, Count(dbo.hitbl_Tagword_TGW.TGW_WordLower) AS TagWordCount " +
"FROM dbo.hitbl_TagLog_TGL INNER JOIN dbo.hitbl_Tagword_TGW ON dbo.hitbl_TagLog_TGL.TGW_ID = dbo.hitbl_Tagword_TGW.TGW_ID " +
"GROUP BY dbo.hitbl_Tagword_TGW.TGW_WordLower, dbo.hitbl_TagLog_TGL.TGW_Type " +
"HAVING (((dbo.hitbl_TagLog_TGL.TGW_Type)>1)) " +
"ORDER BY Count(dbo.hitbl_Tagword_TGW.TGW_WordLower) DESC";
sqlDataReader = sqlConnection.Command.ExecuteReader();
while (sqlDataReader.Read())
{
// Get tag name and add to list
chartDataPairList.Add(new ChartDataPair(sqlDataReader["TGW_WordLower"].ToString(), int.Parse(sqlDataReader["TagWordCount"].ToString())));
}
}
catch (Exception e)
{
throw new SoapException("Anfrage konnte nicht bearbeitet werden -> " + e.Message, SoapException.ServerFaultCode);
}
finally
{
try { sqlDataReader.Close(); }
finally { sqlConnection.Close(); }
}
return(chartDataPairList);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
cn.Open();
cmd.CommandText = "select Username from Users where Username like @Name";
ListBox1.Items.Clear();
cmd.Parameters.AddWithValue("@Name", "%" + TextBox1.Text + "%");
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
ListBox1.Items.Add(dr[0].ToString());
}
}
else
{
ListBox1.Items.Add("Ничего не найдено!");
}
cmd.Parameters.Clear();
dr.Close();
cn.Close();
cmd.Parameters.Clear();
}
/// <summary>
/// 检验是否存在数据
/// </summary>
/// <returns></returns>
public bool ExistData(string SQL)
{
bool ret = false;
try
{
System.Data.SqlClient.SqlDataReader dr = ReturnDataReader(SQL);
if (dr.HasRows)
{
ret = true;
}
dr.Close();
}
catch (Exception Ex)
{
throw new Exception(SQL + Ex.ToString());
}
finally
{
if (null == transaction)
{
Close();
}
}
return(ret);
}
public IActionResult Tables(String name)
{
dbname = name;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
TableNamesList model = new TableNamesList()
{
};
List <string> result = new List <string>();
SqlCommand cmd = new SqlCommand(@"SELECT name FROM " + name + ".sys.Tables", con);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if (reader["name"].ToString() != "__RefactorLog")
{
result.Add(reader["name"].ToString());
}
}
reader.Close();
model.Database_name = name;
model.Tables = result;
con.Close();
return(View(model));
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT appname, AccountID, deviceid, pushid, phonetype, status, createdatetime, PHONE_OS, PHONE_NAME, PHONE_MODEL, updatedatetime FROM MobileDeviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_appname = reader.GetString(0);
_accountID = reader.GetString(1);
_deviceid = reader.GetString(2);
_pushid = reader.GetString(3);
_phonetype = reader.GetString(4);
_status = reader.GetBoolean(5);
_createdatetime = reader.GetDateTime(6);
_pHONE_OS = reader.GetString(7);
_pHONE_NAME = reader.GetString(8);
_pHONE_MODEL = reader.GetString(9);
_updatedatetime = reader.GetDateTime(10);
}
reader.Close();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
Panel3.Visible = true;
Label26.Text = Session["dn"].ToString();
cmd = new SqlCommand("select orderno,orderdate,deliverydate,name from booking where name='" + Session["nm"].ToString() + "' and Delivery='" + Labeldeliveryresult.Text + "' and distributorname='" + Session["dn"].ToString() + "'", con);
con.Open();
dr = cmd.ExecuteReader();
string s1 = "";
while (dr.Read())
{
s1 = dr.GetValue(0).ToString();
TextBox18.Text = dr.GetValue(1).ToString();
TextBox14.Text = dr.GetValue(2).ToString();
TextBox16.Text = dr.GetValue(3).ToString();
}
TextBox12.Text = s1;
TextBox13.Text = (int.Parse(s1) + 1000).ToString();
dr.Close();
cmd = new SqlCommand("select email,city from consumer where username='******'", con);
dr = cmd.ExecuteReader();
if (dr.Read())
{
TextBox17.Text = dr.GetValue(0).ToString();
TextBox19.Text = dr.GetValue(1).ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
con.Open();
//Session["s1"] = DropDownList1.SelectedItem.ToString();
cmd = new SqlCommand("select * from add_passenger where invoice_no = '" + DropDownList1.SelectedItem.ToString() + "'" ,con);
dr = cmd.ExecuteReader();
while(dr.Read())
{
a = dr["Invoice_No"].ToString();
b = dr["Flight_no"].ToString();
c = dr["Date_Of_Travel"].ToString();
d = dr["Source"].ToString();
f = dr["Destination"].ToString();
g = dr["Category"].ToString();
h= dr["Passenger_Name"].ToString();
i = dr["Age"].ToString();
j = dr["Gender"].ToString();
k = dr["Phone_No"].ToString();
l = dr["E_Mail"].ToString();
m = dr["City"].ToString();
}
dr.Close();
con.Close();
con.Open();
cmd = new SqlCommand("Insert into Seat_Cancellation Values('"+a+"','"+b+"','"+c+"','"+d+"','"+f+"','"+g+"','"+h+"','"+i+"','"+j+"','"+k+"','"+l+"','"+m+"')",con);
cmd.ExecuteNonQuery();
con.Close();
con.Open();
con.Close();
Session["bb"] = DropDownList1.SelectedItem.ToString();
Response.Redirect("Refund.aspx");
}
/// <summary>
/// 对当前数据能否拆分的检查
/// </summary>
/// <returns></returns>
protected string CheckCurernt()
{
/*************
* 1、已提交明细部件不能拆分
* 2、变更删除部件不能拆分
* ***********/
string sql_1 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND BM_MSSTATE='1'";
System.Data.SqlClient.SqlDataReader dr_1 = DBCallCommon.GetDRUsingSqlText(sql_1);
if (dr_1.HasRows)
{
return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】明细已提交，无法拆分！！！')");
}
dr_1.Close();
string sql_2 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND (BM_MSSTATUS='1' or BM_MPSTATUS='1' or BM_OSSTATUS='1')";
System.Data.SqlClient.SqlDataReader dr_2 = DBCallCommon.GetDRUsingSqlText(sql_2);
if (dr_2.HasRows)
{
return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】为变更删除记录，无法拆分！！！')");
}
dr_2.Close();
return("OK");
}
public static DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader)
{
DataTable table = new DataTable();
DataTable schemaTable = dataReader.GetSchemaTable();
DataTable result;
try
{
foreach (DataRow row in schemaTable.Rows)
{
DataColumn column = new DataColumn {
DataType = row.GetType(),
ColumnName = row[0].ToString()
};
table.Columns.Add(column);
}
while (dataReader.Read())
{
DataRow row2 = table.NewRow();
for (int i = 0; i < schemaTable.Rows.Count; i++)
{
row2[i] = dataReader[i].ToString();
}
table.Rows.Add(row2);
}
schemaTable = null;
dataReader.Close();
result = table;
}
catch (Exception ex)
{
SystemError.SystemLog(ex.Message);
throw new Exception(ex.Message, ex);
}
return result;
}
// 비밀번호 변경 - 입력한 기존 비밀번호가 일치?)
public bool ChangePW_isMember(string id, string pw)
{
try
{
conn.Open();
string sql_truncate = "SELECT * FROM member WHERE id=@id AND pw=@pw";
command = new SqlCommand(sql_truncate, conn);
command.Parameters.Add("@id", SqlDbType.VarChar);
command.Parameters.Add("@pw", SqlDbType.VarChar);
command.Parameters["@id"].Value = id;
command.Parameters["@pw"].Value = pw;
reader = command.ExecuteReader();
return reader.HasRows;
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
finally
{
reader.Close();
conn.Close();
}
return reader.HasRows;
}
private void button1_Click(object sender, EventArgs e)
{
string kode = getOppAlias();
// berikut ini adalah contoh penggunaan string.format. dimana {0} untuk parameter 1st dan {1} parameter 2nd
//MessageBox.Show(string.Format("Menit: {0:MM} \nJam: {1}", DateTime.Now, DateTime.Now.ToShortTimeString()));
try
{
koneksi.Open();
reader = konek.MembacaData("SELECT COUNT(*) FROM KASDA..BLJ_MASTER WHERE YEAR(Tgl_SP) = YEAR(GETDATE())", koneksi);
if (reader.HasRows)
{
reader.Read();
if (alat.PengecekField(reader, 0) == "0")
{
Clipboard.SetText(string.Format("1/{0:MM}/{1:yy}/{2}", DateTime.Now, DateTime.Now, kode));
//MessageBox.Show("Test");
}
else
//MessageBox.Show(string.Format("{0}/{1:MM}/{2:yy}/{3}", alat.pengecekField(reader, 0),
// DateTime.Now, DateTime.Now, kode));
Clipboard.SetText(string.Format("{0}/{1:MM}/{2:yy}/{3}", alat.PengecekField(reader, 0),
DateTime.Now, DateTime.Now, kode));
reader.Close();
}
koneksi.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public System.Collections.Generic.List <UsersMenu> GetAll()
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
System.Collections.Generic.List <UsersMenu> ListTmp = new System.Collections.Generic.List <UsersMenu>();
UsersMenu ObjTmp = null;
SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString());
Con.Open();
try
{
string Query = "SELECT * FROM Menu ORDER BY Menu_Id ASC";
cmd = new System.Data.SqlClient.SqlCommand(Query, Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp = new UsersMenu
{
Menu_Id = int.Parse(SDR["Menu_Id"].ToString()),
MenuDisplayName = SDR["MenuDisplayName"].ToString(),
ParentMenuId = int.Parse(SDR["ParentMenuId"].ToString()),
MenuOrderNo = int.Parse(SDR["MenuOrderNo"].ToString()),
MenuLink = SDR["MenuLink"].ToString(),
Menu_Icon = SDR["Menu_Icon"].ToString(),
User_Types = SDR["User_Types"].ToString(),
Section = SDR["Section"].ToString()
};
ListTmp.Add(ObjTmp);
}
}
catch (System.Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; }
return(ListTmp);
}
protected void Page_Load(object sender, EventArgs e)
{
cmd.Connection = vd.getcon();
/*if (!IsPostBack)
{
cmd.CommandText = "select name from componentlist";
ad.SelectCommand = cmd;
ad.Fill(ds);
DPLSELECTVENDOR.DataSource = ds;
DPLSELECTVENDOR.DataTextField = ds.Tables[0].Columns[0].ToString();
DPLSELECTVENDOR.DataBind();
}*/
if (!Page.IsPostBack)
{
cmd.CommandText = "select * from purchaseorder where vendorname='"+Session["vendorname"]+"' and componentname='"+Session["comp"]+"'";
dr = cmd.ExecuteReader();
dr.Read();
TXTPONUMBER.Text = dr["ponumber"].ToString();
TXTCOMPONENTNAME.Text = dr["componentname"].ToString();
TXTQUANTITY.Text=dr["quantity"].ToString();
dr.Close();
}
}
public static System.Collections.Generic.List <FAB> GetListSoonExpired(int CompanyID)
{
System.Collections.Generic.List <FAB> result = new System.Collections.Generic.List <FAB>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("CompanyID", CompanyID);
db.AddBoolean("IsAgent", AdgangsKontrol.IsAgent());
db.AddGuid("AgentID", CurrentUserID);
System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader);
//Try
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectAllSoonExpired));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
result.Add(FAB.GetFAB(ID));
}
}
dr.Close();
//Catch ex As Exception
// Throw ex
//End Try
return(result);
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT GroupID, AccountID, Name, Description, Password, Startup, PWLastUpdateTime, PWType, CreateTime, dModifyTime, iFailTimes, dLockTime, cRoleID, AD_CheckFlag, cCallID, cPWD FROM SecurityUserAccount WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_groupID = reader.GetString(0);
_accountID = reader.GetString(1);
_name = reader.GetString(2);
_description = reader.GetString(3);
//_password = reader.GetString(4);
_password = (byte[])reader[4];
_startup = reader.GetBoolean(5);
_pWLastUpdateTime = reader.GetDateTime(6);
_pWType = reader.GetInt16(7);
_createTime = reader.GetDateTime(8);
_dModifyTime = reader.GetDateTime(9);
_iFailTimes = reader.GetInt16(10);
_dLockTime = reader.GetDateTime(11);
_cRoleID = reader.GetInt16(12);
_aD_CheckFlag = reader.GetBoolean(13);
_cCallID = reader.GetString(14);
_cPWD = reader.GetString(15);
}
reader.Close();
}
}
/// <summary>
/// returns DataTable from stored procedure.
/// </summary>
/// <param name="storeProcedure"></param>
/// <returns></returns>
public DataTable TableFromProc(SqlCommand cmd)
{
DataTable table = new DataTable();
cmd.Connection = new SqlConnection(this._connectionString);
cmd.Connection.Open();
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if ((table.Columns.Count == 0))
{
table.TableName = cmd.CommandText;
for (int i = 0; (i < reader.FieldCount); i = i + 1
)
{
System.Type type = reader.GetFieldType(i);
string name = reader.GetName(i);
table.Columns.Add(name, type);
}
}
table.Clear();
int result = 0;
for (; reader.Read(); result = result + 1)
{
System.Data.DataRow row = table.NewRow();
object[] rowdata = new object[reader.FieldCount];
reader.GetValues(rowdata);
row.ItemArray = rowdata;
table.Rows.Add(row);
}
reader.Close();
return(table);
}
/// <summary>
/// ��DataReader תΪ DataTable
/// </summary>
/// <param name="DataReader">DataReader</param>
public DataTable ConvertDataReaderToDataTable(SqlDataReader dataReader)
{
DataTable datatable = new DataTable();
try
{
DataTable schemaTable = dataReader.GetSchemaTable();
//��̬�����
foreach (DataRow myRow in schemaTable.Rows)
{
DataColumn myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = myRow[0].ToString();
datatable.Columns.Add(myDataColumn);
}
//�������
while (dataReader.Read())
{
DataRow myDataRow = datatable.NewRow();
for (int i = 0; i < schemaTable.Rows.Count; i++)
{
myDataRow[i] = dataReader[i].ToString();
}
datatable.Rows.Add(myDataRow);
myDataRow = null;
}
schemaTable = null;
}
finally
{
dataReader.Close();
dataReader.Dispose();
}
return datatable;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT ServiceID, sUrl, sNamespace, sClassname, APName, sDescription, sStatus, sCreateDatetime, ENCRYPTED FROM WebserviceData WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_serviceID = reader.GetString(0);
_sUrl = reader.GetString(1);
_sNamespace = reader.GetString(2);
_sClassname = reader.GetString(3);
_aPName = reader.GetString(4);
_sDescription = reader.GetString(5);
_sStatus = reader.GetBoolean(6);
_sCreateDatetime = reader.GetDateTime(7);
_eNCRYPTED = reader.GetBoolean(8);
}
reader.Close();
}
}
public int peliculaRegistrada(int CategoriaId)
{
int cont = 0;
try
{
cmd = new SqlCommand(string.Format("select *from registroPelicula where categoriaId = {0}", CategoriaId), con);
dr = cmd.ExecuteReader();
while (dr.Read())
{
cont++;
}
dr.Close();
}
catch (Exception ex)
{
MessageBox.Show("No hay Vida: "+ex.ToString ());
}
return cont;
}
protected void Page_Load(object sender, EventArgs e)
{
cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Technetium.mdf;Integrated Security=True;User Instance=True");
if (!IsPostBack)
{
if (Session["uid"] == null)
{
Response.Redirect("Default.aspx");
return;
}
try
{
int uid = int.Parse(Session["uid"].ToString());
cn.Open();
cmd = new SqlCommand("select * from Registration_Master where User_Id=" + uid, cn);
dr = cmd.ExecuteReader();
dr.Read();
imgprofile_pic.ImageUrl = dr["User_Photo"].ToString();
btnchoose.Enabled = false;
dr.Close();
cn.Close();
}
catch
{
}
}
}
// When a DVD is selected, populate the textboxes with its information
protected void btnSelect_Click(object sender, EventArgs e)
{
// Enable update and delete buttons
btnDelete.Enabled = true;
btnUpdate.Enabled = true;
setConnection();
myCmd = new SqlCommand("SELECT DVDtitle, DVDartist, DVDrating, DVDprice FROM DVDtable WHERE DVDID = " + dvdDropdown.SelectedValue, myConnection);
try
{
myConnection.Open();
myReader = myCmd.ExecuteReader();
while (myReader.Read())
{
txtTitle.Text = (myReader["DVDtitle"].ToString());
txtArtist.Text = (myReader["DVDartist"].ToString());
txtRating.Text = (myReader["DVDrating"].ToString());
txtPrice.Text = (myReader["DVDprice"].ToString());
}
myReader.Close();
}
finally
{
myConnection.Close();
}
}
public List <District> GetAllByStsCity(int StateId, int CityId, bool All = false)
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
List <District> ListTmp = new List <District>();
System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString());
Con.Open();
try
{
string Query = "SELECT * FROM District where StateId=" + StateId.ToString() + " and CityId=" + CityId.ToString();
if (All)
{
Query = "SELECT * FROM District";
}
cmd = new System.Data.SqlClient.SqlCommand(Query, Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
District ObjTmp = new District
{
Id = int.Parse(SDR["Id"].ToString()),
Name = SDR["Name"].ToString(),
StateId = int.Parse(SDR["StateId"].ToString()),
CityId = int.Parse(SDR["CityId"].ToString()),
};
ListTmp.Add(ObjTmp);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; }
return(ListTmp);
}
public List <Settings> GetAll()
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
System.Collections.Generic.List <Settings> ListTmp = new System.Collections.Generic.List <Settings>();
Settings ObjTmp = null;
DBCon Obj = new DBCon();
try
{
string Query = "SELECT * FROM Settings ";
cmd = new System.Data.SqlClient.SqlCommand(Query, Obj.Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp = new Settings
{
SettingId = SDR.GetInt32(0),
KeyName = SDR.GetString(1),
KeyValue = SDR.GetString(2),
KeyDiscription = SDR.GetString(3),
};
ListTmp.Add(ObjTmp);
}
}
catch (System.Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Obj.Con.Close(); Obj.Con.Dispose(); Obj.Con = null; }
return(ListTmp);
}
protected void btnUpdateDetail2_Click(object sender, EventArgs e)
{
foreach (GridViewRow r in gvOrderDetail.Rows)
{
product.Add(r.Cells[1].Text);
}
List <String> list = new List <string>();
list.Add(this.DDLProductname.SelectedValue.ToString());
list.Add(this.txtUnitDetail.Text);
list.Add(this.txtQuantilyDetail.Text);
list.Add(this.txtDiscountDetail.Text);
try
{
if (product.IndexOf(DDLProductname.SelectedValue.ToString()) != -1)
{
new orderDetail().update(int.Parse(lblOrderID.Text), list);
}
else
{
new orderDetail().insert(int.Parse(lblOrderID.Text), list);
}
}
catch (Exception ex)
{
Response.Write("<script language=\"javascript\">alert(\'" + ex.Message + "\');</script>");
}
System.Data.SqlClient.SqlDataReader dr = (new orderDetail()).searchByID(int.Parse(lblOrderID.Text));
gvOrderDetail.DataSource = dr;
gvOrderDetail.DataBind();
dr.Close();
}
} // GetSourceTypefromFeatureClass
public string GetSourceFeatureClassfromFeatureClass(string FeatureDataset, string FeatureClass)
{
string sqlStatement = null;
System.Data.SqlClient.SqlCommand featureClassCommand = null;
System.Data.SqlClient.SqlDataReader featureClassReader = null;
string featureClassName = null;
// Confirm that there is a valid connection to the database before attempting to query tables in it.
if (!ConnecttoImportMonitorDatabase())
{
// Return an explanation of the process failure.
return("Could not connect to the Import Monitor Database, GetFeatureClassName() FAILED!");
}
try
{
// Build the SQL Statement that will be used to Retrieve the Feature Class Name from the Table.
sqlStatement = "SELECT Input_Dataset_Name "
+ "FROM " + _monitorTableName + " "
+ "WHERE Feature_Class_Name = '" + FeatureClass + "' AND "
+ " ((Feature_Dataset = '" + FeatureDataset + "') OR "
+ " (Old_Feature_Dataset = '" + FeatureDataset + "'))";
// Build the Command Object that will be used to retrieve the Feature Class Name from the Table.
featureClassCommand = new System.Data.SqlClient.SqlCommand();
featureClassCommand.Connection = _importMonitorDatabaseConnection;
featureClassCommand.CommandText = sqlStatement;
// Populate a Data Reader using the Command Object.
featureClassReader = featureClassCommand.ExecuteReader();
// If any information was retrieved, get the Feature Class Name that was retrieved.
if (featureClassReader.HasRows)
{
// Retrieve the data pulled from the Table.
featureClassReader.Read();
// Get the Feature Class Name from the Data Reader.
featureClassName = (string)featureClassReader["Input_Dataset_Name"];
}
// Close the Data Reader.
featureClassReader.Close();
// Return the Feature Class Name to the calling routine. If the name was not found, the returned
// string will be NULL.
return(featureClassName);
}
catch (Exception caught)
{
// Return a message to the calling routine indicating that this process failed.
return("The GetSourceFeatureClassfromFeatureClass() process FAILED with message: " + caught.Message);
}
} // GetSourceFeatureClassfromFeatureClass
protected void Page_Load(object sender, EventArgs e)
{
cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Technetium.mdf;Integrated Security=True;User Instance=True");
//Response.Write(Server.MapPath("Images/Group/abc.jpg"));
if (!IsPostBack)
{
try
{
if (Session["grpid"] == null)
{
Response.Redirect("GroupView.aspx");
return;
}
int grpid = int.Parse(Session["grpid"].ToString());
cn.Open();
cmd = new SqlCommand("Select * From Group_Master WHere Group_Id=" + grpid, cn);
dr = cmd.ExecuteReader();
dr.Read();
txtGrpName.Text = dr["Group_Name"].ToString();
txtDescr.Text = dr["Group_Descr"].ToString();
imgFile.ImageUrl = dr["Group_Image"].ToString();
rblStatus.SelectedValue = dr["Group_Status"].ToString();
dr.Close();
cn.Close();
}
catch (Exception ex)
{
Response.Write("Error : " + ex.Message);
Response.End();
}
}
}
} // GetSourceFeatureClassfromFeatureClass
public string GetLastLoadDatefromFeatureClass(string FeatureDataset, string FeatureClass, string ServerName,
string SDEInstance)
{
string sqlStatement = null;
System.Data.SqlClient.SqlCommand lastLoadDateCommand = null;
System.Data.SqlClient.SqlDataReader lastLoadDateReader = null;
System.DateTime lastLoadDate = System.DateTime.Now;
// Confirm that there is a valid connection to the database before attempting to query tables in it.
if (!ConnecttoImportMonitorDatabase())
{
// Return an explanation of the process failure.
return("Could not connect to the Import Monitor Database, GetLastLoadDatefromFeatureClass() FAILED!");
}
try
{
// Build the SQL Statement that will be used to Retrieve the Last Load Date from the Table.
sqlStatement = "SELECT " + ServerName + "_" + SDEInstance + "_Last_Load_Date "
+ "FROM " + _monitorTableName + " "
+ "WHERE Feature_Class_Name = '" + FeatureClass + "' AND "
+ " ((Feature_Dataset = '" + FeatureDataset + "') OR "
+ " (Old_Feature_Dataset = '" + FeatureDataset + "'))";
// Build the Command Object that will be used to retrieve the Last Load Date from the Table.
lastLoadDateCommand = new System.Data.SqlClient.SqlCommand();
lastLoadDateCommand.Connection = _importMonitorDatabaseConnection;
lastLoadDateCommand.CommandText = sqlStatement;
// Populate a Data Reader using the Command Object.
lastLoadDateReader = lastLoadDateCommand.ExecuteReader();
// If any information was retrieved, get the Last Load Date that was retrieved.
if (lastLoadDateReader.HasRows)
{
// Retrieve the data pulled from the Table.
lastLoadDateReader.Read();
// Get the Last Load Date from the Data Reader.
lastLoadDate = (System.DateTime)lastLoadDateReader[ServerName + "_" + SDEInstance + "_Last_Load_Date"];
}
// Close the Data Reader.
lastLoadDateReader.Close();
// Return the Last Load Date to the calling routine. If the date was not found, the returned
// string will be NULL.
return(lastLoadDate.ToString("d MMMM yyyy"));
}
catch (Exception caught)
{
// Let the user know that this process failed.
return("The GetLastLoadDatefromFeatureClass() Method FAILED with message: " + caught.Message.ToString());
}
} // GetLastLoadDatefromFeatureClass
private void BindDropMsgClass()
{
string classidlist = "";
System.Data.SqlClient.SqlDataReader dr = DBHelper.ExecuteReader(" select a.ID,a.ClassName From MsgClass a,MsgClassAdmin b where a.ID=b.ClassID and b.Admin=@user", new SqlParameter("@user", Session["Company"]), CommandType.Text);
while (dr.Read())
{
ListItem list = new ListItem(dr["ClassName"].ToString(), dr["id"].ToString());
this.DropMsgClass.Items.Add(list);
classidlist += classidlist + ",";
}
ViewState["ClassIDList"] = classidlist.TrimEnd(",".ToCharArray());
if (Request.QueryString["ClassID"] != null)
{
this.DropMsgClass.SelectedValue = Request.QueryString["ClassID"].ToString();
}
dr = DBHelper.ExecuteReader(" select ID,ClassName From MsgClass");
while (dr.Read())
{
ListItem list = new ListItem(dr["ClassName"].ToString(), dr["id"].ToString());
this.DropMsgClass_2.Items.Add(list);
}
dr.Close();
}
protected void Listar_Click(object sender, EventArgs e)
{
string nome;
int idBusca;
ListaNomes.Items.Clear();
if(int.TryParse(textID.Text, out idBusca) == false)
{
lblMensagem.Text = "Campo de busca ID em branco..!";
return;
}
conn.Open();
command = new SqlCommand("SELECT Id, Nome FROM tbPessoa WHERE Id >= @a", conn);
command.Parameters.AddWithValue("@a", idBusca);
reader = command.ExecuteReader();
while(reader.Read())
{
idBusca = reader.GetInt32(0);
nome = reader.GetString(1);
ListItem item = new ListItem(nome, Convert.ToString(idBusca));
ListaNomes.Items.Add(item);
}
reader.Close();
reader.Dispose();
command.Dispose();
conn.Close();
conn.Dispose();
}
private void btnRetrieve_Click(object sender, EventArgs e)
{
try
{
// Store the ConnectionState string
sConnection = "Data Source=RICKLARSEN-PC;Initial Catalog=Customers;Integrated Security=True;Pooling=False";
dbConn = new SqlConnection(sConnection);
dbConn.Open();
// Store the SQL query
sql = "SELECT * FROM Customers ORDER BY LastName ASC, FirstName ASC;";
dbCmd = new SqlCommand();
dbCmd.CommandText = sql;
dbCmd.Connection = dbConn;
// Create a dbReader object.
dbReader = dbCmd.ExecuteReader();
while (dbReader.Read())
{
aMember = new Member
(dbReader["FirstName"].ToString(),
dbReader["LastName"].ToString());
this.lstCustomerNames.Items.Add(aMember);
}
dbReader.Close();
dbConn.Close();
}
catch (System.Exception exc)
{
this.lblErrorMsg.Text = exc.Message;
}
}
public Project(string name, string description, string businessvalue)
{
mName = name;
mDescription = description;
mBusinessValue = businessvalue;
mDatabase.connect();
mReader=mDatabase.executeread("SELECT Description FROM [dbo].[Issues] WHERE ProjectName='" + mName + "'");
while (mReader.Read() )
{
mIssues.Add(new Issue(mReader.GetString(0).ToString(), mName));
}
mReader.Close();
mReader = mDatabase.executeread("SELECT Description, Address FROM [dbo].[Link] WHERE ProjectName='" + mName + "'");
while (mReader.Read() )
{
mLinks.Add(new Link(mReader.GetString(0).ToString(), mName, mReader.GetString(1).ToString()));
}
mReader.Close();
mReader = mDatabase.executeread("SELECT DependantName, [dbo].[Project].Description, [dbo].[Project].BusinessValueName FROM [dbo].[Dependents], [dbo].[Project] WHERE ProjectName='" + mName + "' AND DependantName=Name");
while (mReader.Read() )
{
mDependencies.Add(new Project(mReader.GetString(0).ToString(), mReader.GetString(1).ToString(), mReader.GetString(2).ToString()));
}
mReader.Close();
}
public static bool CodigoExiste(string qryStr)
{
try
{
OpenConection();
command = new SqlCommand(qryStr, conexao);
Reader = command.ExecuteReader();
if(Reader.HasRows)
FlExiste= true;
else
FlExiste= false;
Reader.Close();
}
catch (Exception Ex)
{
throw new Exception(Ex.Message.ToString());
return false;
}
finally
{
CloseConection();
}
return FlExiste;
}
} //{0 city/district 1 means tehsil/TALUKA
public List <City> GetAllByState(int StateId)
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
List <City> ListTmp = new List <City>();
System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString());
Con.Open();
try
{
string Query = "SELECT * FROM City where StateId=" + StateId.ToString() + " ORDER BY Name ASC";
cmd = new System.Data.SqlClient.SqlCommand(Query, Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
City ObjTmp = new City
{
CityId = int.Parse(SDR["CityId"].ToString()),
Name = SDR["Name"].ToString(),
StateId = int.Parse(SDR["StateId"].ToString()),
Type = int.Parse(SDR["Type"].ToString())
};
ListTmp.Add(ObjTmp);
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; }
return(ListTmp);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (refnum.Value == "")
{
MessageBox.Show("Please enter a reference number..");
refnum.Focus();
}
else
{
try
{
cmd = new SqlCommand("select * from bookticketdb where refnum=" + refnum.Value, con);
dr = cmd.ExecuteReader();
dr.Read();
mov = dr["movname"].ToString();
seat = dr["seats"].ToString();
date = dr["movdate"].ToString();
time = dr["movtime"].ToString();
bid = dr["bookid"].ToString();
cost = Convert.ToInt32(dr["cost"].ToString());
dr.Close();
}
catch (Exception err)
{
MessageBox.Show("Followng Error occured :" + err.Message);
}
}
}
internal static bool UserWantsAds(Guid userId)
{
bool userWantsAds = false;
List <string> campaignObjectIds = new List <string>();
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_Filter_AdWords_CheckUser";
sqlConnection.Command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.UniqueIdentifier));
sqlConnection.Command.Parameters["@UserId"].Value = userId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
if (sqlDataReader.Read())
{
if (sqlDataReader["UPD_DisplayAds"] != DBNull.Value)
{
userWantsAds = (bool)sqlDataReader["UPD_DisplayAds"];
}
}
sqlDataReader.Close();
}
finally
{
sqlConnection.Close();
}
return(userWantsAds);
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT MIP_MSG_ID, MSG_NO, MSG_SOURCE, PCA_MSG_ID, ACCOUNTID, RESERVATION, ONLINE_TIME, OFFLINE_TIME, DOPUSH, MSG_KIND_1, MSG_KIND_2, MSG_TITLE, MSG_CONTENT, READ_STATE, READ_TIME, LDATE, REC_STA, PUSHED FROM MIP_MSG_DETAIL WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_mIP_MSG_ID = reader.GetInt32(0);
_mSG_NO = reader.GetInt32(1);
_mSG_SOURCE = reader.GetString(2);
_pCA_MSG_ID = reader.GetString(3);
_aCCOUNTID = reader.GetString(4);
_rESERVATION = reader.GetString(5);
_oNLINE_TIME = reader.GetDateTime(6);
_oFFLINE_TIME = reader.GetDateTime(7);
_dOPUSH = reader.GetString(8);
_mSG_KIND_1 = reader.GetString(9);
_mSG_KIND_2 = reader.GetString(10);
_mSG_TITLE = reader.GetString(11);
_mSG_CONTENT = reader.GetString(12);
_rEAD_STATE = reader.GetString(13);
_rEAD_TIME = reader.GetDateTime(14);
_lDATE = reader.GetDateTime(15);
_rEC_STA = reader.GetString(16);
_pUSHED = reader.GetInt32(17);
}
reader.Close();
}
}
public static bool ExecCmd(string cmd, DataTable data)
{
bool result = false;
try
{
cmdSql.CommandType = CommandType.Text;
cmdSql.CommandText = cmd;
cmdSql.Connection = conSql;
conSql.Open();
readerSql = cmdSql.ExecuteReader();
data.Load(readerSql);
readerSql.Close();
result = true;
}
catch (Exception ex)
{
//MessageBox.Show("error ExecPsParams: " + ex.Message);
result = false;
}
finally
{
conSql.Close();
}
//return result;
return false;
}
public City GetOne(int Cityid)
{
System.Data.SqlClient.SqlCommand cmd = null;
System.Data.SqlClient.SqlDataReader SDR = null;
City ObjTmp = new City();
System.Data.SqlClient.SqlConnection Con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ToString());
Con.Open();
try
{
string Query = "SELECT TOP 1 * FROM City where CityId=" + Cityid.ToString();
cmd = new System.Data.SqlClient.SqlCommand(Query, Con);
SDR = cmd.ExecuteReader();
while (SDR.Read())
{
ObjTmp.CityId = int.Parse(SDR["CityId"].ToString());
ObjTmp.Name = SDR["Name"].ToString();
ObjTmp.StateId = int.Parse(SDR["StateId"].ToString());
ObjTmp.Type = int.Parse(SDR["Type"].ToString());
}
}
catch (Exception e) { e.ToString(); }
finally { cmd.Dispose(); SDR.Close(); Con.Close(); Con.Dispose(); Con = null; }
return(ObjTmp);
}
//Public Shared Function GetAllKursusDeltagerList() As DataSet
// Dim db As DBAccess = New DBAccess
// Dim ds As DataSet = db.ExecuteDataSet(_SQLSelectAllList)
// Return ds
//End Function
public static System.Collections.Generic.List <KursusDeltager> GetAllKursusDeltagerDagList(int KursusDagID)
{
System.Collections.Generic.List <KursusDeltager> result = new System.Collections.Generic.List <KursusDeltager>();
int ID = -1;
DBAccess db = new DBAccess();
db.AddInt("KursusDagID", KursusDagID);
System.Data.SqlClient.SqlDataReader dr = default(System.Data.SqlClient.SqlDataReader);
try
{
dr = (System.Data.SqlClient.SqlDataReader)(db.ExecuteReader(_SQLSelectIDAllDagList));
if (dr.HasRows)
{
while (dr.Read())
{
ID = System.Convert.ToInt32(dr.DBtoInt("ID"));
KursusDeltager kurist = KursusDeltager.GetKursusDeltager(ID);
if (kurist != null && kurist.isLoaded)
{
result.Add(kurist);
}
}
}
dr.Close();
}
catch (Exception ex)
{
throw (ex);
}
return(result);
}
public void actualizador()
{
conexion.ConnectionString = cadena_conexion;
conexion.Open();
Consulta = "select * from plantas";
comando.Connection = conexion;
comando.CommandText = Consulta;
Lector = comando.ExecuteReader();
int cantidades_de_registros = 0;
Datos = new Plantas[30];
while (Lector.Read() == true)
{
Herbarios = new Plantas();
Herbarios.Codigo = Convert.ToInt32(Lector["COD_PLANTA"]);
Herbarios.Descripcion = Convert.ToString(Lector["DESCRIPCION"]);
Herbarios.CodigoPlanta = Convert.ToInt32(Lector["COD_TIPO_PLANTA"]);
Herbarios.Precio = Convert.ToDouble(Lector["PRECIO"]);
Herbarios.Stock = Convert.ToInt32(Lector["STOCK"]);
Herbarios.Clima = Convert.ToString(Lector["clima"]);
Datos[cantidades_de_registros] = Herbarios;
lstMostrador.Items.Add(Datos[cantidades_de_registros].toString());
cantidades_de_registros++;
}
conexion.Close();
Lector.Close();
}
public Listado()
{
InitializeComponent();
textBoxUser.Focus();
consulta = "select distinct descripcion from GESTION_DE_GATOS.TiposDoc";
resultado = Home.BD.comando(consulta);
while (resultado.Read() == true)
{
comboBoxTipoDoc.Items.Add(resultado.GetSqlString(0));
}
resultado.Close();
consulta = "select nombre from GESTION_DE_GATOS.Hotel";
resultado = Home.BD.comando(consulta);
while (resultado.Read() == true)
{
comboBoxHotel.Items.Add(resultado.GetSqlString(0));
}
resultado.Close();
consulta = "select descripcion from GESTION_DE_GATOS.Rol";
resultado = Home.BD.comando(consulta);
while (resultado.Read() == true)
{
comboBoxRol.Items.Add(resultado.GetSqlString(0));
}
resultado.Close();
dateTimePicker1.Value = Home.fecha;
}
public void cerrarDataReader(SqlDataReader pDataReader)
{
if (pDataReader != null && !pDataReader.IsClosed)
{
pDataReader.Close();
}
}
public DataTable executarReader(String sqlCmd, SqlParameter[] sqlParams)
{
DataTable returnTable = new DataTable("returnTable");
associarComando(sqlCmd);
_SqlCommand.CommandType = CommandType.Text;
if (sqlParams != null)
_SqlCommand.Parameters.AddRange(sqlParams);
abrirLigacao();
if (_SqlConn.State == ConnectionState.Open)
{
_SqlReader = _SqlCommand.ExecuteReader();
returnTable.Load(_SqlReader);
_SqlReader.Close();
}
fecharLigacao();
_SqlCommand.Parameters.Clear();
return returnTable;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT HAPPY_ID, CSTATUS, FILE_KIND, APPLY_TARGET, CKEY1, CKEY2, CKEY3, TITLE, URL, F_IDX, F_NAME, CORDER, LDATE, LUSER, SELECTALL, ISTESTER, ONLINE_TIME, OFFLINE_TIME FROM MIP_HAPPY WHERE HAPPY_ID=@HAPPY_ID_PARAM";
cmd.Parameters.AddWithValue("@HAPPY_ID_PARAM", _hAPPY_ID);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_hAPPY_ID = reader.GetInt32(0);
_cSTATUS = reader.GetInt32(1);
_fILE_KIND = reader.GetInt32(2);
_aPPLY_TARGET = reader.GetInt32(3);
_cKEY1 = reader.GetString(4);
_cKEY2 = reader.GetString(5);
_cKEY3 = reader.GetString(6);
_tITLE = reader.GetString(7);
_uRL = reader.GetString(8);
_f_IDX = reader.GetInt32(9);
_f_NAME = reader.GetString(10);
_cORDER = reader.GetInt32(11);
_lDATE = reader.GetDateTime(12);
_lUSER = reader.GetString(13);
_sELECTALL = reader.GetInt32(14);
_iSTESTER = reader.GetInt32(15);
_oNLINE_TIME = reader.GetDateTime(16);
_oFFLINE_TIME = reader.GetDateTime(17);
}
reader.Close();
}
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT version, sqltype, file_desc, fileUploadOldName, fileUploadNewName, datetime, version_no, imageData FROM userUploadLog WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_version = reader.GetInt32(0);
_sqltype = reader.GetInt32(1);
_file_desc = reader.GetString(2);
_fileUploadOldName = reader.GetString(3);
_fileUploadNewName = reader.GetString(4);
_datetime = reader.GetDateTime(5);
_version_no = reader.GetString(6);
//_imageData = reader.GetBytes(7);
_imageData = (byte[])reader[7];
}
reader.Close();
}
}
public object RetrieveAll(Type type)
{
List <CustomerProps> list = new List <CustomerProps>();
DBDataReader reader = null;
CustomerProps props;
try
{
reader = RunProcedure("usp_CustomerSelectAll");
if (!reader.IsClosed)
{
while (reader.Read())
{
props = new CustomerProps();
props.SetState(reader);
list.Add(props);
}
}
return(list);
}
catch (Exception e)
{
// log this exception
throw e;
}
finally
{
if (!reader.IsClosed)
{
reader.Close();
}
}
}
public string getEntidades()
{
try
{
List<entidad> entidades = new List<entidad>();
cnx = new cnx();
rdr = cnx.ExecuteCommand("select trc.VALOR, trc.ID_ENTIDAD, tcent.NOM_ENT,tcent.NOM_ABR from TR_CIFRA trc,TC_ENTIDAD_FEDERATIVA tcent where ID_FUENTE=2 and ID_VARIABLE=15 and ANIO=2014 and ID_TIPO_DATO=7 and ID_PERIODICIDAD=4 and trc.ID_ENTIDAD=tcent.ID_ENTIDAD order by trc.ID_ENTIDAD", CommandType.Text);
if (rdr.HasRows)
{
while (rdr.Read())
{
entidad ent = new entidad()
{
id_entidad = rdr["ID_ENTIDAD"].ToString(),
valor = rdr["VALOR"].ToString(),
nombre = rdr["NOM_ENT"].ToString(),
nombre_abr = rdr["NOM_ABR"].ToString()
};
entidades.Add(ent);
}
rdr.Close();
rdr = null;
string data = JsonConvert.SerializeObject(entidades);
return data;
}
}
catch (Exception)
{
throw;
}
return "";
}
public int clienteRegistrado( string Tipo_ID, int Numero_ID)
{
con1.cnn.Open();
int contador = 0;
try
{
string query = "SELECT id_tipo_doc, num_doc FROM LPP.CLIENTES WHERE id_tipo_doc = (SELECT tipo_cod FROM LPP.TIPO_DOCS WHERE tipo_descr = '" + Tipo_ID + "') AND num_doc = " + Numero_ID + "";
SqlCommand command = new SqlCommand(query, con1.cnn);
dr = command.ExecuteReader();
while (dr.Read())
{
contador++;
}
dr.Close();
}
catch (Exception )
{
con1.cnn.Close();
return contador;
}
con1.cnn.Close();
//MessageBox.Show("El Cliente ya existe");
return 0;
}
/// <summary>
///
/// </summary>
public void Load(System.Data.SqlClient.SqlConnection connection)
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.Connection = connection;
cmd.CommandText = "SELECT logID, deviceid, phonetype, webservicenode, webservicemethod, webserviceparams, serverReturnData, sCreateDatetime, sRequestDatetime, webserviceparamsDecode, statuscode, ID, user_type, version FROM WebserviceLog WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_logID = reader.GetString(0);
_deviceid = reader.GetString(1);
_phonetype = reader.GetString(2);
_webservicenode = reader.GetString(3);
_webservicemethod = reader.GetString(4);
_webserviceparams = reader.GetString(5);
_serverReturnData = reader.GetString(6);
_sCreateDatetime = reader.GetDateTime(7);
_sRequestDatetime = reader.GetDateTime(8);
_webserviceparamsDecode = reader.GetString(9);
_statuscode = reader.GetInt32(10);
_iD = reader.GetString(11);
_user_type = reader.GetString(12);
_version = reader.GetString(13);
}
reader.Close();
}
}
