public Template GetTemplate(SqlDataReader reader)
{
var htmlTemplate = reader["Template"].ToString();
var name = reader["Name"].ToString();
return new Template(name, htmlTemplate);
}
/// <summary>
/// Creates a new instance of the ViewAuditoriaListaVerificacionDetalleCross class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewAuditoriaListaVerificacionDetalleCrossInfo MakeViewAuditoriaListaVerificacionDetalleCross(SqlDataReader dataReader)
{
ViewAuditoriaListaVerificacionDetalleCrossInfo viewAuditoriaListaVerificacionDetalleCross = new ViewAuditoriaListaVerificacionDetalleCrossInfo();
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleCargoId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleCargoId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleCargoId);
if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId);
if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId);
if (dataReader.IsDBNull(CargoId) == false)
viewAuditoriaListaVerificacionDetalleCross.CargoId = dataReader.GetInt32(CargoId);
if (dataReader.IsDBNull(Cargo) == false)
viewAuditoriaListaVerificacionDetalleCross.Cargo = dataReader.GetString(Cargo);
if (dataReader.IsDBNull(Activo) == false)
viewAuditoriaListaVerificacionDetalleCross.Activo = dataReader.GetBoolean(Activo);
if (dataReader.IsDBNull(AuditoriaPunto) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaPunto = dataReader.GetString(AuditoriaPunto);
if (dataReader.IsDBNull(AuditoriaControl) == false)
viewAuditoriaListaVerificacionDetalleCross.AuditoriaControl = dataReader.GetString(AuditoriaControl);
if (dataReader.IsDBNull(PuntajeRequerido) == false)
viewAuditoriaListaVerificacionDetalleCross.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido);
if (dataReader.IsDBNull(Empresa) == false)
viewAuditoriaListaVerificacionDetalleCross.Empresa = dataReader.GetString(Empresa);
if (dataReader.IsDBNull(Orden) == false)
viewAuditoriaListaVerificacionDetalleCross.Orden = dataReader.GetByte(Orden);
return viewAuditoriaListaVerificacionDetalleCross;
}
public ChiTietPhieuXuatKho(SqlDataReader dataReader)
{
PhieuXuatKhoGuid = dataReader["PhieuXuatKhoGuid"] != null ? (Guid)dataReader["PhieuXuatKhoGuid"] : Guid.Empty;
ItemStoreGuid = dataReader["ItemStoreGuid"] != null ? (Guid)dataReader["ItemStoreGuid"] : Guid.Empty;
HoaDonBanHangGuid = dataReader["HoaDonBanHangGuid"] != null ? (Guid)dataReader["HoaDonBanHangGuid"] : Guid.Empty;
SoLuong = dataReader["SoLuong"] != null ? (Int32)dataReader["SoLuong"] : 0;
}
} // End of the constructor
/// <summary>
/// Create a new custom theme from a reader
/// </summary>
/// <param name="reader"></param>
public CustomTheme(SqlDataReader reader)
{
// Set values for instance variables
this.id = Convert.ToInt32(reader["id"]);
this.name = reader["name"].ToString();
} // End of the constructor
/// <summary>
/// Loads the entity from a <b>SqlDataReader</b> object.
/// </summary>
/// <param name="dr">The data reader to read from.</param>
/// <returns>Returns the number of columns read.</returns>
/// <remarks>
/// Always reads at the current cursor position, doesn't calls the <b>Read</b> function
/// on the <b>SqlDataReader</b> object. Reads data columns by their ordinal position in
/// the query and not by their names.
/// </remarks>
internal override int LoadFromDataReader(SqlDataReader dr)
{
int o = base.LoadFromDataReader(dr);
++o; // skip guid
this.workflowTypeName = dr.GetString(++o);
this.dateStarted = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.dateFinished = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.jobExecutionStatus = (JobExecutionState)dr.GetInt32(++o);
this.suspendTimeout = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.scheduleType = (ScheduleType)dr.GetInt32(++o);
this.scheduleTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
this.recurringPeriod = (RecurringPeriod)dr.GetInt32(++o);
this.recurringInterval = dr.GetInt32(++o);
this.recurringMask = dr.GetInt64(++o);
this.workflowInstanceId = dr.IsDBNull(++o) ? Guid.Empty : dr.GetGuid(o);
this.adminRequestTime = dr.IsDBNull(++o) ? DateTime.MinValue : dr.GetDateTime(o);
if (!dr.IsDBNull(++o))
{
XmlSerializer ser = new XmlSerializer(typeof(JobAdminRequestData));
StringReader sr = new StringReader(dr.GetString(o));
this.adminRequestData = (JobAdminRequestData)ser.Deserialize(sr);
}
else
{
this.adminRequestData = null;
}
this.adminRequestResult = dr.GetInt32(++o);
this.exceptionMessage = dr.IsDBNull(++o) ? null : dr.GetString(o);
return o;
}
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;
}
public HashSum(SqlDataReader reader, String secret = "PZS")
{
DataTable dt = new DataTable();
dt.Load(reader);
dt.TableName = secret;
this.dt = dt;
}
public DBHelper()
{
connectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objConnection = dbConection;
objCommand = null;
objReader = null;
}
// 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 ObjetoDominio Cargar(long id, SqlDataReader filas)
{
string titulo = (string)filas["Titulo"];
Album resultado = new Album(id, titulo);
CargarCanciones(resultado, filas);
return resultado;
}
/** Descripcion:
*
* REQ: SqlDataReader, int
*
* RET: static string
*/
public static string SafeGetString(SqlDataReader reader, int colIndex)
{
if (!reader.IsDBNull(colIndex))
return reader.GetString(colIndex);
else
return string.Empty;
}
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 PMSAgency Read(SqlDataReader reader)
{
PMSAgency retval = new PMSAgency();
for (int i = 0; i < reader.FieldCount; i++)
{
switch (reader.GetName(i))
{
case "GroupSegment":
retval.Segment = Helper.ToString(reader[i]);
break;
case "AType":
retval.ActionType = Helper.ToString(reader[i]);
break;
case "Agency":
retval.AgencyName = Helper.ToString(reader[i]);
break;
case "Market":
retval.Market = Helper.ToString(reader[i]);
break;
case "RepGroup":
retval.RepGroup = Helper.ToString(reader[i]);
break;
case "SiteID":
retval.SiteID = Helper.ToInt32(reader[i]);
break;
}
}
return retval;
}
private void Name_TextChanged(object sender, EventArgs e)
{
myConn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True");
myConn.Open();
string commandString = @"SELECT * FROM Asset WHERE [Asset Name] = '" + name.Text + "'";
SqlCommand cmd = new SqlCommand(commandString, myConn);
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
if (rdr != null)
{
rdr.Dispose();
}
SqlDataAdapter adapter = new SqlDataAdapter(@"SELECT Asset.[Asset ID], Asset.[Asset Name], Asset.[Asset Category], Category.[Category Type], Status.[Status] , History.* FROM Asset JOIN History ON Asset.[Asset ID] = History.[Asset ID] JOIN Status ON Status.[Status ID] = Asset.[Asset Status] JOIN Category ON Category.[Category ID] = Asset.[Asset Category] WHERE [Asset Name] = '"+ name.Text+ "'", myConn);
DataTable t = new DataTable();
adapter.Fill(t);
t.Columns.RemoveAt(5);
t.Columns.RemoveAt(10);
dataGridView1.DataSource = t;
dataGridView1.Columns[2].Visible = false;
this.dataGridView1.Columns[8].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Refresh();
myConn.Close();
}
else
{
MessageBox.Show("Not in database!!");
this.Dispose();
}
}
public String GetLastIDInserted(String pStrDBTable)
{
String mStrSQL = "SELECT IDENT_CURRENT('" + pStrDBTable + "')";
String mStrLastIDInserted = "";
try
{
oCommand = new SqlCommand(mStrSQL,oConnection);
oReader = oCommand.ExecuteReader();
oTable = new DataTable();
oTable.Load(oReader);
foreach (DataRow oDataRow in oTable.Rows)
{
foreach (DataColumn oDataColumn in oTable.Columns)
{
mStrLastIDInserted = oDataRow[oDataColumn.ColumnName].ToString();
}
}
}
catch (DataException Ex)
{
mStrLastIDInserted = "";
}
oCommand = null;
oReader = null;
oTable = null;
return mStrLastIDInserted;
}
public bool CloseCommand()
{
bool flag = true;
try
{
if (connection != null)
{
if (sqlReader != null)
{
sqlReader.Close();
sqlReader.Dispose();
sqlReader = (SqlDataReader)null;
}
if (sqlCommand != null)
{
sqlCommand.Dispose();
sqlCommand = (SqlCommand)null;
}
}
}
catch (Exception ex)
{
flag = false;
hasError = true;
errorMessage = "Database command error : " + ex.Message;
}
return flag;
}
private void cbo()
{
sb = new StringBuilder();
sb.Remove(0, sb.Length);
sb.Append("SELECT SupplierId,SupplierName FROM SUPPLIER;");
sb.Append("SELECT UserId,UserName FROM UserLogin;");
string sqlIni = sb.ToString();
com = new SqlCommand();
com.CommandText = sqlIni;
com.CommandType = CommandType.Text;
com.Connection = Conn;
dr = com.ExecuteReader();
if (dr.HasRows)
{
//supplier
DataTable dtSupplier = new DataTable();
dtSupplier.Load(dr);
cboSupplier.BeginUpdate();
cboSupplier.DisplayMember = "SupplierName";
cboSupplier.ValueMember = "SupplierId";
cboSupplier.DataSource = dtSupplier;
cboSupplier.EndUpdate();
//User
DataTable dtUserId = new DataTable();
dtUserId.Load(dr);
cboUserId.BeginUpdate();
cboUserId.DisplayMember = "UserName";
cboUserId.ValueMember = "UserId";
cboUserId.DataSource = dtUserId;
cboUserId.EndUpdate();
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.cadenaconexion =
"Data Source=LOCALHOST;Initial Catalog=HOSPITAL;User ID=SA";
this.cn = new SqlConnection(this.cadenaconexion);
this.com = new SqlCommand();
//LA PRIMERA VEZ...
if (this.Page.IsPostBack == false)
{
this.lstdepartamentos.AutoPostBack = true;
this.com.Connection = this.cn;
this.com.CommandType = System.Data.CommandType.Text;
this.com.CommandText = "SELECT * FROM DEPT";
this.cn.Open();
this.lector = this.com.ExecuteReader();
while (this.lector.Read())
{
ListItem it = new ListItem();
it.Text = this.lector["DNOMBRE"].ToString();
it.Value = this.lector["DEPT_NO"].ToString();
this.lstdepartamentos.Items.Add(it);
}
this.lector.Close();
this.cn.Close();
}
}
/// <summary>
/// Creates a new instance of the ViewSeguridadUsuario class and populates it with data from the specified SqlDataReader.
/// </summary>
private static ViewSeguridadUsuarioInfo MakeViewSeguridadUsuario(SqlDataReader dataReader)
{
ViewSeguridadUsuarioInfo viewSeguridadUsuario = new ViewSeguridadUsuarioInfo();
if (dataReader.IsDBNull(SeguridadUsuarioId) == false)
viewSeguridadUsuario.SeguridadUsuarioId = dataReader.GetInt32(SeguridadUsuarioId);
if (dataReader.IsDBNull(SeguridadRolId) == false)
viewSeguridadUsuario.SeguridadRolId = dataReader.GetInt32(SeguridadRolId);
if (dataReader.IsDBNull(Rol) == false)
viewSeguridadUsuario.Rol = dataReader.GetString(Rol);
if (dataReader.IsDBNull(NombreUsuario) == false)
viewSeguridadUsuario.NombreUsuario = dataReader.GetString(NombreUsuario);
if (dataReader.IsDBNull(Nombres) == false)
viewSeguridadUsuario.Nombres = dataReader.GetString(Nombres);
if (dataReader.IsDBNull(Apellidos) == false)
viewSeguridadUsuario.Apellidos = dataReader.GetString(Apellidos);
if (dataReader.IsDBNull(PaswordHash) == false)
viewSeguridadUsuario.PaswordHash = dataReader.GetString(PaswordHash);
if (dataReader.IsDBNull(Salt) == false)
viewSeguridadUsuario.salt = dataReader.GetString(Salt);
if (dataReader.IsDBNull(Activo) == false)
viewSeguridadUsuario.Activo = dataReader.GetBoolean(Activo);
if (dataReader.IsDBNull(NombreCompleto) == false)
viewSeguridadUsuario.NombreCompleto = dataReader.GetString(NombreCompleto);
return viewSeguridadUsuario;
}
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();
}
}
internal SqlCachedBuffer(SqlDataReader dataRdr, int columnOrdinal, long startPosition)
{
int num;
this._cachedBytes = new ArrayList();
long dataIndex = startPosition;
do
{
byte[] buffer = new byte[0x800];
num = (int) dataRdr.GetBytesInternal(columnOrdinal, dataIndex, buffer, 0, 0x800);
dataIndex += num;
if (this._cachedBytes.Count == 0)
{
this.AddByteOrderMark(buffer, num);
}
if (0 < num)
{
if (num < buffer.Length)
{
byte[] dst = new byte[num];
Buffer.BlockCopy(buffer, 0, dst, 0, num);
buffer = dst;
}
this._cachedBytes.Add(buffer);
}
}
while (0 < num);
}
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 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;
}
/** Descripcion:
*
* REQ: SqlDataReader,int
*
* RET: static int
*/
public static int SafeGetInt32(SqlDataReader reader, int colIndex)
{
if (!reader.IsDBNull(colIndex))
return reader.GetInt32(colIndex);
else
return -1;
}
// 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;
}
}
public override void fillData(SqlDataReader reader)
{
drivinglicence = (string)reader.GetValue(0);
drivinglicencetype = (string)reader.GetValue(1);
point = (int)reader.GetValue(2);
ID = (string)reader.GetValue(3);
}
protected void Page_Load(object sender, EventArgs e)
{
objConn = new SqlConnection();
objConn.ConnectionString = strConnString;
objConn.Open();
string sql_hl = "";
string sql_vd = "";
if (!string.IsNullOrEmpty(Request.QueryString["hl"] as string)) { sql_hl = "and Haulier_Abbr='" + Request.QueryString["hl"].ToString() + "' "; }
if (!string.IsNullOrEmpty(Request.QueryString["vd"] as string)) { sql_vd = "and Vendor_Code in (select Vendor_Code from Vendor_Group where VendorID='" + Request.QueryString["vd"].ToString() + "') "; }
if (!string.IsNullOrEmpty(Request.QueryString["dc"] as string)) { sql_hl = "and DC_NO='" + Request.QueryString["dc"].ToString() + "' "; }
string sql_detail = "select Vendor_Code,Vendor_Name,Haulier_Abbr,DC_No,Delivery_Location,Currency, " +
"case when upper(RateType) like '%Box%' then No_Of_QTY end as Boxes, " +
"case when upper(RateType) like '%Pallet%' then No_Of_QTY end as Pallets, " +
"case when upper(RateType) like '%Tray%' then No_Of_QTY end as Trays, " +
"case when upper(RateType) like '%Cases%' then No_Of_QTY end as Cases, " +
"case when upper(RateType) like '%Load%' then No_Of_QTY end as Loads, " +
"sum(Rate_Per_unit*No_Of_Qty) as Cost , " +
"sum(Total_Cost) as TotalCost, " +
"sum(Total_Cost_Charging) as Total_Revenue, " +
"sum(Total_Cost_Charging-(Total_Cost)) as Profit " +
"from transportation " +
"Where Year_Week_Upload='" + Request.QueryString["yw"].ToString() + "' " +
"" + sql_hl + "" +
"" + sql_vd + "" +
//"and Vendor_Name<>'DUMMY' " +
"and Calc_Date is not null Group by Vendor_Code,Vendor_Name,Haulier_Abbr,DC_No,Delivery_Location,Currency, " +
"case when upper(RateType) like '%Box%' then No_Of_QTY end , " +
"case when upper(RateType) like '%Pallet%' then No_Of_QTY end , " +
"case when upper(RateType) like '%Tray%' then No_Of_QTY end , " +
"case when upper(RateType) like '%Cases%' then No_Of_QTY end , " +
"case when upper(RateType) like '%Load%' then No_Of_QTY end ,TransID Order by Vendor_Name";
SqlCommand rs_detail = new SqlCommand(sql_detail, objConn);
obj_detail = rs_detail.ExecuteReader();
}
public BaseFlowerLinkRaceRank(SqlDataReader reader)
{
if(reader ==null)
throw new Exception();
this.InitData(reader);
}
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;
}
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;
}
protected void SubmitForm(object sender, EventArgs e)
{
String uname = String.Format("{0}", Request.Form["uname"]);
String pword = String.Format("{0}", Request.Form["pword"]);
String connectionString = "Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename = " + "D:\\workSpaces\\studio2017\\repos\\Hostel Management System Rushi\\Hostel Management System Rushi\\App_Data\\Database.mdf" + "; Integrated Security = True";
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(connectionString);
con.Open();
Console.WriteLine("connection opened successfully");
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("select * from Users where uname='" + uname + "' and pword='" + pword + "'", con);
System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Show", "alert('Login Successful');", true);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Show", "alert('Login Failed');", true);
}
con.Close();
Console.WriteLine("connection closed successfully");
}
private void Table_Notas(string ID)
{
string stringSelect = "select t1.id_aa, t2.nome, t1.nota " +
"from tbl_aluno_avaliacao t1 " +
"inner join tbl_alunos t2 on (t1.id_aluno = t2.ID_Aluno ) " +
"where t1.id_avaliacao = " + ID;
OperacaoBanco operacaoUsers = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader rcrdsetUsers = operacaoUsers.Select(stringSelect);
str.Clear();
string ScriptDados;
while (rcrdsetUsers.Read())
{
string bt1 = "<a class='w3-btn w3-round w3-hover-red w3-text-green' onclick='ExcluirAl(this," +
Convert.ToString(rcrdsetUsers[0]) +
")'><i class='fa fa-trash-o' aria-hidden='true'></i></a> ";
ScriptDados = "<tr>";
str.Append(ScriptDados);
ScriptDados = "<td>" + bt1 + Convert.ToString(rcrdsetUsers[1]) + "</td>";
str.Append(ScriptDados);
ScriptDados = "<td>" + Convert.ToString(rcrdsetUsers[2]) + "</td>";
str.Append(ScriptDados);
ScriptDados = "</tr>";
str.Append(ScriptDados);
}
ConexaoBancoSQL.fecharConexao();
Literal_table.Text = str.ToString();
}
private void dadosCorpo()
{
string stringselect = "select ID_viagem, veiculo, motorista, format(data_viagem,'dd/MM/yyyy') as d1 " +
"from Tbl_Viagens " +
"where ID_Inst =" + InstID +
"order by data_viagem";
OperacaoBanco operacao = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader dados = operacao.Select(stringselect);
while (dados.Read())
{
string Coluna0 = Convert.ToString(dados[0]); //id
string Coluna1 = Convert.ToString(dados[1]);
string Coluna2 = Convert.ToString(dados[2]);
string Coluna3 = Convert.ToString(dados[3]);
// <!--*******Customização*******-->
string bt1 = "<a class='w3-btn w3-round w3-hover-blue w3-text-green' href='Viagens_Ficha.aspx?v1=" + Coluna0 + "'><i class='fa fa-id-card-o' aria-hidden='true'></i></a>";
string bt2 = "<a class='w3-btn w3-round w3-hover-red w3-text-green' onclick='Excluir(" + Coluna0 + ")'><i class='fa fa-trash-o' aria-hidden='true'></i></a> ";
string stringcomaspas = "******" +
"<td>" + bt1 + bt2 + Coluna1 + "</td>" +
"<td>" + Coluna2 + "</td>" +
"<td>" + Coluna3 + "</td>" +
"</tr>";
str.Append(stringcomaspas);
TotaldeRegistros += 1;
}
ConexaoBancoSQL.fecharConexao();
lblTotalRegistros.Text = TotaldeRegistros.ToString();
}
private static void Events_KeyboardUp(object sender, KeyboardEventArgs args)
{
if (args.Key == Key.KeypadEnter)
{
ResetScreen();
DispSDLText(mVideoScreen, "HELLO WORLD", -1, 300);
mVideoScreen.Update();
SdlDotNet.Core.Timer.DelaySeconds(5); //delay so to show the animation
ResetScreen();
PrintWelcomeMessage();
}
else if (args.Key == Key.Escape)
{
System.Console.WriteLine("Escape pressed, Quitting");
Environment.Exit(0);
}
else if (args.EventStruct.key.keysym.scancode != 0x24)
{
string str = args.KeyboardCharacter.ToString();
mID2.Append(args.KeyboardCharacter.ToString());
}
else
{
string id = mID2.ToString();
mID2 = new StringBuilder(); // zero out the mID2
if (mStringReplace)
{
id = id.Substring(10, id.Length - 1);
char[] idstr = id.ToCharArray();
idstr[0] = 'u';
id = idstr.ToString();
}
System.Data.SqlClient.SqlConnection doorDB =
new System.Data.SqlClient.SqlConnection("user id=uid;" +
"password=pwrod;server=url;Trusted_Connection=yes;" +
"database=database;connection timeout=30");
try
{
doorDB.Open();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
string query = String.Format("SELECT id, first FROM users where swipe=\"{0}\"", id);
System.Data.SqlClient.SqlCommand qCommand = new System.Data.SqlClient.SqlCommand(query, doorDB);
System.Data.SqlClient.SqlDataReader qReader = null;
StringBuilder sb = new StringBuilder("Hello ");
try
{
qReader = qCommand.ExecuteReader();
while (qReader.Read())
{
sb.Append(qReader[1].ToString());
query = String.Format("insert into log(user,time) VALUES(\"{0}\",NOW())", qReader[0]);
ResetScreen();
DispSDLText(mVideoScreen, sb.ToString(), -1, 100);
//now unlock the door
mArduino.Write("u\r");
mVideoScreen.Update();
SdlDotNet.Core.Timer.DelaySeconds(5); //delay so to show the animation
ResetScreen();
PrintWelcomeMessage();
}
try
{
doorDB.Close();
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
}
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
login = Session["loginVal"].ToString();
string sql1 = "Select * from adminlogin where username='******'";
SqlDataReader sdr1 = DB.CommonDatabase.DataReader(sql1);
if (sdr1.Read())
{
name = sdr1["ContactPerson"].ToString();
emailid = sdr1["Email"].ToString();
}
if (login.Contains('@'))
{
userid = login;
}
else
{
userid = emailid;
}
finaldata3 = Request.QueryString["Finalstr"];
bookingid = finaldata3;
string sql = "select * from HopOnHopOffBookingDetails where bookingid='" + finaldata3 + "'";
System.Data.SqlClient.SqlDataReader sdr = DB.CommonDatabase.DataReader(sql);
if (sdr.Read())
{
bookingdetails = sdr.GetString(2);
bookingdate = sdr.GetString(3);
status = sdr.GetString(4);
}
arr = bookingdetails.Split('~');
dayinfo = bookingdetails.Split('!')[1].Split('$')[0].TrimEnd('~');
passinfo = bookingdetails.Split('~')[0];
MailMessage mm;
mm = new MailMessage("*****@*****.**", "*****@*****.**"); //[email protected] "*****@*****.**", "*****@*****.**"
// mm.Body = string.Format("Hi");
mm.Subject = userid + " , " + name + " , " + bookingdate + " , " + arr[1];
mm.Body = string.Format("<form id='Form1' runat='server'><div style='height: 25px;'></div>");
mm.Body += ("<div class='row' align='center' style='font-size: x-large; font-weight: bold'>");
mm.Body += ("SightSeeing Confirmation</div><div style='height: 15px;'></div>");
mm.Body += ("<div class='container' style='border: 2px solid #ccc; max-width: 850px; min-height: 30px;font-size: large;'>");
mm.Body += ("<div class='row'><div class='col-md-6' style='border-right: 2px solid #ccc;'><div class='col-md-12' style='height:15px;'></div>");
mm.Body += ("<div class='col-md-6'><b>Booking ID :</b></div>");
mm.Body += ("<div class='col-md-6'>" + bookingid + "</div><div class='col-md-6'>");
mm.Body += ("<b>Booking Date :</b></div><div class='col-md-6'>" + bookingdate + "</div>");
mm.Body += ("<div class='col-md-6'><b>Status :</b></div><div class='col-md-6'>");
mm.Body += ("" + status + "</div><div class='col-md-12' style='height:15px;'></div></div>");
mm.Body += ("<div class='col-md-6' align='right'><b>Travel Rez Online<br />61-C Kalu Sarai, hauz Khas,<br />Delhi-110016<br />47050000</b></div>");
mm.Body += ("</div><div class='row' align='center' style='background-color: #808080; color: #000000;");
mm.Body += ("min-height: 35px; margin-bottom: 5px; border-top: 2px solid #ccc;border-bottom: 2px solid #ccc;>");
mm.Body += ("<b>SightSeeing Details:</b></div><div class='row'><div class='col-md-3'>");
mm.Body += ("<b>Country :</b></div><div class='col-md-3'>" + arr[0].Split('/')[4] + "</div>");
mm.Body += ("<div class='col-md-3'><b>City :</b></div><div class='col-md-3'>" + arr[1] + "</div>");
mm.Body += ("</div><div class='row' style='margin-top: 10px; min-height: 30px;'><div class='col-md-3'><b>SightSeeing Name:</b></div><div class='col-md-3'>");
mm.Body += (arr[1] + "</div></div>");
for (int i = 0; i < dayinfo.Split('~').Length; i = i + 2)
{
mm.Body += ("<div class='row' style='margin-top: 3px'><div class='col-md-6'>");
mm.Body += dayinfo.Split('~')[i + 1];
mm.Body += (":</div><div class='col-md-6'>INR");
mm.Body += ("" + dayinfo.Split('~')[i] + "</div></div>");
}
mm.Body += ("<div class='row' align='center' style='background-color: #808080; color: #000000;");
mm.Body += ("border-top: 2px solid #ccc; min-height: 35px; margin-top: 5px; margin-bottom: 5px'>");
mm.Body += ("<b>Passenger Details:</b></div>");
for (int j = 0; j < passinfo.Split('/')[0].Split(',').Length - 1; j++)
{
mm.Body += ("<div class='row' style='margin-top: 3px; min-height: '><div class='col-md-4'>" + passinfo.Split('/')[0].Split(',')[j] + "</div>");
mm.Body += ("<div class='col-md-4'>" + passinfo.Split('/')[1].Split(',')[j] + "</div><div class='col-md-4'>");
mm.Body += ("" + passinfo.Split('/')[2].Split(',')[j] + "</div></div>");
}
mm.Body += ("<div class='row' align='center' style='background-color: #808080; color: #000000;border-top: 2px solid #ccc; min-height: 35px'>");
mm.Body += ("<b>Fare Details:</b></div>");
var total = 0;
for (int i = 0; i < dayinfo.Split('~').Length; i = i + 2)
{
total += Convert.ToInt16(dayinfo.Split('~')[i]);
}
mm.Body += ("<div class='row' style='border-top: 2px solid #ccc;'><div class='col-md-6'></div>");
mm.Body += ("<div class='col-md-6' align='right'><b>Total Amount:</b></div></div>");
mm.Body += ("<div class='row' style='border-top: 2px solid #ccc;'><div class='col-md-6'></div><div class='col-md-6' align='right'>");
mm.Body += ("INR" + total + "</div></div></div><div class='gap'></div></form>");
//mm.Subject = aemail.Value + " , " + aname.Value + " , " + dest.Value + " , " + sdt.Value;
//var
//Mr,/gr,/hrh,/45,/South Africa~Cape Town~1~0~0~0!968~1 Day Hop On Hop Off~
//Mr,/abhishek,/kumar,/34,/South Africa~Cape Town~1~0~0~0!968~ 1 Day Hop On Hop Off
//~$OOU!Admin Staff!TRAVREZ99!!Travstarz holidays and Destination pvt ltd!Hauz Khas!01147050034!8928129089!Abhishek Kumar
//!INR!New Delhi!Delhi!110016!INDIA!OOU!A
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.mailhostbox.com";
smtp.EnableSsl = true;
ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); };
NetworkCredential NetworkCred = new NetworkCredential();
NetworkCred.UserName = "******";
NetworkCred.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 25;
smtp.Send(mm);
try
{
}
catch (SmtpFailedRecipientsException ex)
{
for (int i = 0; i < ex.InnerExceptions.Length; i++)
{
SmtpStatusCode status1 = ex.InnerExceptions[i].StatusCode;
if (status1 == SmtpStatusCode.MailboxBusy ||
status1 == SmtpStatusCode.MailboxUnavailable)
{
Console.WriteLine("Delivery failed - retrying in 5 seconds.");
System.Threading.Thread.Sleep(5000);
smtp.Send(mm);
}
else
{
Console.WriteLine("Failed to deliver message to {0}",
ex.InnerExceptions[i].FailedRecipient);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Exception caught in RetryIfBusy(): {0}",
ex.ToString());
}
// Response.Redirect(Request.Url.AbsoluteUri);
}
protected void Page_Load(object sender, EventArgs e)
{
Session["HotelNamePreference"] = DDLHotel.SelectedValue;
Session["AirlineCabinPreference"] = DDLPlaneCabin.SelectedValue;
Session["AirlineNamePreference"] = DDLAirline.SelectedValue;
Session["CarTransmissionPreference"] = DDLCarTrans.SelectedValue;
Session["TrainCabinPreference"] = DDLTrainCabin.SelectedValue;
if (!IsPostBack)
{
if (((string[])Session["UserIdAndAcctType"])[1].Equals("B"))
{
lblAstDropDown.Visible = true;
}
try
{
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
sc.ConnectionString = @"Data Source=pkyqlbhc9z.database.windows.net;Initial Catalog=KPMGTravel;Persist Security Info=True;User ID=episcopd;Password=Showker93;";
sc.Open();
cmd.Connection = sc;
cmd.CommandText = @"select isnull(Passport, ' '), isnull(TSAKTNNumber, ' '), isnull(TSAPrecheck, ' ') from TSATable where UserID = @UserID";
cmd.Parameters.AddWithValue("@UserID", ((string[])Session["UserIdAndAcctType"])[0]);
reader = cmd.ExecuteReader();
if (reader.Read())
{
txtPassportNumber.Text = reader.GetString(0);
txtTSAKN.Text = reader.GetString(1);
txtPre.Text = reader.GetString(2);
}
reader.Close();
cmd.CommandText = "";
cmd.CommandText = @"select isnull(CardHolder, ' '), isnull(CardNumber, ' '), isnull(CardType, ' '), isnull(CardExpiration, ' ') from CreditCard where UserID = @UserID1";
cmd.Parameters.AddWithValue("@UserID1", ((string[])Session["UserIdAndAcctType"])[0]);
reader = cmd.ExecuteReader();
if (reader.Read())
{
txtCCName.Text = reader.GetString(0);
txtCCNumber.Text = reader.GetString(1);
txtCCType.Text = reader.GetString(2);
txtCCExp.Text = reader.GetString(3);
}
reader.Close();
if (((string[])Session["UserIdAndAcctType"])[1].Equals("B"))
{
AssistantDropDown.Visible = true;
cmd.CommandText = @"Select UserID from SystemUser Where AssistantID = @accty";
cmd.Parameters.AddWithValue("@accty", ((string[])Session["UserIdAndAcctType"])[0]);
reader = cmd.ExecuteReader();
while (reader.Read())
{
string tempstr = reader.GetString(0);
strlis.Add(tempstr);
}
Session["strlis"] = strlis;
AssistantDropDown.DataSource = (List <string>)Session["strlis"];
AssistantDropDown.DataBind();
reader.Close();
}
//int user = Convert.ToInt32(Session["UserID"]);
cmd.CommandText = "";
cmd.CommandText = @"SELECT UserID, isnull(FirstName, ' ') As FirstName, isnull(MiddleName, ' ') As MiddleName, isnull(LastName, ' ') As LastName, isnull(AddressLineOne, ' '), isnull(AddressLineTwo, ' '),
isnull(City, ' '), isnull(State, ' '), isnull(Zip_Code, ' '), isnull(Telephone, ' '), isnull(Email_Address, ' ') From [SystemUser] WHERE [SystemUser].[UserID] = @UserID2";
cmd.Parameters.AddWithValue("@UserID2", ((string[])Session["UserIdAndAcctType"])[0]);
reader = cmd.ExecuteReader();
if (reader.Read())
{
txtUserID.Text = reader.GetString(0);
txtFirstName.Text = reader.GetString(1);
txtMiddleName.Text = reader.GetString(2);
txtLastName.Text = reader.GetString(3);
txtAddress.Text = reader.GetString(4);
txtAddress2.Text = reader.GetString(5);
txtCity.Text = reader.GetString(6);
txtState.Text = Convert.ToString(reader.GetValue(7));
txtZipCode.Text = Convert.ToString(reader.GetValue(8));
txtTelephone.Text = reader.GetString(9);
txtEmail.Text = reader.GetString(10);
}
reader.Close();
}
catch (Exception)
{
//Display Error for not being able to connect to database
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Error Connecting to Database.');", true);
}
}
}
private void PreencheCampos(string ID)
{
string ScriptDados = "";
str.Clear();
ScriptDados = "<script type=\"text/javascript\">";
str.Append(ScriptDados);
ScriptDados = "var x = document.getElementsByClassName('form-control');";
str.Append(ScriptDados);
string stringSelect = "select " +
"Nome," +
"format(Nascimento,'yyyy-MM-dd') as d1, " +
"EstadoCivil," +
"Pai," +
"Mae," +
"Responsavel," +
"ResponsavelCPF," +
"ResponsavelTel," +
"Naturalidade," +
"Nacionalidade," +
"Etnia," + //10
"TipoSanguinio," +
"Deficiente," +
"DeficienteTipo," +
"ID_Curso," +
"ID_Turma," +
"matricula," +
"Endereco," +
"Latitude," +
"Longitude," +
"Numero," + //20
"Bairro," +
"CEP," +
"Cidade," +
"UF," +
"Celular1," +
"Celular2," +
"TelFixo," +
"email," +
"PIS," +
"CPF," + //30
"RG," +
"RGEmissor," +
"RGEmissao," +
"CTPS," +
"CTPSserie," +
"CTPSEmissao," +
"Titulo," +
"Zona," +
"Secao," +
"CNH," + //40
"Passaporte," +
"CertNasc ," +
"Alergias," +
"AlergiasMed," +
"AcidenteAvisar," +
"CartaoSUS," +
"FardaCamisa," +
"FardaCamiseta," +
"FardaCalca," +
"FardaSapato," + //50
"FardaBota," +
"FardaObs," +
"FotoDataURI " + //53
"from Tbl_Alunos " +
"where ID_aluno = " + ID;
string getValor = " ";
OperacaoBanco operacao = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader rcrdset = operacao.Select(stringSelect);
while (rcrdset.Read())
{
for (int i = 0; i < 53; i++)
{
ScriptDados = "x[" + i + "].value = \"" + Convert.ToString(rcrdset[i]) + "\";";
str.Append(ScriptDados);
}
ScriptDados = "document.getElementById('results').innerHTML = '<img src=\"" + Convert.ToString(rcrdset[53]) + "\"/>'; ";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('Hidden1').value = \"" + Convert.ToString(rcrdset[53]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('IDHidden').value = \"" + ID + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al1').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al2').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al3').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al4').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al5').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "document.getElementById('al6').innerHTML = \"" + Convert.ToString(rcrdset[0]) + "\";";
str.Append(ScriptDados);
ScriptDados = "var latitude = document.getElementById('input_lat').value;";
str.Append(ScriptDados);
ScriptDados = "var longitude = document.getElementById('input_lng').value;";
str.Append(ScriptDados);
ScriptDados = "var urlMapa = \"MapaAuxiliar.aspx?lat=\" + latitude + \"&lng=\" + longitude;";
str.Append(ScriptDados);
ScriptDados = "window.open(urlMapa, 'MapFrame');";
str.Append(ScriptDados);
getValor = "document.getElementById('input_matri').value = \"" + Convert.ToString(rcrdset[16]) + "\";";
str.Append(getValor);
if (getValor == "0")
{
getValor = " ";
}
}
ConexaoBancoSQL.fecharConexao();
ScriptDados = "</script>";
str.Append(ScriptDados);
Literal1.Text = str.ToString();
}
//open comment modal
protected void moreInfoJobLinkBtn_Click(object sender, CommandEventArgs e)
{
// working here
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 jobID = Convert.ToInt32(e.CommandArgument);
Session["selectedLogID"] = jobID.ToString();
sql.Open();
System.Data.SqlClient.SqlCommand moreJobInfo = new System.Data.SqlClient.SqlCommand();
moreJobInfo.Connection = sql;
moreJobInfo.CommandText = "SELECT StudentComment.Comment, OrganizationComment.Comment AS Expr1 FROM OrganizationComment INNER JOIN StudentComment ON OrganizationComment.LogID = StudentComment.LogID INNER JOIN LogHours ON OrganizationComment.LogID = LogHours.LogID where LogHours.LogID = " + Session["selectedLogID"];
System.Data.SqlClient.SqlDataReader reader = moreJobInfo.ExecuteReader();
while (reader.Read())
{
StudentComment.Text = reader.GetString(0);
BusinessComment.Text = reader.GetString(1);
}
sql.Close();
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openEditJModal();", true);
if (chkImage.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Image")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Image")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkGradeLevel.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Grade Level")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Grade Level")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkGPA.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "GPA")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "GPA")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkHoursWBL.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Hours of WBL")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Hours of WBL")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkJobType.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Job Type")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Job Type")
{
GridView1.Columns[i].Visible = true;
}
}
}
}
public Profile_Account(System.Data.SqlClient.SqlDataReader reader)
{
this.AddItemsToListBySqlDataReader(reader);
}
private void TabelaCorpo()
{
string stringselect = "";
switch (RelFiltro)
{
case "Todas":
stringselect = "select nome, vinculo, Situacao , funcao, lotado " +
"from Tbl_Funcionarios " +
"where ID_Munic = " + idMunicAux +
" order by lotado,nome";
break;
default:
stringselect = "select nome, vinculo, Situacao , funcao, lotado " +
"from Tbl_Funcionarios " +
"where ID_Munic = " + idMunicAux +
" and lotado = '" + RelFiltro + "'" +
" order by lotado,nome";
break;
}
OperacaoBanco operacao = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader dados = operacao.Select(stringselect);
string Coluna1, Coluna2, Coluna3, Coluna4, Coluna5;
int total_registros = 0;
while (dados.Read())
{
Coluna1 = Convert.ToString(dados[0]);
Coluna2 = Convert.ToString(dados[1]);
Coluna3 = Convert.ToString(dados[2]);
Coluna4 = Convert.ToString(dados[3]);
Coluna5 = Convert.ToString(dados[4]);
cell = new PdfPCell(new Phrase(Coluna1, fontTabela)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(Coluna2, fontTabela)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(Coluna3, fontTabela)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(Coluna4, fontTabela)); table.AddCell(cell);
if (colunas == 5)
{
cell = new PdfPCell(new Phrase(Coluna5, fontTabela)); table.AddCell(cell);
}
total_registros++;
}
ConexaoBancoSQL.fecharConexao();
string totalreg = "Total de Registros:" + total_registros;
string linhabranco = "---";
cell = new PdfPCell(new Phrase(linhabranco, fontTabelaHeader)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(linhabranco, fontTabelaHeader)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(linhabranco, fontTabelaHeader)); table.AddCell(cell);
if (colunas == 5)
{
cell = new PdfPCell(new Phrase(linhabranco, fontTabelaHeader)); table.AddCell(cell);
cell = new PdfPCell(new Phrase(totalreg, fontTabelaHeader)); table.AddCell(cell);
}
else
{
cell = new PdfPCell(new Phrase(totalreg, fontTabelaHeader)); table.AddCell(cell);
}
}
public string cardBuilder(Literal name, string cardQuery, string searchString)
{
string cardString = "";
Boolean searchCheck = false;
for (int i = 0; i < searchString.Length - 1; i++)
{
String checkValue = searchString.Substring(i, 2);
if (checkValue == ", ")
{
searchCheck = true;
}
}
if (searchCheck == true)
{
SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["roommagnetdbConnectionString"].ToString());
SqlConnection sc = new SqlConnection(ConfigurationManager.ConnectionStrings["roommagnetdbConnectionString"].ToString());
sqlConn.Open();
String tSearch = HttpUtility.HtmlEncode(searchString);
int commaSplit = tSearch.IndexOf(",");
String cityString = tSearch.Substring(0, commaSplit).ToUpper();
String state = tSearch.Substring(commaSplit + 2).ToUpper();
System.Data.SqlClient.SqlCommand sqlComm = new System.Data.SqlClient.SqlCommand(cardQuery, sqlConn);
sqlComm.Parameters.Add(new SqlParameter("@City", cityString));
sqlComm.Parameters.Add(new SqlParameter("@State", state));
System.Data.SqlClient.SqlDataReader reader = sqlComm.ExecuteReader();
name.Text = "";
int resultCount = 0;
while (reader.Read())
{
int PropID = Convert.ToInt32(reader["PropertyID"]);
String city = reader["City"].ToString();
String homeState = reader["HomeState"].ToString();
String priceRangeLow = reader["RoomPriceRangeLow"].ToString();
String priceRangeHigh = reader["RoomPriceRangeHigh"].ToString();
String filename = reader["images"].ToString();
if (filename == "")
{
filename = "imagenotfound.png";
}
System.Data.SqlClient.SqlCommand modal = new System.Data.SqlClient.SqlCommand();
modal.Connection = sc;
modal.CommandText = "SELECT PropertyImages.images, PropertyRoom.AboutPropertyRoom " +
"FROM PropertyImages INNER JOIN" +
" Property ON PropertyImages.PropertyID = Property.PropertyID INNER JOIN" +
"PropertyRoom ON Property.PropertyID = PropertyRoom.PropertyID" +
"WHERE Property.PropertyID = " + PropID;
double priceLowRounded = Math.Round(Convert.ToDouble(priceRangeLow), 0, MidpointRounding.ToEven);
double priceHighRounded = Math.Round(Convert.ToDouble(priceRangeHigh), 0, MidpointRounding.ToEven);
string chars = addCharacteristics(PropID);
//Displays property on card
StringBuilder myCard = new StringBuilder();
myCard
.Append("<div class=\"col-xs-4 col-md-3\">")
.Append(" <div class=\"card shadow-sm mb-4\" >")
.Append(" <img class=\"img-fluid card-img-small\" src=\"https://duvjxbgjpi3nt.cloudfront.net/PropertyImages/" + filename + "\" />")
.Append(" <a data-toggle=\"modal\" href=\"#propDetailModal\" class=\"cardLinks\">")
.Append(" <div class=\"card-body\" style=\"background-color: #fff;\">")
.Append(" <h5 class=\"card-title\">" + city + ", " + homeState + "</h5>")
.Append(" <p class=\"card-text\">" + "$" + priceLowRounded + " - " + "$" + priceHighRounded + "</p>")
.Append(chars)
.Append(" </div>")
.Append(" </a>")
.Append(" <div>")
.Append(" <button type=\"button\" id=\"heartbtn" + resultCount + "\" onClick=\"favoriteBtn(" + PropID + "," + "\'" + city + "\'" + "," +
"\'" + homeState + "\'" + "," + priceLowRounded + "," + priceHighRounded + ")\" " +
"class=\"btn favoriteHeartButton\"><i id=\"hearti\" class=\"far fa-heart\"></i></button>")
.Append(" </div>")
.Append(" </div>")
.Append("</div>")
.Append(" ")
.Append("<div class=\"modal\" id=\"propDetailModal\">")
.Append(" <div class=\"modal-dialog modal-lg\">")
.Append(" <div class=\"modal-content\">")
.Append(" <div class=\"modal-body\">")
.Append(" <div class=\"container-fluid searchpageDetailBodyContent pl-0 pr-0 mt-0\">")
.Append(" <div id=\"carousel-thumb\" class=\"carousel slide carousel-fade carousel-thumbnails\" data-ride=\"carousel\">")
.Append(" <div class=\"carousel-inner\" role=\"listbox\">")
.Append(" <div class=\"carousel-item active\">")
.Append(" <img class=\"d-block w-100\" src=\"images/anthony-rooke--NJO7AF0mUo-unsplash.jpg\"")
.Append(" alt=\"First slide\">")
.Append(" </div>")
.Append("")
.Append(" <div class=\"carousel-item\">")
.Append(" <img class=\"d-block w-100\" src=\"images/loft-style-bedroom.jpg\"")
.Append(" alt=\"Second slide\">")
.Append(" </div>")
.Append("")
.Append(" <div class=\"carousel-item\">")
.Append(" <img class=\"d-block w-100\" src=\"images/scott-webb-1ddol8rgUH8-unsplash.jpg\"")
.Append(" alt=\"Third slide\">")
.Append(" </div>")
.Append(" </div>")
.Append("")
.Append(" <a class=\"carousel-control-prev\" href=\"#carousel-thumb\" role=\"button\" data-slide=\"prev\">")
.Append(" <span class=\"carousel-control-prev-icon\" aria-hidden=\"true\"></span>")
.Append(" <span class=\"sr-only\">Previous</span>")
.Append(" </a>")
.Append("")
.Append(" <a class=\"carousel-control-next\" href=\"#carousel-thumb\" role=\"button\" data-slide=\"next\">")
.Append(" <span class=\"carousel-control-next-icon\" aria-hidden=\"true\"></span>")
.Append(" <span class=\"sr-only\">Next</span>")
.Append(" </a>")
.Append("")
.Append(" <ol class=\"carousel-indicators\">")
.Append(" <li data-target=\"#carousel-thumb\" data-slide-to=\"0\" class=\"active\">")
.Append(" <img src=\"images/anthony-rooke--NJO7AF0mUo-unsplash.jpg\" width=\"100\">")
.Append(" </li>")
.Append(" <li data-target=\"#carousel-thumb\" data-slide-to=\"1\">")
.Append(" <img src=\"images/loft-style-bedroom.jpg\" width=\"100\">")
.Append(" </li>")
.Append(" <li data-target=\"#carousel-thumb\" data-slide-to=\"2\">")
.Append(" <img src=\"images/scott-webb-1ddol8rgUH8-unsplash.jpg\" width=\"100\">")
.Append(" </li>")
.Append(" </ol>")
.Append(" </div>")
.Append("")
.Append(" <section>")
.Append(" <div class=\"row propertyPageDetailTitle pt-3 pb-3\">")
.Append(" <div class=\"col-md-10 pl-5\">")
.Append(" <h2>Kew Gardens</h2>")
.Append(" </div>")
.Append(" <div class=\"col-md-2\">")
.Append(" <button class=\"btn favoriteHeartButton\"><i class=\"far fa-heart\"></i></button>")
.Append(" </div>")
.Append(" ")
.Append(" <div class=\"col-md-12\">")
.Append(" <div class=\"pl-3\">")
.Append(" <button class=\"btn personality-outline btn-sm\">Extrovert</button>")
.Append(" <button class=\"btn personality-outline btn-sm\">Wifi</button>")
.Append(" <button class=\"btn personality-outline btn-sm\">Street Parking</button>")
.Append(" </div>")
.Append(" </div>")
.Append(" ")
.Append(" </div>")
.Append(" </section>")
.Append(" ")
.Append(" <section>")
.Append(" <div class=\"row px-5 py-5\">")
.Append(" <div class=\"col-md-8 \">")
.Append(" <div class=\"col-md-12 card shadow-sm px-5 py-5\">")
.Append(" <div>")
.Append(" <h4>AboutProperty</h4>")
.Append(" </div>")
.Append(" </div>")
.Append(" ")
.Append(" <div class=\"col-md-12 card shadow-sm px-5 py-5\">")
.Append(" <div>")
.Append(" <h4>Amenities</h4>")
.Append(" </div>")
.Append(" </div>")
.Append(" ")
.Append(" <div class=\"col-md-12 card shadow-sm px-5 py-5\">")
.Append(" <div>")
.Append(" <h4>Local Information</h4>")
.Append(" </div>")
.Append(" </div>")
.Append(" </div>")
.Append(" </div>")
.Append(" ")
.Append(" </section>")
.Append(" </div>")
.Append(" </div>")
.Append(" </div>")
.Append(" </div>")
.Append("</div>");
name.Text += myCard.ToString();
resultCount++;
Session["Search"] = null;
}
reader.Close();
Session["Search"] = null;
resultLabel.Visible = true;
}
else
{
//Label for no search results
resultLabel.Text = "<strong>The search you entered was not in the right format (Format: City, State)</strong>";
}
return(cardString);
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Boolean success = false;
int id = 0;
String usertype = "";
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection();
sc.ConnectionString = @"Data Source=aay09edjn65sf6.cpcbbo8ggvx6.us-east-1.rds.amazonaws.com;Initial Catalog=RoomMagnet;Persist Security Info=True;User ID=fahrenheit;Password=cis484fall";
sc.Open();
System.Data.SqlClient.SqlCommand match = new System.Data.SqlClient.SqlCommand();
match.Connection = sc;
//match.CommandText = "select PasswordHash from [db_owner].[AdminPassword] where Email = @Email";
match.CommandText = "select passwordhash from[db_owner].[AdminPassword] where Email = @Email " +
"union select passwordhash from[dbo].[HostPassword] where Email = @Email " +
"union select passwordhash from[dbo].[TenantPassword] where Email = @Email";
match.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Email", tbEmail.Text));
System.Data.SqlClient.SqlDataReader reader = match.ExecuteReader(); // create a reader
if (reader.HasRows)
{
while (reader.Read()) // this will read the single record that matches the entered usename
{
string storedHash = reader["PasswordHash"].ToString(); // store the database password into this varable
if (PasswordHash.ValidatePassword(tbPassword.Text, storedHash)) // if the entered password matches what is stored, it will show success
{
Label1.Text = "Success!";
success = true;
}
else
{
Label1.Text = "Password is wrong.";
}
}
}
else // if the username does not exist, it will show failure.
{
Label1.Text = "Login failed";
}
sc.Close();
if (success == true)
{
sc.Open();
System.Data.SqlClient.SqlCommand matchID = new System.Data.SqlClient.SqlCommand();
matchID.Connection = sc;
//matchID.CommandText = "Select AdminID from [db_owner].[AdminPassword] where Email = @Email";
matchID.CommandText = "select adminid from[db_owner].[AdminPassword] where Email = @Email " +
"union select hostid from[dbo].[HostPassword] where Email = @Email " +
"union select tenantid from[dbo].[TenantPassword] where Email = @Email";
matchID.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Email", tbEmail.Text));
id = (Int32)matchID.ExecuteScalar();
Session["globalID"] = id;
Label1.Text = "Success! ID is: " + id;
System.Data.SqlClient.SqlCommand type = new System.Data.SqlClient.SqlCommand();
type.Connection = sc;
type.CommandText = "select UserType from [dbo].[RMUser] where userid = " + id;
usertype = type.ExecuteScalar().ToString();
switch (usertype)
{
case "t":
Response.Redirect("MasterTenantDash.aspx");
break;
case "h":
Response.Redirect("MasterHostDashboard.aspx");
break;
case "a":
Response.Redirect("MasterAdminDashboard.aspx");
break;
}
}
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(MICompanyNameTypes micompanynametypes, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
MICompanyNameType newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(micompanynametypes.ContainsType[0]) as MICompanyNameType;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
micompanynametypes.Add(newobj);
}
}
/// <summary>
/// 高级查询
/// </summary>
/// <param name="rate"></param>
/// <returns></returns>
public static ArrayList getList(double rate)
{
TranslationBase tlb = new TranslationBase();
ArrayList coll = new ArrayList();
string columns = "";
object obj = DBHelper.ExecuteScalar("select ColumnName from QueryColumnsInfo where Number='" + System.Web.HttpContext.Current.Session["Company"].ToString() + "'");
if (obj != null)
{
columns = obj.ToString();
}
//添加会员基本信息表的字段
coll.Add(new QueryKey("mi.Number", tlb.GetTran("000024", "会员编号"), true, "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.Placement", tlb.GetTran("000706", "安置人编号"), oldColumn(tlb.GetTran("000706", "安置人编号"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mp.Name", tlb.GetTran("000097", "安置人姓名"), oldColumn(tlb.GetTran("000097", "安置人姓名"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.Direct", tlb.GetTran("000043", "推荐人编号"), oldColumn(tlb.GetTran("000043", "推荐人编号"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("d.Name", tlb.GetTran("000192", "推荐人姓名"), oldColumn(tlb.GetTran("000192", "推荐人姓名"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.Name", tlb.GetTran("000025", "会员姓名"), oldColumn(tlb.GetTran("000025", "会员姓名"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.PetName", tlb.GetTran("000063", "会员昵称"), oldColumn(tlb.GetTran("000063", "会员昵称"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("lv.levelstr", tlb.GetTran("000903", "会员级别"), oldColumn(tlb.GetTran("000903", "会员级别"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.RegisterDate", tlb.GetTran("000057", "注册日期"), oldColumn(tlb.GetTran("000057", "注册日期"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("dateadd(hh,8,mi.advtime)", tlb.GetTran("007301", "激活日期"), oldColumn(tlb.GetTran("007301", "激活日期"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.Birthday", tlb.GetTran("000105", "出生日期"), oldColumn(tlb.GetTran("000105", "出生日期"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.Sex", tlb.GetTran("000085", "性别"), oldColumn(tlb.GetTran("000085", "性别"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.PostalCode", tlb.GetTran("000073", "邮编"), oldColumn(tlb.GetTran("000073", "邮编"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.HomeTele", tlb.GetTran("000065", "家庭电话"), oldColumn(tlb.GetTran("000065", "家庭电话"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.OfficeTele", tlb.GetTran("000044", "办公电话"), oldColumn(tlb.GetTran("000044", "办公电话"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.MobileTele", tlb.GetTran("000069", "移动电话"), oldColumn(tlb.GetTran("000069", "移动电话"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.FaxTele ", tlb.GetTran("000071", "传真电话"), oldColumn(tlb.GetTran("000071", "传真电话"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.CPCCode", tlb.GetTran("000916", "国家省份城市"), oldColumn(tlb.GetTran("000916", "国家省份城市"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.Address", tlb.GetTran("000920", "详细地址"), oldColumn(tlb.GetTran("000920", "详细地址"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("p.PaperType", tlb.GetTran("000081", "证件类型"), oldColumn(tlb.GetTran("000081", "证件类型"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.PaperNumber", tlb.GetTran("000083", "证件号码"), oldColumn(tlb.GetTran("000083", "证件号码"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.bankcode", tlb.GetTran("000087", "开户银行"), oldColumn(tlb.GetTran("000087", "开户银行"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.bankBook", tlb.GetTran("000086", "开户名"), oldColumn(tlb.GetTran("000086", "开户名"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey("mi.bankbranchname", tlb.GetTran("006046", "支行名称"), oldColumn(tlb.GetTran("006046", "支行名称"), columns), "text", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.BankBook ", tlb.GetTran("000111", "银行账号"), oldColumn(tlb.GetTran("000111", "银行账号"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey(@"mi.BankCard ", tlb.GetTran("000923", "卡号"), oldColumn(tlb.GetTran("000923", "卡号"), columns), "string", false, new Unit(100)));
coll.Add(new QueryKey("mi.ExpectNum", tlb.GetTran("000090", "个人期数"), oldColumn(tlb.GetTran("000090", "个人期数"), columns), "text", false, new Unit(100)));
//添加会员结算表的字段
//coll.Add(new QueryKey("mn.LayerBit1", tlb.GetTran("000928", "安置层位"), oldColumn(tlb.GetTran("000928", "安置层位"), columns), "text", false, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.LayerBit2", tlb.GetTran("000929", "推荐层位"), oldColumn(tlb.GetTran("000929", "推荐层位"), columns), "text", false, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.Ordinal1", tlb.GetTran("000930", "安置序号"), oldColumn(tlb.GetTran("000930", "安置序号"), columns), "text", false, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.Ordinal2", tlb.GetTran("000932", "推荐序号"), oldColumn(tlb.GetTran("000932", "推荐序号"), columns), "text", false, "double", new Unit(100)));
coll.Add(new QueryKey("mn.TotalNetNum", tlb.GetTran("000933", "总网人数"), oldColumn(tlb.GetTran("000933", "总网人数"), columns), "text", true, "int", new Unit(100)));
coll.Add(new QueryKey("mn.CurrentNewNetNum", tlb.GetTran("000934", "新网人数"), oldColumn(tlb.GetTran("000934", "新网人数"), columns), "text", true, "int", new Unit(100)));
coll.Add(new QueryKey("mn.CurrentTotalNetRecord ", tlb.GetTran("000936", "新网分数"), oldColumn(tlb.GetTran("000936", "新网分数"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.TotalNetRecord", tlb.GetTran("000937", "总网分数"), oldColumn(tlb.GetTran("000937", "总网分数"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.CurrentOneMark ", tlb.GetTran("000939", "新个分数"), oldColumn(tlb.GetTran("000939", "新个分数"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.TotalOneMark ", tlb.GetTran("000940", "总个分数"), oldColumn(tlb.GetTran("000940", "总个分数"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.NotTotalMark ", tlb.GetTran("000942", "未付款的总个分数"), oldColumn(tlb.GetTran("000942", "未付款的总个分数"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.TotalNotNetRecord ", tlb.GetTran("000944", "未付款的总网分数"), oldColumn(tlb.GetTran("000944", "未付款的总网分数"), columns), "text", true, "double", new Unit(100)));
//------------------------------------------------------------------------------------------------------------
//coll.Add(new QueryKey("mn.Bonus0 * " + rate.ToString() + " ", tlb.GetTran("7577", "无"), oldColumn(tlb.GetTran("7577", "无"), columns), "text", true,"double", new Unit(100)));
coll.Add(new QueryKey("mn.Bonus0 * " + rate.ToString() + " ", tlb.GetTran
("010002", "业绩奖"), oldColumn(tlb.GetTran
("010002", "业绩奖"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Bonus2 * " + rate.ToString() + " ", tlb.GetTran
//("007579", "回本奖"), oldColumn(tlb.GetTran
//("007579", "回本奖"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Bonus3 * " + rate.ToString() + " ", tlb.GetTran
//("007580", "大区奖"), oldColumn(tlb.GetTran
//("007580", "大区奖"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Bonus4 * " + rate.ToString() + " ", tlb.GetTran
//("007581", "小区奖"), oldColumn(tlb.GetTran
//("007581", "小区奖"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Bonus5 * " + rate.ToString() + " ", tlb.GetTran
//("007582", "永续奖"), oldColumn(tlb.GetTran
//("007582", "永续奖"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Bonus6 * " + rate.ToString() + " ", tlb.GetTran
//("009128", "进步奖"), oldColumn(tlb.GetTran
//("009128", "进步奖"), columns), "text", true, "double", new Unit(100)));
// //------------------------------------------------------------------------------------------------------------
// coll.Add(new QueryKey("mn.Kougl * " + rate.ToString() + " ", tlb.GetTran("001352", "网平台综合管理费"), oldColumn(tlb.GetTran("001352", "网平台综合管理费"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Koufl * " + rate.ToString() + " ", tlb.GetTran("001353", "网扣福利奖金"), oldColumn(tlb.GetTran("001353", "网扣福利奖金"), columns), "text", true, "double", new Unit(100)));
// coll.Add(new QueryKey("mn.Koufx * " + rate.ToString() + " ", tlb.GetTran("001355", "网扣重复消费"), oldColumn(tlb.GetTran("001355", "网扣重复消费"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.CurrentTotalMoney * " + rate.ToString() + " ", tlb.GetTran("000247", "总计"), oldColumn(tlb.GetTran("000247", "总计"), columns), "text", true, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.DeductTax * " + rate.ToString() + " ", tlb.GetTran("000249", "扣税"), oldColumn(tlb.GetTran("000249", "扣税"), columns), "text", true, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.DeductMoney * " + rate.ToString() + " ", tlb.GetTran("000251", "扣款"), oldColumn(tlb.GetTran("000251", "扣款"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("mn.CurrentSolidSend * " + rate.ToString() + " ", tlb.GetTran("000254", "实发"), oldColumn(tlb.GetTran("000254", "实发"), columns), "text", true, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.BonusAccumulation * " + rate.ToString() + " ", tlb.GetTran("000951", "总计累计"), oldColumn(tlb.GetTran("000951", "总计累计"), columns), "text", true, "double", new Unit(100)));
//coll.Add(new QueryKey("mn.SolidSendAccumulation * " + rate.ToString() + " ", tlb.GetTran("000953", "实发累计"), oldColumn(tlb.GetTran("000953", "实发累计"), columns), "text", true, "double", new Unit(100)));
coll.Add(new QueryKey("cfg.[Date]", tlb.GetTran("000954", "期数日期"), oldColumn(tlb.GetTran("000954", "期数日期"), columns), "text", true, "text", new Unit(100)));
#region 除不能显示的
if (System.Web.HttpContext.Current.Session["dian"] != null)
{
Hashtable htb = new Hashtable();
System.Data.SqlClient.SqlDataReader sdr = DBHelper.ExecuteReader("SELECT FieldExtend,StoreSelect FROM QueryField");
while (sdr.Read())
{
if (htb[sdr["FieldExtend"].ToString().Trim()] == null)
{
htb.Add(sdr["FieldExtend"].ToString().Trim(), Convert.ToInt32(sdr["StoreSelect"]));
}
}
sdr.Close();
for (int i = coll.Count - 1; i >= 0; i--)
{
string key = ((QueryKey)coll[i]).Name.Trim();
if (htb[key] != null && (int)htb[key] == 0)
{
coll.RemoveAt(i);
}
}
}
else
{
if (System.Web.HttpContext.Current.Session["bh"] != null)
{
Hashtable htb = new Hashtable();
System.Data.SqlClient.SqlDataReader sdr = DBHelper.ExecuteReader("SELECT FieldExtend,MemberSelect FROM QueryField");
while (sdr.Read())
{
if (htb[sdr["FieldExtend"].ToString().Trim()] == null)
{
htb.Add(sdr["FieldExtend"].ToString().Trim(), Convert.ToInt32(sdr["MemberSelect"]));
}
}
sdr.Close();
for (int i = coll.Count - 1; i >= 0; i--)
{
string key = ((QueryKey)coll[i]).Name.Trim();
if (htb[key] != null && (int)htb[key] == 0)
{
coll.RemoveAt(i);
}
}
}
}
#endregion
return(coll);
}
/// <summary>
/// The object factory for a particular data collection instance.
/// </summary>
public virtual void CreateObjectsFromData(ProposedHousingExpenses proposedhousingexpenses, System.Data.SqlClient.SqlDataReader data)
{
// Do nothing if we have nothing
if (data == null)
{
return;
}
// Create a local variable for the new instance.
ProposedHousingExpense newobj = null;
// Iterate through the data reader
while (data.Read())
{
// Create a new object instance
newobj = System.Activator.CreateInstance(proposedhousingexpenses.ContainsType[0]) as ProposedHousingExpense;
// Let the instance set its own members
newobj.SetMembers(ref data);
// Add the new object to the collection instance
proposedhousingexpenses.Add(newobj);
}
}
public void makingReport()
{
Qty_Tot_ltr = 0;
InventoryClass obj = new InventoryClass();
System.Data.SqlClient.SqlDataReader rdr = null;
string home_drive = Environment.SystemDirectory;
home_drive = home_drive.Substring(0, 2);
string path = home_drive + @"\Inetpub\wwwroot\Servosms\Sysitem\ServosmsPrintServices\ReportView\Prod_Promo_Dis_Claim_Report.txt";
StreamWriter sw = new StreamWriter(path);
string sql = "";
string info = "";
//05.06.09 sql="select sp.supp_name,pm.vndr_invoice_no,pm.vndr_invoice_date,p.prod_name+':'+p.pack_type,pd.qty from supplier sp,purchase_master pm,purchase_details pd,products p where pm.invoice_no=pd.invoice_no and sp.supp_id=pm.vendor_id and p.prod_id=pd.prod_id and pm.vndr_invoice_date>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and pm.vndr_invoice_date<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"' and pd.prod_id in (select prodid from Prod_Promo_Grade_Entry where datefrom>='"+GenUtil.str2MMDDYYYY(txtDateFrom.Text)+"' and dateto<='"+GenUtil.str2MMDDYYYY(txtDateTo.Text)+"') order by p.prod_name,p.pack_type";
if (DropSchemName.SelectedIndex == 0)
{
sql = "select sp.supp_name,pm.vndr_invoice_no,pm.vndr_invoice_date,p.prod_name+':'+p.pack_type,pd.qty from supplier sp,purchase_master pm,purchase_details pd,products p where pm.invoice_no=pd.invoice_no and sp.supp_id=pm.vendor_id and p.prod_id=pd.prod_id and pm.vndr_invoice_date>='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"]) + "' and pm.vndr_invoice_date<='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"]) + "' and pd.prod_id in (select prodid from Prod_Promo_Grade_Entry where datefrom>='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"]) + "' and dateto<='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"]) + "') order by p.prod_name,p.pack_type";
}
else
{
sql = "select sp.supp_name,pm.vndr_invoice_no,pm.vndr_invoice_date,p.prod_name+':'+p.pack_type,pd.qty from supplier sp,purchase_master pm,purchase_details pd,products p where pm.invoice_no=pd.invoice_no and sp.supp_id=pm.vendor_id and p.prod_id=pd.prod_id and pm.vndr_invoice_date>='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"]) + "' and pm.vndr_invoice_date<='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"]) + "' and pd.prod_id in (select prodid from Prod_Promo_Grade_Entry where schname='" + DropSchemName.SelectedItem.Value.ToString() + "' and datefrom>='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateFrom"]) + "' and dateto<='" + GenUtil.str2MMDDYYYY(Request.Form["txtDateTo"]) + "') order by p.prod_name,p.pack_type";
}
rdr = obj.GetRecordSet(sql);
// Condensed
sw.Write((char)27); //added by vishnu
sw.Write((char)67); //added by vishnu
sw.Write((char)0); //added by vishnu
sw.Write((char)12); //added by vishnu
sw.Write((char)27); //added by vishnu
sw.Write((char)78); //added by vishnu
sw.Write((char)5); //added by vishnu
sw.Write((char)27); //added by vishnu
sw.Write((char)15);
//**********
string des = "--------------------------------------------------------------------------------------------------------------";
sw.WriteLine(des);
//******S***
sw.WriteLine(GenUtil.GetCenterAddr("=============================================", des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("Product Promotion Scheme Discount Claim Report From " + txtDateFrom.Text + " To " + txtDateTo.Text, des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("=============================================", des.Length));
//sw.WriteLine("From Date : "+txtDateFrom.Text+", To Date : "+txtDateTo.Text);
sw.WriteLine("+--------------------+------------+--------------+------------------------------+------------+------------+");
sw.WriteLine("| Vendor Name |Invoice No. | Invoice Date | Product Name | Qty in Nos.| Qty in ltr.|");
sw.WriteLine("+--------------------+------------+--------------+------------------------------+------------+------------+");
// 12345678901234567890 123456789012 12345678901234 123456789012345678901234567890 123456789012 123456789012
info = " {0,-20:S} {1,12:F} {2,14:S} {3,-30:S} {4,12:S} {5,12:S} ";
string info1 = " {0,-20:S} {1,12:F} {2,14:S} {3,-30:S} {4,12:S} {5,12:S} ";
while (rdr.Read())
{
sw.WriteLine(info,
rdr.GetValue(0).ToString(),
rdr.GetValue(1).ToString(),
GenUtil.str2DDMMYYYY(GenUtil.trimDate(rdr.GetValue(2).ToString())),
rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString(),
Qtyinltr(rdr.GetValue(3).ToString(), rdr.GetValue(4).ToString()));
Qty_Tot += Convert.ToDouble(rdr.GetValue(4).ToString());
}
rdr.Close();
sw.WriteLine("+--------------------+------------+--------------+------------------------------+------------+------------+");
sw.WriteLine(info1, "Total", "", "", "", Qty_Tot.ToString(), Qty_Tot_ltr.ToString());
sw.WriteLine("+--------------------+------------+--------------+------------------------------+------------+------------+");
sw.Close();
}
/// <summary>
/// This method is used to make the report for printing.
/// </summary>
public void makingReport()
{
System.Data.SqlClient.SqlDataReader rdr=null;
string home_drive = Environment.SystemDirectory;
home_drive = home_drive.Substring(0,2);
string path = home_drive+@"\Inetpub\wwwroot\Servosms\Sysitem\ServosmsPrintServices\ReportView\MarketPotentialReport.txt";
StreamWriter sw = new StreamWriter(path);
string sql="";
string info = "";
//string strDate = "";
sql="select firmname m1,place m2,contactper m3,teleno m4,type m5,regcustomer m6,potential m7,servo m8,castrol m9,shell m10,bpcl m11,veedol m12,elf m13,hpcl m14,pennzoil m15,spurious m16 from marketcustomerentry1";
sql=sql+" order by "+""+Cache["strorderby"]+"";
dbobj.SelectQuery(sql,ref rdr);
// Condensed
sw.Write((char)27);//added by vishnu
sw.Write((char)67);//added by vishnu
sw.Write((char)0);//added by vishnu
sw.Write((char)12);//added by vishnu
sw.Write((char)27);//added by vishnu
sw.Write((char)78);//added by vishnu
sw.Write((char)5);//added by vishnu
sw.Write((char)27);//added by vishnu
sw.Write((char)15);
//**********
string des="-----------------------------------------------------------------------------------------------------------------------------------------";
string Address=GenUtil.GetAddress();
string[] addr=Address.Split(new char[] {':'},Address.Length);
sw.WriteLine(GenUtil.GetCenterAddr(addr[0],des.Length).ToUpper());
sw.WriteLine(GenUtil.GetCenterAddr(addr[1]+addr[2],des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("Tin No : "+addr[3],des.Length));
sw.WriteLine(des);
//**********
sw.WriteLine(GenUtil.GetCenterAddr("=========================",des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("Market Potential REPORT",des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("=========================",des.Length));
sw.WriteLine("Note --> Reg :- Reguler Customer, Potl :- Potential, pnzoil :- Pennzoil, Spurs :- Spurious");
//sw.WriteLine("+---------------+---------------+---------------+-----------+-------------+-------+---------+-----+-------+-----+-----+------+-----+-----+--------+--------+");
// sw.WriteLine("| Firm Name | Place |Contact Person | Tele No | Type |Regular|Potential|Servo|Castrol|Shell|BPCL |Veedol| ELF |HPCL |Pennzoil|Spurious");
// sw.WriteLine("+---------------+---------------+---------------+-----------+-------------+-------+---------+-----+-------+-----+-----+------+-----+-----+--------+--------+");
sw.WriteLine("+---------------+---------------+---------------+----------+-------------+---+----+-----+-------+-----+----+------+---+----+------+-----+");
sw.WriteLine("| Firm Name | Place |Contact Person | Tele No | Type |Reg|Potl|Servo|Castrol|Shell|BPCL|Veedol|ELF|HPCL|Pnzoil|Spurs");
sw.WriteLine("+---------------+---------------+---------------+----------+-------------+---+----+-----+-------+-----+----+------+---+----+------+-----+");
if(rdr.HasRows)
{
// info : to set the format the displaying string.
info = " {0,-15:S} {1,-15:S} {2,-15:S} {3,10:S} {4,-13:S} {5,-3:S} {6,4:S} {7,5:S} {8,7:S} {9,5:S} {10,4:S} {11,6:S} {12,3:S} {13,4:S} {14,6:S} {15,5:S}";
while(rdr.Read())
{
/*sw.WriteLine(info,rdr["Prod_ID"].ToString().Trim(),
rdr["Prod_Name"].ToString().Trim(),
rdr["Pack_Type"].ToString(),
GenUtil.strNumericFormat(rdr["Pur_Rate"].ToString().Trim()),
GenUtil.strNumericFormat(rdr["sal_Rate"].ToString().Trim()),
GenUtil.str2DDMMYYYY(strDate));*/
sw.WriteLine(info,GenUtil.TrimLength(rdr["m1"].ToString(),15),
GenUtil.TrimLength(rdr["m2"].ToString(),15),
GenUtil.TrimLength(rdr["m3"].ToString(),15),
rdr["m4"].ToString(),
GenUtil.TrimLength(rdr["m5"].ToString(),13),
rdr["m6"].ToString(),
rdr["m7"].ToString(),
rdr["m8"].ToString(),
rdr["m9"].ToString(),
rdr["m10"].ToString(),
rdr["m11"].ToString(),
rdr["m12"].ToString(),
rdr["m13"].ToString(),
rdr["m14"].ToString(),
rdr["m15"].ToString(),
rdr["m16"].ToString());
}
}
//sw.WriteLine("+---------------+---------------+---------------+-----------+-------------+-------+---------+-----+-------+-----+-----+------+-----+-----+--------+--------+");
sw.WriteLine("+---------------+---------------+---------------+----------+-------------+---+----+-----+-------+-----+----+------+---+----+------+-----+");
dbobj.Dispose();
sw.Close();
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnsave_Click(object sender, EventArgs e)
{
string index;
string md_request;
string time_request;
string place;
string lab_ID;
string tracknum;
string pici;
string pjEng = this.GetPorjEngName(tsa_id.Text);
List <string> list_sql = new List <string>();
fields = outsource_no.Value.Split('.');
string[] cols = fields[1].ToString().Split('/');
if (cols[0].ToString().Length > 6) //变更
{
tablename = "TBPM_OUTSCHANGE";
auditlist = "TBPM_OUTSCHANGERVW";
pici = "WXBG" + cols[2].ToString().PadLeft(2, '0');
code = "OST_CHANGECODE";
viewouttable = "View_TM_OUTSCHANGE";
}
else
{
tablename = "TBPM_OUTSOURCELIST";
auditlist = "TBPM_OUTSOURCETOTAL";
pici = "WX" + cols[2].ToString().PadLeft(2, '0');
code = "OST_OUTSOURCENO";
viewouttable = "View_TM_OUTSOURCELIST";
}
string sql_check_num = "select * from " + viewouttable + " where OSL_OUTSOURCENO='" + outsource_no.Value + "' AND (case when LOWER(OSL_PURCUNIT)='吨' or LOWER(OSL_PURCUNIT)='t' or LOWER(OSL_PURCUNIT)='kg' or LOWER(OSL_PURCUNIT)='千克' or LOWER(OSL_PURCUNIT)='公斤' THEN OSL_TOTALWGHTL ELSE OSL_NUMBER END)=0";
System.Data.SqlClient.SqlDataReader dr_sql_check_num = DBCallCommon.GetDRUsingSqlText(sql_check_num);
if (dr_sql_check_num.HasRows)
{
dr_sql_check_num.Close();
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('无法保存！\\r\\r存在数量或重量为零的项，无法采购！！！\\r\\r请选择【不可提交计划项】，取消后修改计划！！！');", true);
return;
}
dr_sql_check_num.Close();
if (GridView1.Rows.Count == 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('无法保存！\\r\\r没有数据！！！');", true);
return;
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
index = ((Label)gr.FindControl("Index")).Text.Trim().PadLeft(4, '0');
tracknum = pjEng + '_' + tsa_id.Text + '_' + outsource_no.Value.Split('.')[1].Split('_')[1] + '_' + index; //计划跟踪号
lab_ID = ((Label)gr.FindControl("lab_ID")).Text;
md_request = ((HtmlInputText)gr.FindControl("txt_request")).Value;
time_request = ((HtmlInputText)gr.FindControl("txt_time")).Value;
place = ((HtmlInputText)gr.FindControl("txt_place")).Value;
sqlText = "update " + tablename + " set OSL_REQUEST='" + md_request + "',";
sqlText += "OSL_REQDATE='" + time_request + "',OSL_DELSITE='" + place + "',";
sqlText += "OSL_TRACKNUM='" + tracknum + "' where OSL_ID='" + lab_ID + "'";
list_sql.Add(sqlText);
}
if (status.Value == "0" || status.Value == "1" || status.Value == "3" || status.Value == "5" || status.Value == "7")
{
sqlText = "update " + auditlist + " set OST_STATE='1',OST_CHECKLEVEL='3',";
sqlText += "OST_MDATE='',OST_REVIEWERA='',";
sqlText += "OST_REVIEWAADVC='',OST_REVIEWADATE='',OST_REVIEWERB='',";
sqlText += "OST_REVIEWBADVC='',OST_REVIEWBDATE='',";
sqlText += "OST_REVIEWERC='',OST_REVIEWCADVC='',";
sqlText += "OST_REVIEWCDATE='',OST_ADATE='' ";
sqlText += "where " + code + "='" + outsource_no.Value + "' and OST_STATE='" + status.Value + "'";
list_sql.Add(sqlText);
}
DBCallCommon.ExecuteTrans(list_sql);
if (status.Value == "0" || status.Value == "1" || status.Value == "3" || status.Value == "5" || status.Value == "7")
{
btnCheck.Visible = true;
}
Page.ClientScript.RegisterStartupScript(this.GetType(), "test", "<script language=javascript>if(confirm('提示:保存成功!\\r\\r是否进入审核界面?'))document.getElementById('" + btn_gosh.ClientID + "').click();</script>");
}
protected void CreateUserClick(object sender, EventArgs e)
{
zipcode.Attributes.CssStyle.Remove("background-color");
email.Attributes.CssStyle.Remove("background-color");
password.Attributes.CssStyle.Remove("background-color");
password2.Attributes.CssStyle.Remove("background-color");
int zip;
Label1.Text = "";
Label2.Text = "";
String connectionString = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
System.Data.SqlClient.SqlConnection sql = new System.Data.SqlClient.SqlConnection(connectionString);
sql.Open();
System.Data.SqlClient.SqlCommand query = new System.Data.SqlClient.SqlCommand();
query.Connection = sql;
if (int.TryParse(zipcode.Value, out zip))
{
if (email.Value.Contains("@"))
{
if (password.Value.Equals(password2.Value))
{
if (password.Value.Length >= 8)
{
//get our ID for future use (inserting into tables that use this key but not have it auto increment 1 person, password)
query.CommandText = "SELECT max(UserEntityID) FROM dbo.UserEntity";
System.Data.SqlClient.SqlDataReader reader = query.ExecuteReader();
int userID = 0;
while (reader.Read())
{
userID = reader.GetInt32(0);
//increment by one because this is our new BEID after we insert
userID++;
}
sql.Close();
sql.Open();
System.Data.SqlClient.SqlCommand insert = new System.Data.SqlClient.SqlCommand();
insert.Connection = sql;
//inserting into the BE table
//insert into the person table
insert.CommandText = "insert into dbo.userentity (UserName, EmailAddress, EntityType) " +
"values (@username, @emailaddress, @entitytype)";
username.Value.Trim();
email.Value.Trim();
firstName.Value.Trim();
middleName.Value.Trim();
lastName.Value.Trim();
//Create user entity
UserEntity user = new UserEntity(username.Value.Trim(), email.Value.Trim(), role.SelectedItem.Value);
SchoolEmployee employee = new SchoolEmployee(firstName.Value.Trim(), lastName.Value.Trim(), middleName.Value.Trim(),
address.Value.Trim(), "USA", city.Value.Trim(), "VA", zipcode.Value, user.getEntityType(),
Convert.ToInt32(DropDownList2.SelectedItem.Value));
insert.Parameters.AddWithValue("@username", HttpUtility.HtmlEncode(user.getUserName()));
insert.Parameters.AddWithValue("@emailaddress", HttpUtility.HtmlEncode(user.getEmailAddress()));
insert.Parameters.AddWithValue("@entitytype", HttpUtility.HtmlEncode("SCHL"));
insert.ExecuteNonQuery();
//inserting into the password
insert.CommandText = "insert into dbo.Password (PasswordID, PasswordHash, passwordSalt, UserEntityID, lastupdated) " +
"values (@passwordID, @passwordHash, @passwordSalt, @userentityID, getDate())";
String hashedPass = PasswordHash.HashPassword(password.Value);
insert.Parameters.AddWithValue("@passwordID", userID);
insert.Parameters.AddWithValue("@passwordHash", hashedPass);
string test = PasswordHash.returnSalt(hashedPass);
//had to use only the substring and not the full salt value because there is a max length of 10 in the DB.
insert.Parameters.AddWithValue("@passwordSalt", test.Substring(0, 24));
insert.Parameters.AddWithValue("@userentityID", userID);
insert.ExecuteNonQuery();
insert.CommandText = "insert into dbo.schoolemployee (SchoolEmployeeEntityID, FirstName, LastName, MiddleName, StreetAddress, Country, City, State, Zipcode, SchoolEmployeeEntityType, SchoolEntityID) " +
"values (@SchoolEmployeeEntityID, @FirstName, @LastName, @MiddleName, @StreetAddress, @Country, @City, @State, @Zipcode, @SchoolEmployeeEntityType, @SchoolEntityID)";
insert.Parameters.AddWithValue("@SchoolEmployeeEntityID", HttpUtility.HtmlEncode(userID));
insert.Parameters.AddWithValue("@FirstName", HttpUtility.HtmlEncode(employee.getFirstName()));
insert.Parameters.AddWithValue("@LastName", HttpUtility.HtmlEncode(employee.getLastName()));
insert.Parameters.AddWithValue("@MiddleName", HttpUtility.HtmlEncode(employee.getMiddleName()));
insert.Parameters.AddWithValue("@StreetAddress", HttpUtility.HtmlEncode(employee.getStreetAddress()));
insert.Parameters.AddWithValue("@Country", HttpUtility.HtmlEncode(employee.getCountry()));
insert.Parameters.AddWithValue("@City", HttpUtility.HtmlEncode(employee.getCity()));
insert.Parameters.AddWithValue("@State", HttpUtility.HtmlEncode("VA"));
if (int.TryParse(zipcode.Value, out zip))
{
insert.Parameters.AddWithValue("@Zipcode", HttpUtility.HtmlEncode(employee.getZipCode()));
}
else
{
insert.Parameters.AddWithValue("@Zipcode", 00000);
Label1.Text = "Enter a number for the zipcode";
}
insert.Parameters.AddWithValue("@SchoolEmployeeEntityType", employee.getSchoolEmployeeEntityType());
insert.Parameters.AddWithValue("@SchoolEntityID", employee.getSchoolEntityID());
insert.ExecuteNonQuery();
//empmty these fields out.
firstName.Value = "";
lastName.Value = "";
middleName.Value = "";
city.Value = "";
zipcode.Value = "";
address.Value = "";
username.Value = "";
password.Value = "";
email.Value = "";
role.SelectedIndex = 0;
DropDownList2.SelectedIndex = 0;
Label1.Text = "Account Created!";
}
else
{
Label2.Text = "The Password Must Be More Than 8 Characters";
password.Attributes.CssStyle.Add("background-color", "crimson");
password2.Attributes.CssStyle.Add("background-color", "crimson");
}
}
else
{
Label2.Text = "Passwords do not match";
password.Attributes.CssStyle.Add("background-color", "crimson");
password2.Attributes.CssStyle.Add("background-color", "crimson");
}
}
else
{
Label2.Text = "Please Enter a Valid Email";
email.Value = "";
email.Attributes.CssStyle.Add("background-color", "crimson");
}
}
else
{
Label2.Text = "Please Enter a Valid Zipcode";
zipcode.Value = "";
zipcode.Attributes.CssStyle.Add("background-color", "crimson");
}
}
private void dadosCorpo()
{
string datastatus = DateTime.Now.ToString("yyyy-MM-dd");
string stringselect = "select ID_Entrega, LocalOrigem,LocalDestino, " +
"Tipo_Atendimento, Valor_Total, Forma_Pagam , Status_Pagam, Status_OS " +
"from Tbl_Entregas_Master " +
"where ID_Cliente = " + param + " " +
"and historico=0 ";
OperacaoBanco operacao = new OperacaoBanco();
System.Data.SqlClient.SqlDataReader dados = operacao.Select(stringselect);
while (dados.Read())
{
string Coluna0 = Convert.ToString(dados[0]); //id entrega
string Coluna1 = Convert.ToString(dados[1]).Substring(0, Convert.ToString(dados[1]).IndexOf(","));
string Coluna2 = Convert.ToString(dados[2]).Substring(0, Convert.ToString(dados[2]).IndexOf(","));
string Coluna3 = Convert.ToString(dados[3]);
string Coluna4 = Convert.ToString(dados[4]);
string Coluna5 = Convert.ToString(dados[5]);
string Coluna7 = Convert.ToString(dados[6]); //Status pagamento
string Coluna8 = Convert.ToString(dados[7]); //Status OS
string codePagam = "", classPag = "", iconPag = "";
string codeDelete = "", classDelete = "", iconDelete = "";
if (Coluna7 == "Em Aberto")
{
if (Coluna5 == "Cartão")
{
codePagam = "iniciapag(" + Coluna0 + " , " + Coluna4.Replace(",", ".") + ");";
classPag = "w3-btn w3-round w3-hover-green w3-padding";
iconPag = "<i class='fa fa-usd' aria-hidden='true'></i>";
}
else
{
codePagam = "";
classPag = "";
}
codeDelete = "excluirEntrega(" + Coluna0 + ");";
classDelete = "w3-btn w3-round w3-hover-red w3-padding";
iconDelete = "<i class='fa fa-trash-o' aria-hidden='true'></i>";
}
else if (Coluna7 == "Faturado")
{
codePagam = "Em Aberto";
classPag = "";
if (Coluna8 == "Em Aberto")
{
codeDelete = "excluirEntrega(" + Coluna0 + ");";
classDelete = "w3-btn w3-round w3-hover-red w3-padding";
iconDelete = "<i class='fa fa-trash-o' aria-hidden='true'></i>";
}
else
{
codeDelete = "";
classDelete = "";
}
}
else
{
codePagam = "";
classPag = "";
if (Coluna8 == "Em Aberto")
{
codeDelete = "excluirEntrega(" + Coluna0 + ");";
classDelete = "w3-btn w3-round w3-hover-red w3-padding";
iconDelete = "<i class='fa fa-trash-o' aria-hidden='true'></i>";
}
else
{
codeDelete = "";
classDelete = "";
}
}
String btarquivar = "";
string TipoFicha = "0";
if (Coluna8 == "Concluída")
{
btarquivar = "<a class='w3-btn w3-round w3-hover-green w3-padding' " +
"onclick='ArquivarEntrega(" + Coluna0 + ")'>" +
"<i class='fa fa-check-circle-o' aria-hidden='true'></i></a>";
TipoFicha = "1";
}
string bt1 = "<a class='" + classPag + "' onclick='" + codePagam + "'>" + iconPag + "</a>";
string bt2 = "<a class='" + classDelete + "' onclick='" + codeDelete + "'>" + iconDelete + "</a>";
string bt3 = "<a class='w3-btn w3-round w3-hover-blue' href='EntregaFicha.aspx?v1=" + Coluna0 + "&v2=" + TipoFicha + "'><i class='fa fa-info-circle' aria-hidden='true'></i></a>";
string stringcomaspas = "******" +
"<td>" + Coluna1 + "</td>" +
"<td>" + Coluna2 + "</td>" +
"<td>" + Coluna3 + "</td>" +
"<td>" + "R$" + Coluna4 + "</td>" +
"<td>" + Coluna5 + "</td>" +
"<td>" + Coluna7 + "</td>" +
"<td>" + Coluna8 + "</td>" +
"<td>" + bt3 + bt1 + bt2 + btarquivar + "</td>" +
"</tr>";
str.Append(stringcomaspas);
}
ConexaoBancoSQL.fecharConexao();
}
//click approve in gridview- trigger modal to open - fill modal
protected void approveJobLinkBtn_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 jobID = Convert.ToInt32(e.CommandArgument);
Session["selectedLogID"] = jobID.ToString();
sql.Open();
System.Data.SqlClient.SqlCommand moreHourInfo = new System.Data.SqlClient.SqlCommand();
moreHourInfo.Connection = sql;
moreHourInfo.CommandText = "SELECT JobListing.JobTitle, LogHours.HoursRequested, CONCAT(Student.FirstName,' ', Student.LastName) FROM LogHours INNER JOIN Student ON LogHours.StudentEntityID = Student.StudentEntityID INNER JOIN JobListing ON LogHours.JobListingID = JobListing.JobListingID WHERE LogHours.LogID = " + Session["selectedLogID"];
System.Data.SqlClient.SqlDataReader reader = moreHourInfo.ExecuteReader();
while (reader.Read())
{
sublabelapprovemodal1.Text = reader.GetString(2);
sublabelapprovemodal2.Text = reader.GetString(0);
sublabelapprovemodal3.Text = "Hours: " + reader.GetInt32(1).ToString();
}
sql.Close();
ClientScript.RegisterStartupScript(this.GetType(), "Pop", "openApproveXModal();", true);
if (chkImage.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Image")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Image")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkGradeLevel.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Grade Level")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Grade Level")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkGPA.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "GPA")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "GPA")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkHoursWBL.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Hours of WBL")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Hours of WBL")
{
GridView1.Columns[i].Visible = true;
}
}
}
if (chkJobType.Checked != true)
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Job Type")
{
GridView1.Columns[i].Visible = false;
}
}
}
else
{
for (int i = 0; i < GridView1.Columns.Count; i++)
{
if (GridView1.Columns[i].HeaderText == "Job Type")
{
GridView1.Columns[i].Visible = true;
}
}
}
}
public Suppliers(System.Data.SqlClient.SqlDataReader reader)
{
this.AddItemsToListBySqlDataReader(reader);
}
public CustomerCustomerDemo(System.Data.SqlClient.SqlDataReader reader)
{
this.AddItemsToListBySqlDataReader(reader);
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(clsRPlus.sCN_SALES))
{
try
{
if (e.CommandName.Equals("New"))
{
LinkButton btnNew = e.CommandSource as LinkButton;
GridViewRow row = btnNew.NamingContainer as GridViewRow;
//System.Data.SqlClient.SqlDataReader reader = null;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
if (row == null)
{
return;
}
TextBox txtforecastYear = GridView1.FooterRow.FindControl("forecastYearTextBoxNew") as TextBox;
DropDownList txtforecastCategory = GridView1.FooterRow.FindControl("forecastCategoryTextBoxEmpty") as DropDownList;
TextBox txtJan = GridView1.FooterRow.FindControl("JanTextBoxNew") as TextBox;
TextBox txtFeb = GridView1.FooterRow.FindControl("FebTextBoxNew") as TextBox;
TextBox txtMar = GridView1.FooterRow.FindControl("MarTextBoxNew") as TextBox;
TextBox txtApr = GridView1.FooterRow.FindControl("AprTextBoxNew") as TextBox;
TextBox txtMay = GridView1.FooterRow.FindControl("MayTextBoxNew") as TextBox;
TextBox txtJun = GridView1.FooterRow.FindControl("JunTextBoxNew") as TextBox;
TextBox txtJul = GridView1.FooterRow.FindControl("JulTextBoxNew") as TextBox;
TextBox txtAug = GridView1.FooterRow.FindControl("AugTextBoxNew") as TextBox;
TextBox txtSep = GridView1.FooterRow.FindControl("SepTextBoxNew") as TextBox;
TextBox txtOct = GridView1.FooterRow.FindControl("OctTextBoxNew") as TextBox;
TextBox txtNov = GridView1.FooterRow.FindControl("NovTextBoxNew") as TextBox;
TextBox txtDec = GridView1.FooterRow.FindControl("DecTextBoxNew") as TextBox;
String query = "INSERT INTO [SkupForecasts] ( [forecastYear], [forecastCategory], [Jan], [Feb],[Mar],[Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct],[Nov],[Dec]) VALUES (@forecastYear, @forecastCategory, @Jan, @Feb, @Mar, @Apr, @May, @Jun, @Jul, @Aug, @Sep, @Oct, @Nov, @Dec)";
cmd.CommandText = query;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("forecastYear", txtforecastYear.Text);
cmd.Parameters.AddWithValue("forecastCategory", txtforecastCategory.Text);
cmd.Parameters.AddWithValue("Jan", txtJan.Text);
cmd.Parameters.AddWithValue("Feb", txtFeb.Text);
cmd.Parameters.AddWithValue("Mar", txtMar.Text);
cmd.Parameters.AddWithValue("Apr", txtApr.Text);
cmd.Parameters.AddWithValue("May", txtMay.Text);
cmd.Parameters.AddWithValue("Jun", txtJun.Text);
cmd.Parameters.AddWithValue("Jul", txtJul.Text);
cmd.Parameters.AddWithValue("Aug", txtAug.Text);
cmd.Parameters.AddWithValue("Sep", txtSep.Text);
cmd.Parameters.AddWithValue("Oct", txtOct.Text);
cmd.Parameters.AddWithValue("Nov", txtNov.Text);
cmd.Parameters.AddWithValue("Dec", txtDec.Text);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Cancel();
cmd.Dispose();
conn.Close();
Response.AppendHeader("Refresh", "0,URL=");
}
if (e.CommandName.Equals("EmptyNew"))
{
LinkButton btnNew = e.CommandSource as LinkButton;
GridViewRow row = btnNew.NamingContainer as GridViewRow;
System.Data.SqlClient.SqlDataReader reader = null;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
if (row == null)
{
return;
}
TextBox txtforecastYear = GridView1.Controls[0].Controls[0].FindControl("forecastYearTextBoxEmpty") as TextBox;
DropDownList txtforecastCategory = GridView1.Controls[0].Controls[0].FindControl("forecastCategoryTextBoxEmpty") as DropDownList;
TextBox txtJan = GridView1.Controls[0].Controls[0].FindControl("JanTextBoxEmpty") as TextBox;
TextBox txtFeb = GridView1.Controls[0].Controls[0].FindControl("FebTextBoxEmpty") as TextBox;
TextBox txtMar = GridView1.Controls[0].Controls[0].FindControl("MarTextBoxEmpty") as TextBox;
TextBox txtApr = GridView1.Controls[0].Controls[0].FindControl("AprTextBoxEmpty") as TextBox;
TextBox txtMay = GridView1.Controls[0].Controls[0].FindControl("MayTextBoxEmpty") as TextBox;
TextBox txtJun = GridView1.Controls[0].Controls[0].FindControl("JunTextBoxEmpty") as TextBox;
TextBox txtJul = GridView1.Controls[0].Controls[0].FindControl("JulTextBoxEmpty") as TextBox;
TextBox txtAug = GridView1.Controls[0].Controls[0].FindControl("AugTextBoxEmpty") as TextBox;
TextBox txtSep = GridView1.Controls[0].Controls[0].FindControl("SepTextBoxEmpty") as TextBox;
TextBox txtOct = GridView1.Controls[0].Controls[0].FindControl("OctTextBoxEmpty") as TextBox;
TextBox txtNov = GridView1.Controls[0].Controls[0].FindControl("NovTextBoxEmpty") as TextBox;
TextBox txtDec = GridView1.Controls[0].Controls[0].FindControl("DecTextBoxEmpty") as TextBox;
String query = "INSERT INTO [SkupForecasts] ( [forecastYear], [forecastCategory], [Jan], [Feb],[Mar],[Apr],[May],[Jun],[Jul],[Aug],[Sep],[Oct],[Nov],[Dec]) VALUES (@forecastYear, @forecastCategory, @Jan, @Feb, @Mar, @Apr, @May, @Jun, @Jul, @Aug, @Sep, @Oct, @Nov, @Dec)";
cmd.CommandText = query;
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("forecastYear", txtforecastYear.Text);
cmd.Parameters.AddWithValue("forecastCategory", txtforecastCategory.Text);
cmd.Parameters.AddWithValue("Jan", txtJan.Text);
cmd.Parameters.AddWithValue("Feb", txtFeb.Text);
cmd.Parameters.AddWithValue("Mar", txtMar.Text);
cmd.Parameters.AddWithValue("Apr", txtApr.Text);
cmd.Parameters.AddWithValue("May", txtMay.Text);
cmd.Parameters.AddWithValue("Jun", txtJun.Text);
cmd.Parameters.AddWithValue("Jul", txtJul.Text);
cmd.Parameters.AddWithValue("Aug", txtAug.Text);
cmd.Parameters.AddWithValue("Sep", txtSep.Text);
cmd.Parameters.AddWithValue("Oct", txtOct.Text);
cmd.Parameters.AddWithValue("Nov", txtNov.Text);
cmd.Parameters.AddWithValue("Dec", txtDec.Text);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Cancel();
cmd.Dispose();
conn.Close();
Response.AppendHeader("Refresh", "0,URL=");
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
}
/// <summary>
/// Sets the members of the class instance with data from the data layer framework.
/// </summary>
internal override void SetMembers(ref System.Data.SqlClient.SqlDataReader data)
{
// make sure to always call up to the base
base.SetMembers(ref data);
// assigns the LoanApplicationId data to the class member
_loanapplicationid = Convert.ToInt64(data["LoanApplicationId"]);
_loanapplicationid_assigned = true;
// assigns the FNMCommunityLendingProductName data to the class member
if (data["FNMCommunityLendingProductName"] == System.DBNull.Value)
{
SetFNMCommunityLendingProductNameNull();
}
else
{
_fnmcommunitylendingproductname = Convert.ToString(data["FNMCommunityLendingProductName"]);
}
// assigns the FNMCommunityLendingProductTypeOtherDescription data to the class member
if (data["FNMCommunityLendingProductTypeOtherDescription"] == System.DBNull.Value)
{
SetFNMCommunityLendingProductTypeOtherDescriptionNull();
}
else
{
_fnmcommunitylendingproducttypeotherdescription = Convert.ToString(data["FNMCommunityLendingProductTypeOtherDescription"]);
}
// assigns the FNMCommunitySecondsIndicator data to the class member
_fnmcommunitysecondsindicator = Convert.ToBoolean(data["FNMCommunitySecondsIndicator"]);
_fnmcommunitysecondsindicator_assigned = true;
// assigns the FNMNeighborsMortgageEligibilityIndicator data to the class member
_fnmneighborsmortgageeligibilityindicator = Convert.ToBoolean(data["FNMNeighborsMortgageEligibilityIndicator"]);
_fnmneighborsmortgageeligibilityindicator_assigned = true;
// assigns the FREAffordableProgramIdentifier data to the class member
if (data["FREAffordableProgramIdentifier"] == System.DBNull.Value)
{
SetFREAffordableProgramIdentifierNull();
}
else
{
_freaffordableprogramidentifier = Convert.ToString(data["FREAffordableProgramIdentifier"]);
}
// assigns the HUDIncomeLimitAdjustmentFactor data to the class member
if (data["HUDIncomeLimitAdjustmentFactor"] == System.DBNull.Value)
{
SetHUDIncomeLimitAdjustmentFactorNull();
}
else
{
_hudincomelimitadjustmentfactor = Convert.ToDecimal(data["HUDIncomeLimitAdjustmentFactor"]);
_hudincomelimitadjustmentfactor_isnull = false;
}
// assigns the HUDLendingIncomeLimitAmount data to the class member
if (data["HUDLendingIncomeLimitAmount"] == System.DBNull.Value)
{
SetHUDLendingIncomeLimitAmountNull();
}
else
{
_hudlendingincomelimitamount = Convert.ToDecimal(data["HUDLendingIncomeLimitAmount"]);
_hudlendingincomelimitamount_isnull = false;
}
// assigns the HUDMedianIncomeAmount data to the class member
if (data["HUDMedianIncomeAmount"] == System.DBNull.Value)
{
SetHUDMedianIncomeAmountNull();
}
else
{
_hudmedianincomeamount = Convert.ToDecimal(data["HUDMedianIncomeAmount"]);
_hudmedianincomeamount_isnull = false;
}
// assigns the MSAIdentifier data to the class member
if (data["MSAIdentifier"] == System.DBNull.Value)
{
SetMSAIdentifierNull();
}
else
{
_msaidentifier = Convert.ToString(data["MSAIdentifier"]);
}
// assigns the FNMCommunityLendingProductType data to the class member
if (data["FNMCommunityLendingProductType"] == System.DBNull.Value)
{
SetFNMCommunityLendingProductTypeNull();
}
else
{
_fnmcommunitylendingproducttype = Convert.ToInt16(data["FNMCommunityLendingProductType"]);
_fnmcommunitylendingproducttype_isnull = false;
}
RecalculateChecksum();
}
public Categories(System.Data.SqlClient.SqlDataReader reader)
{
this.AddItemsToListBySqlDataReader(reader);
}
protected void btnSubmit(object sender, EventArgs e)
{
int personid = -1;
string firstNameV = firstname.Text.ToString();
string lastNameV = lastname.Text.ToString();
string userNameV = email.Text.ToString();
string passwordHashV = password.Text.ToString(); // GET PASSWORD HASH WORKING
string userTypeV = "Applicant";
string emailV = email.Text.ToString();
string middleInitialV = "J";
string primaryPhoneV = phone.Text.ToString();
string secondaryPhoneV = " ";
string cityV = city.Text.ToString();
string countyV = " ";
string stateV = state.Text.ToString();
string countryV = "United States";
string zipV = zip.Text.ToString();
string dob1V = " "; // GET DATE OF BIRTH WORKING. CURRENTLY HAVE GETDATE() in SQL STATEMENT
string dob2V = " ";
string streetV = address.Text.ToString();
string statusV = "Applicant";
// RABIES VACCINATION NEEDS TO BE PULLED AND DATE ASSIGNED IN SQL STATEMENT
string allergiesV = allergies.Text.ToString();;
string workOutsideV = " ";
int totalHoursV = 0; // AUTOMATICALLY 0 SINCE THEY DID NOT START WORKING YET
string workOutsideLimitationsV = " "; // NOT ON THE FORM?
string lift40V = " "; // THESE FIELDS ARE NOT ON THE FORM
int permitRehabV = 0;
string previousTrainingV = medical.Text.ToString();
string workEnvironmentV = workEnvironment.Text.ToString();
string euthanasiaV = euthanize.Text.ToString();
string dirtyV = dirty.Text.ToString();
System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection();
sc.ConnectionString = @"Server=LOCALHOST; Database=Wildlife;Trusted_Connection=Yes;";
sc.Open();
System.Data.SqlClient.SqlCommand insert = new System.Data.SqlClient.SqlCommand();
insert.Connection = sc;
insert.CommandText = "INSERT INTO Person (Person_UserName, Person_PasswordHash, Person_UserType, Person_FirstName, Person_MiddleName, Person_LastName, Person_Email, Person_PhonePrimary, Person_PhoneAlternate, Person_StreetAddress, Person_City, Person_County, Person_State, Person_Country, Person_ZipCode, Person_DateOfBirth, Person_Status, Person_RabbiesVaccinationDate, Person_RehabilitatePermitCategory, Person_Allergies, " +
"Person_WorkOutside, Person_OutsideLimitations, Person_Lift40Lbs, Person_TotalVolunteeredHours, Person_LastVolunteered)" +
" VALUES ('" + userNameV + "', '" + passwordHashV + "', '" + userTypeV + "', '" + firstNameV + "', '" + middleInitialV + "', '" + lastNameV + "', '" + emailV + "', '" + primaryPhoneV + "', '" + secondaryPhoneV + "', '" + streetV + "', '" + cityV + "', '" + countyV + "', '" + stateV + "', '" + countryV + "', '" + zipV + "', getdate(), " + " '" + statusV + "', getdate(), '" + permitRehabV + "', '" + allergiesV + "', '" +
workOutsideV + "', '" + workOutsideLimitationsV + "', '" + lift40V + "', " + totalHoursV + ", getdate())";
insert.ExecuteNonQuery();
insert.CommandText = "SELECT MAX(Person_ID) FROM Person";
insert.ExecuteNonQuery();
System.Data.SqlClient.SqlDataReader reader = insert.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
personid = reader.GetInt32(0);
}
reader.Close();
// vet specific
insert.CommandText = "INSERT INTO vetteamapp (VetTeamApp_PersonID, "
+ " VetTeamApp_PreviousTraining, "
+ "VetTeamApp_WorkEnvironment, "
+ "VetTeamApp_Euthansia, "
+ "VetTeamApp_Messy) "
+ "VALUES (" + personid + ", "
+ "'" + previousTrainingV + "', "
+ "'" + workEnvironmentV + "', "
+ "'" + euthanasiaV + "', "
+ "'" + dirtyV + "')";
insert.ExecuteNonQuery();
/* //Document Query
* if($_FILES['permitRehabVA']['size'] > 0){
* $fileName = $_FILES['permitRehabVA']['name'];
* $tmpName = $_FILES['permitRehabVA']['tmp_name'];
* $fileType = $_FILES['permitRehabVA']['type'];
* $fileSize = $_FILES['permitRehabVA']['size'];
* $fp = fopen($tmpName, 'r');
* $permitRehabVA = fread($fp, filesize($tmpName));
* $permitRehabVA = addslashes($permitRehabVA);
* fclose($fp);
*
*
*
* $documentQuery = "INSERT INTO documentation (Documentation_PersonID, Documentation_TypeOfDocument, Documentation_FileName, Documentation_FileType, Documentation_FileSize, Documentation_FileContent, Documentation_DocumentNotes)
* VALUES ('$personID', 'Rehabilitation_Permit', '$fileName', '$fileType', '$fileSize', '$permitRehabVA', NULL)";
*
*
* if(!mysqli_query($conn,$documentQuery))
*
* {
* echo("Error description: " . mysqli_error($conn));
* $insertsPassed = "false";
* }
* }
* if($_FILES['rabbiesDocumentation']['size'] > 0){
* $fileName = $_FILES['rabbiesDocumentation']['name'];
* $tmpName = $_FILES['rabbiesDocumentation']['tmp_name'];
* $fileType = $_FILES['rabbiesDocumentation']['type'];
* $fileSize = $_FILES['rabbiesDocumentation']['size'];
* $fp = fopen($tmpName, 'r');
* $rabbiesDocumentation = fread($fp, filesize($tmpName));
* $rabbiesDocumentation = addslashes($rabbiesDocumentation);
* fclose($fp);
*
*
*
* $documentQuery = "INSERT INTO documentation (Documentation_PersonID, Documentation_TypeOfDocument, Documentation_FileName, Documentation_FileType, Documentation_FileSize, Documentation_FileContent, Documentation_DocumentNotes)
* VALUES ('$personID', 'Rabbies_Documentation', '$fileName', '$fileType', '$fileSize', '$rabbiesDocumentation', NULL)";
*
*
* if(!mysqli_query($conn,$documentQuery))
*
* {
* echo("Error description: " . mysqli_error($conn));
* $insertsPassed = "false";
* }
*
* }
* if($_FILES['userFile']['size'] > 0){
* //Document Query
* $fileName = $_FILES['userFile']['name'];
* $tmpName = $_FILES['userFile']['tmp_name'];
* $fileType = $_FILES['userFile']['type'];
* $fileSize = $_FILES['userFile']['size'];
* $fp = fopen($tmpName, 'r');
* $userfile = fread($fp, filesize($tmpName));
* $userfile = addslashes($userfile);
* fclose($fp);
*
*
*
* $documentQuery = "INSERT INTO documentation (Documentation_PersonID, Documentation_TypeOfDocument, Documentation_FileName, Documentation_FileType, Documentation_FileSize, Documentation_FileContent, Documentation_DocumentNotes)
* VALUES ('$personID', 'Resume', '$fileName', '$fileType', '$fileSize', '$userfile', NULL)";
*
*
* if(!mysqli_query($conn,$documentQuery))
*
* {
* echo("Error description: " . mysqli_error($conn));
* $insertsPassed = "false";
* }
* }
* }
* if($insertsPassed == "true"){
* $conn->close();
* header("Location: confirmation.php");
* exit();
* }
* else{
* $message = 'Password values do not match. Please try again.';
*
* echo "<SCRIPT>
* alert('$message');
* </SCRIPT>";
* }
*
* }
* ?>
*
*/
}
}
public Contact(System.Data.SqlClient.SqlDataReader reader)
{
this.AddItemsToListBySqlDataReader(reader);
}
/// <summary>
/// This method is used to make the format for print .
/// </summary>
public void makingReport()
{
/*
* ======================
* PRICE LIST REPORT
* ======================
+-------+----------------------+-----------+-----------+-----------+----------+
|Prod_ID| Product Name | Pack_Type | Pur_Rate | Sal_Rate |Eff_Date |
+-------+-------------------------+-----------+-----------+-----------+----------+
* 1001 1234567890123456789012345 1X20777 12345678.00 12345678.00 DD/MM/YYYY
*/
System.Data.SqlClient.SqlDataReader rdr = null;
string home_drive = Environment.SystemDirectory;
home_drive = home_drive.Substring(0, 2);
string path = home_drive + @"\Inetpub\wwwroot\Servosms\Sysitem\ServosmsPrintServices\ReportView\MechanicReport.txt";
StreamWriter sw = new StreamWriter(path);
string sql = "";
string info = "";
//string strDate = "";
sql = "select distinct b.state r1,me.mccd r2,me.mcname r3,me.mctype r4,me.place r5,cme.customername r6,c.cust_type r7 from beat_master b,machanic_entry me, customermechanicentry cme,customer c where b.state in(select state from beat_master where city =me.place) and cme.customername in(select customername from customermechanicentry where customermechid=me.custid) and c.cust_type in(select cust_type from customer where cust_name=cme.customername)";
sql = sql + " order by " + Cache["strorderby"];
dbobj.SelectQuery(sql, ref rdr);
// Condensed
sw.Write((char)27); //added by vishnu
sw.Write((char)67); //added by vishnu
sw.Write((char)0); //added by vishnu
sw.Write((char)12); //added by vishnu
sw.Write((char)27); //added by vishnu
sw.Write((char)78); //added by vishnu
sw.Write((char)5); //added by vishnu
sw.Write((char)27); //added by vishnu
sw.Write((char)15);
//**********
string des = "---------------------------------------------------------------------------------------------------------------";
string Address = GenUtil.GetAddress();
string[] addr = Address.Split(new char[] { ':' }, Address.Length);
sw.WriteLine(GenUtil.GetCenterAddr(addr[0], des.Length).ToUpper());
sw.WriteLine(GenUtil.GetCenterAddr(addr[1] + addr[2], des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("Tin No : " + addr[3], des.Length));
sw.WriteLine(des);
//**********
sw.WriteLine(GenUtil.GetCenterAddr("=================", des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("MECHANIC REPORT", des.Length));
sw.WriteLine(GenUtil.GetCenterAddr("=================", des.Length));
sw.WriteLine("+----------+-------------+---------------+----------+-------------------------+---------------+---------------+");
sw.WriteLine("| District |Mechanic Code| Name | Type | Under Firm | Firm Type | Place |");
sw.WriteLine("+----------+-------------+---------------+----------+-------------------------+---------------+---------------+");
// 1001567 12345678901234567890123 12345678901 12345678.00 12345678.00 DD/MM/YYYY
if (rdr.HasRows)
{
// info : to set the format the displaying string.
info = " {0,-10:S} {1,-13:F} {2,-15:S} {3,-10:S} {4,-25:S} {5,-15:S} {6,-15:S}";
while (rdr.Read())
{
/*sw.WriteLine(info,rdr["Prod_ID"].ToString().Trim(),
* rdr["Prod_Name"].ToString().Trim(),
* rdr["Pack_Type"].ToString(),
* GenUtil.strNumericFormat(rdr["Pur_Rate"].ToString().Trim()),
* GenUtil.strNumericFormat(rdr["sal_Rate"].ToString().Trim()),
* GenUtil.str2DDMMYYYY(strDate));*/
sw.WriteLine(info, GenUtil.TrimLength(rdr["r1"].ToString(), 10),
rdr["r2"].ToString(),
GenUtil.TrimLength(rdr["r3"].ToString(), 15),
GenUtil.TrimLength(rdr["r4"].ToString(), 10),
GenUtil.TrimLength(rdr["r6"].ToString(), 25),
GenUtil.TrimLength(rdr["r7"].ToString(), 15),
GenUtil.TrimLength(rdr["r5"].ToString(), 15));
}
}
sw.WriteLine("+----------+-------------+---------------+----------+-------------------------+---------------+---------------+");
dbobj.Dispose();
sw.Close();
}
//Busqueda del documento escaneado
public void BuscaPedido(bool PedidoReferencia, bool Ruta, string Documento)
{
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
System.Data.SqlClient.SqlDataReader dr = null;
cmd.CommandText = "spCYCArqueoCobranzaConsultaDocumento";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = _connection;
cmd.Parameters.Add("@FInicial", SqlDbType.DateTime).Value = _fInicio;
cmd.Parameters.Add("@FFinal", SqlDbType.DateTime).Value = _fFin;
cmd.Parameters.Add("@Empleado", SqlDbType.Int).Value = _empleado;
if (PedidoReferencia != true)
{
cmd.Parameters.Add("@PedidoReferencia", SqlDbType.VarChar, 20).Value = Documento;
}
else
{
int valeCredito = 0;
try
{
valeCredito = Convert.ToInt32(Documento);
}
catch (System.OverflowException ex)
{
if (ex != null)
{
throw new System.OverflowException("El número de documento (" + Documento + ") " +
"no corresponde a un vale de crédito" + (char)13 +
"Intente la búsqueda por número de pedido");
}
}
cmd.Parameters.Add("@ValeCredito", SqlDbType.Int).Value = valeCredito;
}
if (Ruta && _ruta != 0)
{
cmd.Parameters.Add("@Ruta", SqlDbType.SmallInt).Value = _ruta;
}
_documentoEncontrado = false;
try
{
OpenConnection();
dr = cmd.ExecuteReader();
while (dr.Read())
{
AddDataRow(dr);
_documentoEncontrado = true;
}
dr.Close();
}
catch (System.Data.ConstraintException ex)
{
throw ex;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
CloseConnection();
cmd.Dispose();
}
}