public static List<Club> readTable(string SqlQuery, string serverName, string databaseName)
{
myConnection = new SqlConnection(serverName + ";" + databaseName + ";" + "Integrated Security=true");
try
{
myConnection.Open();
myCommand = new SqlCommand(SqlQuery, myConnection);
myReader = myCommand.ExecuteReader();
ClubList.Clear();
while(myReader.Read()) {
//Console.WriteLine(myReader[0].ToString());
//code here to map query output to club objects and put into list
ClubList.Add(new Club
{
id = myReader[0].ToString(),
//name = myReader[1].ToString(),
//address = myReader[2].ToString(),
//city = myReader[3].ToString(),
//state = myReader[4].ToString()
});
}
} catch (Exception e) {
Console.WriteLine(e.ToString());
}
finally
{
myConnection.Close();
}
return ClubList;
}
private void button1_Click(object sender, EventArgs e)
{
listView1.Items.Clear();
CN = new SqlConnection(cadenaconexion);
CMD = new SqlCommand("SELECT * FROM Prueba", CN);
CMD.CommandType = CommandType.Text;
try
{
CN.Open();
RDR = CMD.ExecuteReader();
while (RDR.Read())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = (string)RDR["id"].ToString();
lvi.SubItems.Add((string)RDR["nombre"]);
listView1.Items.Add(lvi);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
CN.Close();
}
}
// Apresentar os registros da pesquisa desejada.
public void loadlist()
{
listBox1.Items.Clear();
listBox2.Items.Clear();
listBox3.Items.Clear();
listBox4.Items.Clear();
listBox5.Items.Clear();
listBox6.Items.Clear();
listBox7.Items.Clear();
conexao.Open();
comando.CommandText = "SELECT * FROM Contatos";
LerDados = comando.ExecuteReader();
if (LerDados.HasRows)
{
while (LerDados.Read())
{
listBox1.Items.Add(LerDados[0].ToString());
listBox2.Items.Add(LerDados[1].ToString());
listBox3.Items.Add(LerDados[2].ToString());
listBox4.Items.Add(LerDados[3].ToString());
listBox5.Items.Add(LerDados[4].ToString());
listBox6.Items.Add(LerDados[5].ToString());
listBox7.Items.Add(LerDados[6].ToString());
}
}
conexao.Close();
}
public List<List<String>> convert(SqlDataReader reader)
{
if (reader != null)
{
List<List<String>> list = new List<List<String>>();
while (reader.Read())
{
List<String> tmp = new List<String>();
for (int i = 0; i < reader.FieldCount; i++)
{
string s = "";
try
{
s = reader.GetString(i);
}
catch (SqlNullValueException)
{
s = "null";
}
tmp.Add(s);
}
list.Add(tmp);
}
return list;
}
return null;
}
public static YellowstonePathology.Business.ClientOrder.Model.ClientOrder BuildClientOrder(SqlDataReader dr)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = null;
Nullable<int> panelSetId = null;
while (dr.Read())
{
if (dr["PanelSetId"] != DBNull.Value)
{
panelSetId = Convert.ToInt32(dr["PanelSetId"].ToString());
}
}
clientOrder = YellowstonePathology.Business.ClientOrder.Model.ClientOrderFactory.GetClientOrder(panelSetId);
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrder, dr);
propertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, dr);
propertyWriter.WriteProperties();
clientOrder.ClientLocation = clientLocation;
}
return clientOrder;
}
public static void Convert(ShapefileGeometryType type, SqlDataReader reader, string shapefile)
{
if (!reader.Read())
throw new Exception("No Results found");
int geomOrdinal, colCount;
ShapefileHeader shapeHeader = ShapefileHeader.CreateEmpty(type);
DbfHeader dbfHeader = BuildHeader(reader, out geomOrdinal, out colCount);
GeometryFactory factory = new GeometryFactory();
Envelope env = shapeHeader.Bounds;
using (ShapefileDataWriter writer = ShapefileDataWriter.Create(shapefile, dbfHeader, shapeHeader))
{
do
{
SqlGeometry geom = reader[geomOrdinal] as SqlGeometry;
if (!geom.STIsValid())
geom = geom.MakeValid();
for (int i = 0, offset = 0; i < colCount; i++)
{
if (i == geomOrdinal)
offset++;
writer.Record.SetRaw(i, reader[i + offset]);
}
ExpandEnv(env, geom.STBoundary());
writer.Write(ConvertToGeometry.SqlGeometryToGeometry(geom, factory));
}
while (reader.Read());
}
}
protected override Exception ProcessSqlResult(SqlDataReader reader)
{
Exception nextResultSet = StoreUtilities.GetNextResultSet(base.InstancePersistenceCommand.Name, reader);
if (nextResultSet == null)
{
reader.NextResult();
List<IDictionary<XName, object>> parameters = new List<IDictionary<XName, object>>();
if (reader.Read())
{
do
{
IDictionary<XName, object> item = new Dictionary<XName, object>();
item.Add(WorkflowServiceNamespace.SiteName, reader.GetString(0));
item.Add(WorkflowServiceNamespace.RelativeApplicationPath, reader.GetString(1));
item.Add(WorkflowServiceNamespace.RelativeServicePath, reader.GetString(2));
parameters.Add(item);
}
while (reader.Read());
}
else
{
base.Store.UpdateEventStatus(false, InstancePersistenceEvent<HasActivatableWorkflowEvent>.Value);
base.StoreLock.InstanceDetectionTask.ResetTimer(false);
}
base.InstancePersistenceContext.QueriedInstanceStore(new ActivatableWorkflowsQueryResult(parameters));
}
return nextResultSet;
}
public static Collection<Post> CreatePostsFromReader(SqlDataReader reader)
{
// First result set is the postcategories.
Dictionary<int, Category> postcats = new Dictionary<int, Category>();
if (reader.HasRows)
{
while (reader.Read())
{
// Oops - key can't be PostId as key has to be unique. Need to use a different collection..
// .. for now, make a hash of the post and category IDs.
int categoryId = Convert.ToInt32(reader["categoryId"]);
int postHash = (Convert.ToInt32(reader["PostId"]) * 10000) + categoryId;
postcats.Add(postHash, new Category(categoryId, Convert.ToString(reader["Name"]), Convert.ToString(reader["Slug"])));
}
}
// Second resultset is the post(s)
reader.NextResult();
Collection<Post> postlist = new Collection<Post>();
if (reader.HasRows)
{
while (reader.Read())
{
Post p = new Post();
p.Id = Convert.ToInt32(reader["Id"]);
p.Title = Convert.ToString(reader["Title"]);
p.Postdate = Convert.ToDateTime(reader["PostDate"]);
p.Body = Convert.ToString(reader["Body"]);
p.Slug = Convert.ToString(reader["Slug"]);
p.CommentCount = Convert.ToInt32(reader["CommentCount"]);
p.Published = Convert.ToBoolean(reader["Published"]);
p.Categories = new Collection<Category>();
// .. then the categories.
IEnumerable<Category> cats =
from entry in postcats
where ((entry.Key / 10000) == p.Id)
select entry.Value;
foreach (Category cat in cats)
{
p.Categories.Add(cat);
}
postlist.Add(p);
}
}
return postlist;
}
private void loadgrid()
{
//sql = "select * from tbl_reg"
//If rs.State = 1 Then rs.Close()
//rs.Open(sql, conn)
DataGridView1.Rows.Clear();
cn.Open();
cmd.CommandText = "select * from tbl_streg where (sport = N'CRICKET')";
int i;
i = 0;
//Do While Not rs.EOF
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
DataGridView1.Rows.Add();
DataGridView1.Rows[i].Cells[0].Value = dr[0];
DataGridView1.Rows[i].Cells[1].Value = dr[1];
DataGridView1.Rows[i].Cells[2].Value = dr[2];
DataGridView1.Rows[i].Cells[3].Value = dr[3];
DataGridView1.Rows[i].Cells[4].Value = dr[4];
DataGridView1.Rows[i].Cells[5].Value = dr[5];
DataGridView1.Rows[i].Cells[6].Value = dr[6];
i = i + 1;
}
}
cn.Close();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtSkillHead.Text.Trim() == "") // Cannot be blank
{
lblMessage.Text = "Field can't be blank";
}
else
{
query = "select Head from SkillHead where Head='" + txtSkillHead.Text + "'";
reader = db.data_read(query);
if (reader.Read())
{
lblMessage.Text = "Skill Head already exists";
}
else
{
query = "insert into SkillHead (Id,Head) values ('" + AutoGeneration() + "','" + txtSkillHead.Text + "')";
db.database_command(query);
txtSkillHead.Text = "";
lblMessage.Text = "Skill head added";
}
}
}
catch (Exception ex)
{
}
}
public RoadMap(string name )
{
mName = name;
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Timestamp, Description, UserID FROM [dbo].[Roadmap] WHERE Name = '" + name + "'");
mReader.Read();
mTimeStamp = mReader.GetDateTime(0);
mDescription = mReader.GetString(1);
string UID = mReader.GetString(2);
mDatabase.close();
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Name, Email, Password FROM [dbo].[User] WHERE ID = '" + UID + "'");
mReader.Read();
mUser = new User(mReader.GetString(0), UID, mReader.GetString(1), mReader.GetString(2));
mDatabase.close();
mTimeline = new TimeLine(mName);
//Get the StrategyPoints
mDatabase.connect();
mReader = mDatabase.executeread("SELECT Name, Description FROM [dbo].[StrategyPoint] WHERE RoadmapName = '" + name + "'");
while (mReader.Read())
{
StrategyPoint sp = new StrategyPoint(mReader.GetString(0), mReader.GetString(1));
mStrategyPoints.Add(sp);
}
mDatabase.close();
}
/// <summary>
/// lay bang cong ty
/// </summary>
/// <param name="ct"></param>
/// <returns></returns>
public Entities.ThongTinCongTy sp_ThongTinCongTy(Entities.TruyenGiaTri ct)
{
Entities.ThongTinCongTy banghi = new Entities.ThongTinCongTy();
try
{
string sql = "exec sp_ThongTinCongTy @MaCongTy";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaCongTy", SqlDbType.VarChar, 20).Value = ct.Giatritruyen;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
ArrayList arr = new ArrayList();
while (dr.Read())
{
banghi.MaCongTy = dr[0].ToString();
banghi.TenCongTy = dr[1].ToString();
banghi.DiaChi = dr[2].ToString();
banghi.SoDienThoai = dr[3].ToString();
banghi.Email = dr[4].ToString();
banghi.Website = dr[5].ToString();
banghi.Fax = dr[6].ToString();
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); banghi = null; }
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return banghi;
}
protected void Page_Load(object sender, EventArgs e)
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["devi"].ToString());
con.Open();
cmd = new SqlCommand("select * from user1_reg where lid='" + Session["usr"].ToString() + "'");
cmd.Connection = con;
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label1.Text = "<img src='userfig/"+dr[11].ToString()+"' width='100' height='150' /><br />Welcome " + dr[1].ToString();
}
con.Close();
con.Open();
string fid = Request.QueryString["fid"].ToString();
cmd = new SqlCommand("select * from cloud_data where id='"+fid+"'");
cmd.Connection = con;
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label3.Text = dr[2].ToString();
TextBox3.Text = dr[3].ToString();
TextBox4.Text = dr[5].ToString();
TextBox5.Text = dr[7].ToString();
TextBox6.Text = dr[9].ToString();
}
con.Close();
}
public int countRows(int tipoUsuario)
{
Cmd = new SqlCommand();
Cmd.Connection = Conn;
int total_rows = 0;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "[otaku_bcp].PA_COUNT_ROWS_TYPE_USER";
Cmd.Parameters.Add("@IdType", SqlDbType.Int).Value = tipoUsuario;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
total_rows = Convert.ToInt32(Dtr["total_rows"]);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return total_rows;
}
private static void sendEachRecordOfData(SqlDataReader dataReader, SqlMetaData[] meta)
{
while (dataReader.Read())
{
SqlContext.Pipe.SendResultsRow(createRecordPopulatedWithData(dataReader, meta));
}
}
// CHECK IF SALES PERSON EXIST IN DATBASE
public static string CheckSalesPersonLogIn(SqlDataReader dr)
{
bool noExist = true;
bool isActive = true;
string clear = null;
while (dr.Read())
{
clear = dr.GetString(0);
isActive = dr.GetBoolean(5);
noExist = false;
}
if (!isActive)
{
MessageBox.Show("Sorry, you are fired!", "LOL", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
else if (noExist)
{
MessageBox.Show("Not in the register.", "Unregistered Sales Person", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
else
{
return clear;
}
}
/// <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���������
}
protected void Page_Load(object sender, EventArgs e)
{
string idtiket = Request.QueryString["tiketid"];
userconnection = new SqlConnection();
userconnection.ConnectionString = @"Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aviation.mdf;Trusted_Connection=True;User Instance=True";
usercommand = new SqlCommand();
usercommand.Connection = userconnection;
usercommand.CommandText = "SELECT * FROM application WHERE id=@id";
usercommand.Parameters.Clear();
usercommand.Parameters.AddWithValue("@id", idtiket);
try
{
userconnection.Open();
userreader = usercommand.ExecuteReader();
if (userreader.Read())
{
Response.ContentType = userreader["MIME"].ToString();
Response.BinaryWrite((byte[])userreader["BinaryData"]);
}
}
catch (SqlException ex)
{
}
finally
{
userconnection.Close();
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
query = "select Sid from State where SName='" + drpState.SelectedItem.ToString() + "'";
reader = db.data_read(query);
if (reader.Read())
{
sid = reader.GetString(0);
}
query = "select CIName from City where CIName='" + txtCity.Text + "' AND StateId='" + sid + "'";
reader = db.data_read(query);
if (reader.Read())
{
lblMessage.Text = "City already exists";
}
else
{
query = "insert into City (CityId,CIName,StateId) values ('" + AutoGeneration() + "','" + txtCity.Text + "','" + sid + "')";
db.database_command(query);
txtCity.Text = "";
}
}
catch (Exception ex)
{
}
}
private void btnPreview_Click(object sender, EventArgs e)
{
double debit =0,credit = 0;
try
{
string sql2 = "select * from GeneralLagerRpt where VocDate between '" + dpTo.Value.ToString("yyyy-MM-dd") + "' and '" + dpFrom.Value.ToString("yyyy-MM-dd") + "' order by SortBy";
reader = db.selectQuery(sql2);
Grid.Rows.Clear();
while (reader.Read())
{
Grid.Rows.Add(reader["VocType"] + "-" + reader["VocNo"], Convert.ToDateTime(reader["VocDate"]).ToString("dd-MM-yyyy"), reader["Narration"], String.Format("{0:0.00}",reader["Debit"]), String.Format("{0:0.00}",reader["Credit"]));
credit = credit + Convert.ToDouble(reader["Credit"]);
debit = debit + Convert.ToDouble(reader["Debit"]);
}
for (int a = 0; a <= Grid.RowCount - 1; a++)
{
if (a % 2 != 0)
{
Grid.Rows[a].DefaultCellStyle.BackColor = Color.WhiteSmoke;
}
}
txtCredit.Text = String.Format("{0:0.00}",credit);
txtdebit.Text = String.Format("{0:0.00}",debit);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public List<Columns> GetColoumns(string tableName,string dbName)
{
List<Columns> allColoumns = new List<Columns>();
string database = "USE " + dbName;
try
{
GetSqlConn.Open();
commandString = string.Format(database+" select COLUMN_NAME,DATA_TYPE from information_schema.columns where table_name = @tableName");
GetSqlCommand.CommandText = commandString;
GetSqlCommand.Parameters.Clear();
GetSqlCommand.Parameters.Add("@tableName", SqlDbType.NVarChar);
GetSqlCommand.Parameters["@tableName"].Value = tableName;
getData = GetSqlCommand.ExecuteReader();
while (getData.Read())
{
Columns aColoumn = new Columns();
aColoumn.ColName = getData["COLUMN_NAME"].ToString();
aColoumn.DataType = getData["DATA_TYPE"].ToString();
allColoumns.Add(aColoumn);
}
}
catch (Exception exp)
{
throw new Exception("Error while fetching data" + exp);
}
finally
{
GetSqlConn.Close();
}
return allColoumns;
}
private StringBuilder LireSQL(SqlDataReader dataR1)
{
StringBuilder BLD = new StringBuilder();
BLD.Append("<table style='background-color: #0066ff; color: white; width: 100%' class='tabProduits'><tr>");
for (int i = 0; i < dataR1.FieldCount; i++)
{
BLD.Append("<th style='background-color: black'>" + dataR1.GetName(i) + "</th>");
}
BLD.Append("<tr>");
while (dataR1.Read())
{
BLD.Append("<tr>");
for (int i = 0; i < dataR1.FieldCount; i++)
{
BLD.Append("<th>" + dataR1[i] + "</th>");
}
BLD.Append("</tr>");
}
BLD.Append("</table>");
return BLD;
}
public List<Tables> GetAllDBTables(string databaseName)
{
List<Tables> allTable = new List<Tables>();
try
{
string query = "USE " + databaseName;
GetSqlConn.Open();
commandString = string.Format(query+" SELECT TABLE_NAME AS Table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'");
GetSqlCommand.CommandText = commandString;
GetSqlCommand.Parameters.Clear();
getData = GetSqlCommand.ExecuteReader();
while (getData.Read())
{
Tables aTable = new Tables();
aTable.TableName = getData["Table_name"].ToString();
allTable.Add(aTable);
}
}
catch (Exception exp)
{
throw new Exception("Error while fetching data" + exp);
}
finally
{
GetSqlConn.Close();
}
return allTable;
}
protected void Page_Load(object sender, EventArgs e)
{
s_connection = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\user\Desktop\MyRentalService\RentalService\App_Data\RentalDB.mdf;Integrated Security=True";
sql_cn = new SqlConnection(s_connection);
ds = new DataSet();
if (Session["MID"] != null)//確認Session內是否存在MID
{
s_MID = Session["MID"].ToString();//取出MID
if (!IsPostBack)
{
try
{
sql_cn.Open();
s_sql_query = "SELECT * FROM Member WHERE Member.MID = " + s_MID;//取出該MID會員資料的SQL Query
sql_cmd = new SqlCommand(s_sql_query, sql_cn);
sql_dr = sql_cmd.ExecuteReader();
sql_dr.Read();
L_test.Text = "Welcome " + sql_dr["UserName"];//將會員名稱加入歡迎標語
sql_cn.Close();
}
catch (Exception excp)
{
L_test.Text = excp.ToString();
}
}
}
else
if (Session["MID"] == null)
{
Response.Redirect("Login.aspx");
}
}
public List<ModeloNegocio.MicroredSchool> getAllMicroredSchoolForIdMicrored(int idMicrored)
{
List<ModeloNegocio.MicroredSchool> lista = new List<ModeloNegocio.MicroredSchool>();
Cmd = new SqlCommand();
Cmd.Connection = Conn;
try
{
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "PA_GET_MICRORED_SCHOOL_FOR_MICRORED_ID";
Cmd.Parameters.Add("@microred_id", SqlDbType.Int).Value = idMicrored;
Dtr = Cmd.ExecuteReader();
while (Dtr.Read())
{
ModeloNegocio.MicroredSchool microredSchool = new ModeloNegocio.MicroredSchool();
microredSchool.Id = Convert.ToInt32(Dtr["id"]);
microredSchool.School_id = Convert.ToInt32(Dtr["school_id"]);
microredSchool.Microred_id = Convert.ToInt32(Dtr["microred_id"]);
if (DBNull.Value.Equals(Dtr["created_at"])) microredSchool.Created_at = DateTime.Now ; else microredSchool.Created_at = DateTime.Parse(Dtr["created_at"].ToString());
if (DBNull.Value.Equals(Dtr["updated_at"])) microredSchool.Updated_at = DateTime.Now ; else microredSchool.Updated_at = DateTime.Parse(Dtr["updated_at"].ToString());
lista.Add(microredSchool);
}
Conn.Close();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return lista;
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == 0)
{
//generar facturacion
consulta = "EXEC GESTION_DE_GATOS.registrarCheckoutEstadia ";
consulta = consulta + dataGridView1.CurrentRow.Cells[1].Value.ToString();
consulta = consulta + ",'" + Home.fecha.Date.ToString("yyyyMMdd HH:mm:ss") + "',";
consulta = consulta + Login.HomeLogin.idUsuario;
resultado = Home.BD.comando(consulta);
resultado.Read();
if (resultado.GetDecimal(0) == 1)
{
resultado.Close();
//aca va lo de facturacion
Facturar_Estadia.Facturacion factu = new FrbaHotel.Facturar_Estadia.Facturacion(dataGridView1.CurrentRow.Cells[1].Value.ToString());
MessageBox.Show("El checkout se ha realizado correctamente. Se procede a la facturacion");
factu.Show();
}
else
{
resultado.Close();
MessageBox.Show("El checkout no se pudo realizar correctamente");
}
this.Close();
}
}
public SqlDataReader RetDataReader(string sql)
{
SqlCommand comando = new SqlCommand(sql, Con);
Dr = comando.ExecuteReader();
Dr.Read();
return Dr;
}
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;
}
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();
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(FullPrepaymentPenaltyOptionTypes fullprepaymentpenaltyoptiontypes, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
FullPrepaymentPenaltyOptionType newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(fullprepaymentpenaltyoptiontypes.ContainsType[0]) as FullPrepaymentPenaltyOptionType;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
fullprepaymentpenaltyoptiontypes.Add(newobj);
}
}
/// <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 FROM MobileDeviceDataPublic 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);
}
reader.Close();
}
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(FNMCommunityLendingProductTypes fnmcommunitylendingproducttypes, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
FNMCommunityLendingProductType newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(fnmcommunitylendingproducttypes.ContainsType[0]) as FNMCommunityLendingProductType;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
fnmcommunitylendingproducttypes.Add(newobj);
}
}
public double GetByYear(int year)
{
double all = 0;
List <Receipt> ReceiptList = new List <Receipt>();
Dao dao = new Dao();
try
{
string sqlStatement = "SELECT SUM(Total) FROM Receipt where FORMAT(PrintDate,'yyyy')= '" + year + "'";
System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement);
if (reader.Read())
{
all = (double)reader.GetDecimal(0);
}
}
catch (Exception e)
{
return(0);
}
dao.Con.Close();
return(all);
}
public int queryChannelMax()
{
SqlCommand sqlcmd = new SqlCommand();
Tools.DataBase db1 = new Tools.DataBase();
SqlConnection sqlcon = db1.getConnection();
sqlcon.Open();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "select max(TS_CHANNEL) as channelMax from TS_DEVICE";
System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader();
if (SDR.HasRows)
{
SDR.Read();
max = Convert.ToInt32(SDR["channelMax"]);
}
sqlcmd.Dispose();
sqlcon.Dispose();
max = max + 1;
return(max);
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(Dependents dependents, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
Dependent newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(dependents.ContainsType[0]) as Dependent;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
dependents.Add(newobj);
}
}
public static List <Productor> BuscarTodos()
{
List <Productor> lProductor = new List <Productor>();
using (SqlConnection conn = BDConnection.obtenerCnx())
{
SqlCommand comando = new SqlCommand(String.Format("Select * From Productor"), conn);
System.Data.SqlClient.SqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
Productor productor = new Productor();
productor.id = Int32.Parse(reader["id"].ToString());
productor.nombre = reader["nombre"].ToString();
productor.telefono = reader["telefono"].ToString();
productor.email = reader["email"].ToString();
productor.fincas = Int32.Parse(reader["fincas"].ToString());
lProductor.Add(productor);
}
}
return(lProductor);
}
/// <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 SecureKey, AccounID, LoginType, IPAddress, CreateDatetime, UsedDatetime, IsUsed FROM SecurityUserAccount_SecureKey WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_secureKey = reader.GetString(0);
_accounID = reader.GetString(1);
_loginType = reader.GetInt32(2);
_iPAddress = reader.GetString(3);
_createDatetime = reader.GetDateTime(4);
_usedDatetime = reader.GetDateTime(5);
_isUsed = reader.GetInt32(6);
}
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 SysModID, ModuleDesc, iOrder, isDefault, PageLink, Pic, iDisplay FROM SystemModule WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_sysModID = reader.GetString(0);
_moduleDesc = reader.GetString(1);
_iOrder = reader.GetInt32(2);
_isDefault = reader.GetInt32(3);
_pageLink = reader.GetString(4);
_pic = reader.GetString(5);
_iDisplay = reader.GetInt32(6);
}
reader.Close();
}
}
public IEnumerable <MISNewOthersTEMP> MISNewOthersTEMPusingparams(string status, string search)
{
List <MISNewOthersTEMP> obuList = new List <MISNewOthersTEMP>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
cmd.CommandText = "select top 500 Id, State, Teamname, new_mis, old_mis, Accountofficer_code, ApprovalStatus from mis_new_others_TEMPTEMP " +
"where ApprovalStatus=@STATUS and (Teamname like @searchval OR new_mis like @searchval OR old_mis like @searchval)";
cmd.Parameters.AddWithValue("@STATUS", status);
cmd.Parameters.AddWithValue("@searchval", "%" + search + "%");
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new MISNewOthersTEMP();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.State = reader["State"] != DBNull.Value ? reader["State"].ToString() : "";
obu.Teamname = reader["Teamname"] != DBNull.Value ? reader["Teamname"].ToString() : "";
obu.new_mis = reader["new_mis"] != DBNull.Value ? reader["new_mis"].ToString() : "";
obu.old_mis = reader["old_mis"] != DBNull.Value ? reader["old_mis"].ToString() : "";
obu.Accountofficer_code = reader["Accountofficer_code"] != DBNull.Value ? reader["Accountofficer_code"].ToString() : "";
obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : "";
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
static public string SelectRowsByCategory(int User_id)
{
using (var command = new QC.SqlCommand())
{
using (var connection = new QC.SqlConnection("Data Source=LENOVO-PC;Initial Catalog=DB_CourceProject;Integrated Security=True;"
))
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
connection.Open();
command.Connection = connection;
command.CommandType = DT.CommandType.Text;
command.CommandText = $@"select name_category, sum(amount)
from costs
where user_id = {User_id}
group by name_category";
QC.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
sb.Append("").Append(String.Format("\n{0}\t{1} ", reader.GetValue(0), reader.GetDouble(1)));
}
string str = sb.ToString();
if (String.IsNullOrEmpty(str))
{
return(String.Format("Пока что список твоих трат по этой категории пуст\nотправь мне фотографию чека."));
}
else
{
return(str);
}
}
}
}
public IEnumerable <IncomeAccountsTreeAccountTEMP> IncomeAccountsTreeAccountTEMPusingparams(string status, string search)
{
List <IncomeAccountsTreeAccountTEMP> obuList = new List <IncomeAccountsTreeAccountTEMP>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
//cmd.CommandText = "select top 500 Id, accountnumber, mis, AccountOfficer_Code, ApprovalStatus from Income_accountMIS_Override_TEMP " +
// "where ApprovalStatus=@STATUS and (accountnumber like @searchval OR mis like @searchval OR AccountOfficer_Code like @searchval)";
//cmd.Parameters.AddWithValue("@STATUS", status);
cmd.CommandText = "select top 1000 * from Income_accountMIS_Override_TEMP " +
"where ApprovalStatus=@STATUS and (accountnumber like @searchval OR ExpirationPeriod = @searchval OR ExpirationYear = @searchval)";
cmd.Parameters.AddWithValue("@searchval", "%" + search + "%");
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new IncomeAccountsTreeAccountTEMP();
obu.ID = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.AccountNumber = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : "";
obu.ShareReason = reader["ShareReason"] != DBNull.Value ? reader["ShareReason"].ToString() : "";
obu.ExpirationPeriod = reader["ExpirationPeriod"] != DBNull.Value ? Int32.Parse(reader["ExpirationPeriod"].ToString()) : 0;
obu.ExpirationYear = reader["ExpirationYear"] != DBNull.Value ? Convert.ToInt32(reader["ExpirationYear"].ToString()) : 0;
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
public void showSonNode(System.Windows.Forms.TreeNode currentNode)
{
System.Windows.Forms.TreeNode treeNode;
string sonNodeName;
SqlCommand sqlcmd = new SqlCommand();
Tools.DataBase db1 = new Tools.DataBase();
SqlConnection sqlcon = db1.getConnection();
sqlcon.Open();
sqlcmd.Connection = sqlcon;
string last = "";
if (currentNode.Name == "agentGroup")
{
sqlcmd.CommandText = "select [TS_GROUP_NAME] as nodeId from [TS_AGENT_GROUP] order by TS_GROUP_ID";
last = "组";
}
System.Data.SqlClient.SqlDataReader SDR = sqlcmd.ExecuteReader();
while (SDR.Read())
{
// SDR.NextResult();
sonNodeName = SDR["nodeId"].ToString();
treeNode = new System.Windows.Forms.TreeNode(sonNodeName);
treeNode.Name = currentNode.Name + "<" + sonNodeName;
treeNode.Text = sonNodeName + last;
if (!currentNode.Nodes.ContainsKey(treeNode.Name))
{
currentNode.Nodes.Add(treeNode);
}
}
sqlcmd.Dispose();
sqlcon.Dispose();
}
/// <summary>
/// Get the number of upcoming birthdays for all activated friends
/// </summary>
internal static int GetFriendsBirthdays(Guid userId, Business.Dialog dialog)
{
int friendsBirthdayCount = 0;
SqlConnectionHelper sqlConnection = new SqlConnectionHelper();
System.Data.SqlClient.SqlDataReader sqlDataReader = null;
try
{
sqlConnection.Command.CommandType = CommandType.StoredProcedure;
sqlConnection.Command.CommandText = "hisp_UserFriend_GetBirthdates";
sqlConnection.Command.Parameters.Add(new SqlParameter("@UserId", SqlDbType.UniqueIdentifier));
sqlConnection.Command.Parameters["@UserId"].Value = userId;
sqlDataReader = sqlConnection.Command.ExecuteReader(CommandBehavior.CloseConnection);
while (sqlDataReader.Read())
{
try
{
DateTime birthDate = (DateTime)sqlDataReader["UPD_Birthday"];
DateTime birthDay = new DateTime(DateTime.Now.Year, birthDate.Month, birthDate.Day);
TimeSpan daysUntilBirthday = birthDay - new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59);
if (daysUntilBirthday.TotalDays > 0 && daysUntilBirthday.TotalDays <= 1)
{
friendsBirthdayCount++;
}
}
catch
{
}
}
sqlDataReader.Close();
}
finally
{
sqlConnection.Close();
}
return(friendsBirthdayCount);
}
private void MainForm_Load(object sender, EventArgs e)
{
using (LoginDatabase login = new LoginDatabase(_myConnectionString))
{
login.ShowDialog();
_myConnectionString = login._connectionString;
_user = login._userName;
_server = login._server;
}
string getDatabaseName = "SELECT Name FROM Master..SysDatabases";
try
{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(_myConnectionString))
{
conn.Open();
using (System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand(getDatabaseName, conn))
{
using (System.Data.SqlClient.SqlDataReader dr = command.ExecuteReader())
{
if (dr.HasRows)
{
while (dr.Read())
{
databaseList.Add(dr["name"].ToString());
}
}
}
}
}
this.cmb_CurrentDatabase.Items.AddRange(databaseList.ToArray());
this.cmb_SourceDatabase.Items.AddRange(databaseList.ToArray());
this.toolScriptUser.Text = "用户: " + _user;
this.Text = this.Text + "[" + _server + "] - DataToy";
}
catch { }
}
public IEnumerable <Project> SelProject(int ProjectID = -1)
{
int intRC = 0;
objProjects = new List <Project>();
IParameterFactory objParams = new ProjectsParameterFactory(ProjectID: ProjectID, ProjectName: ProjectName);
System.Data.SqlClient.SqlCommand objCmd = new SqlCommand("pSelProjects", new ADOConnectionFactory().Connection);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(objParams.Parmeters["RC"]);
objCmd.Parameters.Add(objParams.Parmeters["ProjectID"]);
try
{
objCmd.Connection.Open();
System.Data.SqlClient.SqlDataReader objDR = objCmd.ExecuteReader();
while (objDR.Read())
{
Project objP = new Project();
objP.intProjectID = (int)objDR["ProjectID"];
objP.strProjectName = (string)objDR["ProjectName"];
objP.strProjectDescription = (string)objDR["ProjectDescription"];
((List <Project>)objProjects).Add(objP);
}
objDR.Close(); //You cannot get the return value if the reader is not closed!
intRC = (int)objParams.Parmeters["RC"].Value;
if (intRC < 0)
{
throw new Exception("Error reported in Stored Procedure: " + objParams.Parmeters["RC"].Value.ToString());
}
objCmd.Connection.Close();
}
catch (Exception) { throw; }
return(objProjects);
}
private void CreatePLMParameterModes(int plmId, int userId, System.Data.SqlClient.SqlCommand command)
{
List <BusinessLogic.Json.PlmParameterModeInfo> modes = new List <BusinessLogic.Json.PlmParameterModeInfo>();
string sql = "SELECT Id, DefaultHostSpeedId, DefaultPowerId FROM PLMParameterModeType WHERE (Id NOT IN (SELECT Id FROM PLMParameterMode WHERE (PLMId = " + plmId + ")))";
command.CommandText = sql;
System.Data.SqlClient.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
BusinessLogic.Json.PlmParameterModeInfo mode = new Durados.Web.Mvc.Specifics.SanDisk.Allegro.BusinessLogic.Json.PlmParameterModeInfo();
mode.Id = reader.GetInt32(reader.GetOrdinal("Id"));
if (!reader.IsDBNull(reader.GetOrdinal("DefaultHostSpeedId")))
{
mode.DefaultHostSpeedId = reader.GetInt32(reader.GetOrdinal("DefaultHostSpeedId"));
}
if (!reader.IsDBNull(reader.GetOrdinal("DefaultPowerId")))
{
mode.DefaultPowerId = reader.GetInt32(reader.GetOrdinal("DefaultPowerId"));
}
modes.Add(mode);
}
reader.Close();
foreach (BusinessLogic.Json.PlmParameterModeInfo mode in modes)
{
sql = "insert into PLMParameterMode (PLMId, PLMParameterModeTypeId" + (mode.DefaultHostSpeedId.HasValue ? ",HostSpeedId" : "") + (mode.DefaultPowerId.HasValue ? ",PowerId" : "") + ") values (" + plmId + "," + mode.Id + (mode.DefaultHostSpeedId.HasValue ? "," + mode.DefaultHostSpeedId.Value : "") + (mode.DefaultPowerId.HasValue ? "," + mode.DefaultPowerId.Value : "") + "); SELECT IDENT_CURRENT('[PLMParameterMode]') AS ID";
command.CommandText = sql;
int id = Convert.ToInt32(command.ExecuteScalar());
sql = "insert into durados_ChangeHistory (ViewName, PK, ActionId, UpdateUserId) values ('PLMParameterMode', '" + id + "', 1, " + userId + ")";
command.CommandText = sql;
command.ExecuteNonQuery();
}
}
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
TestSprocGenerator.Data.SingleTable.Dto.Suppliers dto;
using (reader)
{
while (reader.Read())
{
dto = new TestSprocGenerator.Data.SingleTable.Dto.Suppliers();
dto.CompanyName =
_baseDatabase.resolveNullString(reader.GetOrdinal("CompanyName"), reader);
dto.ContactName =
_baseDatabase.resolveNullString(reader.GetOrdinal("ContactName"), reader);
dto.ContactTitle =
_baseDatabase.resolveNullString(reader.GetOrdinal("ContactTitle"), reader);
dto.Address =
_baseDatabase.resolveNullString(reader.GetOrdinal("Address"), reader);
dto.City =
_baseDatabase.resolveNullString(reader.GetOrdinal("City"), reader);
dto.Region =
_baseDatabase.resolveNullString(reader.GetOrdinal("Region"), reader);
dto.PostalCode =
_baseDatabase.resolveNullString(reader.GetOrdinal("PostalCode"), reader);
dto.Country =
_baseDatabase.resolveNullString(reader.GetOrdinal("Country"), reader);
dto.Phone =
_baseDatabase.resolveNullString(reader.GetOrdinal("Phone"), reader);
dto.Fax =
_baseDatabase.resolveNullString(reader.GetOrdinal("Fax"), reader);
dto.HomePage =
_baseDatabase.resolveNullString(reader.GetOrdinal("HomePage"), reader);
dto.SupplierID =
_baseDatabase.resolveNullInt32(reader.GetOrdinal("SupplierID"), reader);
this.Add(dto);
}
}
}
public virtual void AddItemsToListBySqlDataReader(System.Data.SqlClient.SqlDataReader reader)
{
TestSprocGenerator.Data.SingleTable.Dto.Person_Address dto;
using (reader)
{
while (reader.Read())
{
dto = new TestSprocGenerator.Data.SingleTable.Dto.Person_Address();
dto.Person_AddressID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("Person_AddressID"), reader);
dto.Deleted =
_baseDatabase.resolveNullBoolean(reader.GetOrdinal("Deleted"), reader);
dto.InsertedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("InsertedDateTime"), reader);
dto.ModifiedDateTime =
_baseDatabase.resolveNullDateTime(reader.GetOrdinal("ModifiedDateTime"), reader);
dto.PersonID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("PersonID"), reader);
dto.AddressID =
_baseDatabase.retrieveGuidFromDataReader(reader.GetOrdinal("AddressID"), reader);
this.Add(dto);
}
}
}
//================ methods to call starts IncomeNewDetails ==========================================
public IEnumerable <IncomeRetailProductOverrideTEMP> IncomeRetailProductOverrideTEMP(string status)
{
List <IncomeRetailProductOverrideTEMP> obuList = new List <IncomeRetailProductOverrideTEMP>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("", con);
//cmd.CommandText = "select * from Names where Id=@Id";
//cmd.Parameters.AddWithValue("@Id", id);
con.Open();
//cmd.CommandText = "select top 500 * from Income_RetailProduct_Override_TEMP where ApprovalStatus=@STATUS";
cmd.CommandText = "select top (@TAKETOP) * from Income_RetailProduct_Override_TEMP where ApprovalStatus=@STATUS";
cmd.Parameters.AddWithValue("@STATUS", status);
cmd.Parameters.AddWithValue("@TAKETOP", taketop);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var obu = new IncomeRetailProductOverrideTEMP();
obu.Id = reader["Id"] != DBNull.Value ? int.Parse(reader["Id"].ToString()) : 0;
obu.Customerid = reader["Customerid"] != DBNull.Value ? int.Parse(reader["Customerid"].ToString()) : 0;
obu.Bank = reader["Bank"] != DBNull.Value ? reader["Bank"].ToString() : "";
obu.Mis_code = reader["Mis_code"] != DBNull.Value ? reader["Mis_code"].ToString() : "";
obu.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : "";
obu.ApprovalStatus = reader["ApprovalStatus"] != DBNull.Value ? reader["ApprovalStatus"].ToString() : "";
obuList.Add(obu);
}
con.Close();
}
return(obuList);
}
private void textBoxSearch_TextChanged(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
List <String> productlist = new List <string>();
sqlconnectionclass selecttousers = new sqlconnectionclass();
DR = selecttousers.ReadDB("select * from Products where ProductName like '%" + textBoxSearch.Text + "%' and itemtype='SI'");
while (DR.Read())
{
productlist.Add(DR[0] + ":" + DR[1]);
}
listBox1.DataSource = productlist;
}
else if (radioButton3.Checked == true)
{
List <String> productlist = new List <string>();
sqlconnectionclass selecttousers = new sqlconnectionclass();
DR = selecttousers.ReadDB("select * from Products where ProductNo like '%" + textBoxSearch.Text + "%' and itemtype='SI'");
while (DR.Read())
{
productlist.Add(DR[0] + ":" + DR[1]);
}
listBox1.DataSource = productlist;
}
else if (radioButton2.Checked == true)
{
List <String> productlist = new List <string>();
sqlconnectionclass selecttousers = new sqlconnectionclass();
DR = selecttousers.ReadDB("select * from Products where barcode like '%" + textBoxSearch.Text + "%' and itemtype='SI'");
while (DR.Read())
{
productlist.Add(DR[0] + ":" + DR[1]);
}
listBox1.DataSource = productlist;
}
}
public String[] Reminder_Shower()
{
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection();
sc.ConnectionString = @"Server =Localhost;Database=TeamProject;Trusted_Connection=Yes;";
sc.Open();
System.Data.SqlClient.SqlCommand insert;
String query = "SELECT Description from Reminder as re, Jurisdiction as ju where ju.JurisdictionID = re.JurisdictionID AND DateType = '" + DateType + "' AND county = '" + County + "' AND Court = '" + Court + "';";
insert = new System.Data.SqlClient.SqlCommand(query, sc);
System.Data.SqlClient.SqlDataReader dataReader = insert.ExecuteReader();
String[] reminderList = new string[3];
int counter = 0;
while (dataReader.Read())
{
reminderList[counter] = Convert.ToString(dataReader[0]);
counter++;
}
return(reminderList);
}
/// <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 ContactID, ContactName, Title, Tel1, Tel2, Tel3, EMail, Memo FROM SecurityGroup_Contact WHERE ";
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (true == reader.Read())
{
_contactID = reader.GetInt32(0);
_contactName = reader.GetString(1);
_title = reader.GetString(2);
_tel1 = reader.GetString(3);
_tel2 = reader.GetString(4);
_tel3 = reader.GetString(5);
_eMail = reader.GetString(6);
_memo = reader.GetString(7);
}
reader.Close();
}
}
static public string SelectRowsByDates(int User_id)
{
using (var command = new QC.SqlCommand())
{
using (var connection = new QC.SqlConnection("Data Source=LENOVO-PC;Initial Catalog=DB_CourceProject;Integrated Security=True;"))
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
connection.Open();
command.Connection = connection;
command.CommandType = DT.CommandType.Text;
command.CommandText =
$@"SELECT dt, amount FROM costs WHERE user_id = {User_id}
ORDER BY dt DESC;";
QC.SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
sb.Append("").Append(String.Format("\n{0}\t{1} Р", reader.GetDateTime(0), reader.GetDouble(1)));
}
command.CommandText = null;
string str = sb.ToString();
sb.Clear();
if (String.IsNullOrEmpty(str))
{
return(String.Format("Пока что список твоих трат пуст\nотправь мне фотографию чека."));
}
else
{
return(str);
}
}
}
}
public string gerarFatura(string param1, string param2, string param3)
{
string url = "Sorry.aspx";
string idfat = "";
OperacaoBanco operacao = new OperacaoBanco();
bool inserir = operacao.Insert("insert into Tbl_Faturas (ID_Cliente,Quant,Valor_Total,Data_Fatura,Status_Pagam) values " +
"(" + param1 + ", " + param2 + " , " + param3 + " , dateadd(hh,-3,getdate()) , 'Em Aberto' ) ");
ConexaoBancoSQL.fecharConexao();
if (inserir == true)
{
//obtem o numero da fatura criada
string stringselect = "select ID_Fatura from Tbl_Faturas " +
" where ID_Cliente = " + param1 +
" order by ID_Fatura desc";
OperacaoBanco operacao1 = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader dados = operacao1.Select(stringselect);
while (dados.Read())
{
idfat = Convert.ToString(dados[0]);
break;
}
ConexaoBancoSQL.fecharConexao();
//define as entregas como pertencentes a fatura recem criada
OperacaoBanco operacao2 = new OperacaoBanco();
bool alterar = operacao2.Update("update Tbl_Entregas_Master set " +
"ID_Fatura = " + idfat +
" where ID_Cliente = " + param1 + " and ID_Fatura = 0 and Forma_Pagam = 'Faturado'");
ConexaoBancoSQL.fecharConexao();
url = "Faturas_Gerar.aspx";
}
return(url);
}
public CustomerDeviceRelations ReturnRelations(int id)
{
CustomerDeviceRelations a = new CustomerDeviceRelations();
System.Data.SqlClient.SqlDataReader reader = null;
string strSQL = "SELECT * FROM CustomerDeviceRelations WHERE ID = @id";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSQL, conn);
cmd.Parameters.AddWithValue("@id", id);
reader = cmd.ExecuteReader();
if (reader.Read())
{
a.ID = reader.GetInt32(0);
a.Customer_ID = reader.GetInt32(1);
a.Device_ID = reader.GetInt32(2);
return(a);
}
else
{
return(null);
}
}
protected void approveStudentLinkBtn_Click(object sender, CommandEventArgs e)
{
String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString);
int rowIndex = Convert.ToInt32(((sender as LinkButton).NamingContainer as GridViewRow).RowIndex);
GridViewRow row = GridView1.Rows[rowIndex];
int applicationID = Convert.ToInt32(e.CommandArgument);
Session["selectedapplicationID"] = applicationID.ToString();
sql.Open();
System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand();
moreJobInfo.Connection = sql;
moreJobInfo.CommandText = "SELECT ApplicationRequest.ApplicationID, Student.FirstName + ' ' + Student.LastName AS FullName, JobListing.JobTitle, Organization.OrganizationName FROM ApplicationRequest INNER JOIN JobListing ON ApplicationRequest.JobListingID = JobListing.JobListingID INNER JOIN Organization ON JobListing.OrganizationID = Organization.OrganizationEntityID INNER JOIN Student ON ApplicationRequest.StudentEntityID = Student.StudentEntityID WHERE ApplicationRequest.ApplicationID = " + Session["selectedapplicationID"];
System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader();
while (reader.Read())
{
StudentApproveLabel.Text = reader.GetString(1);
StudentSubApproveLabel.Text = reader.GetString(2);
Student2ndSubApproveLabel.Text = reader.GetString(3);
}
sql.Close();
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveXModal();", true);
}
public Device ReturnDevice(int id)
{
Device a = new Device();
System.Data.SqlClient.SqlDataReader reader = null;
string strSQL = "SELECT * FROM Device WHERE ID = @id";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(strSQL, conn);
cmd.Parameters.AddWithValue("@id", id);
reader = cmd.ExecuteReader();
if (reader.Read())
{
a.ID = reader.GetInt32(0);
a.Type = reader.GetString(1);
a.Name = reader.GetString(2);
a.UUID = reader.GetString(3);
a.MAC = reader.GetString(4);
return(a);
}
else
{
return(null);
}
}
private void Passbook()
{
Console.Clear();
Center("**** Alif Bank | Моя Книжка ****\n");
Console.BackgroundColor = ConsoleColor.DarkGreen;
Console.WriteLine("|{0}|", Text(5, "Сумма Сделки |" + " Время и Дата совершения сделки |" + " Описание транзакции"));
Console.WriteLine("|{0}|", Text(0, "|".PadLeft(28) + "|".PadLeft(37)));
System.Data.SqlClient.SqlDataReader dataReader = User.ReadPassbook();
while (dataReader.Read())
{
int Length = dataReader.GetValue(1).ToString().Length;
int DescLength = dataReader.GetValue(3).ToString().Length;
string Amount = dataReader.GetValue(1).ToString(), DateAndTime = dataReader.GetValue(2).ToString().PadLeft(27).PadRight(36), Description = dataReader.GetValue(3).ToString().PadLeft(DescLength + 8);
Console.WriteLine("|{0}|", Text(9, "Tj. " + Amount.PadRight(((14 - Length) + Length)) + "|" + DateAndTime + "|" + Description));
}
Console.WriteLine("|{0}|", Text(0, "|".PadLeft(28) + "|".PadLeft(37)));
Console.BackgroundColor = ConsoleColor.Black;
Console.WriteLine("\n");
Center("Нажмите любую клавишу, чтобы вернуться в предыдущее меню!");
dataReader.Close();
}
private int Get_OFID(String county, String court)
{
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection();
sc.ConnectionString = @"Server =Localhost;Database=TeamProject;Trusted_Connection=Yes;";
sc.Open();
System.Data.SqlClient.SqlCommand insert;
String query = "select JurisdictionID from Jurisdiction where DateType = 'None' AND county = '" + county + "' AND Court = '" + court + "';";
insert = new System.Data.SqlClient.SqlCommand(query, sc);
System.Data.SqlClient.SqlDataReader dataReader = insert.ExecuteReader();
int ofID = 0;
while (dataReader.Read())
{
ofID = Convert.ToInt32(dataReader[0]);
}
sc.Close();
return(ofID);
}
