private void LoginButton_Click(object sender, EventArgs e)
{
// mySQLconnection.Open();
/*
MySqlCommand mySQLcommand = new MySqlCommand("SELECT * FROM SUser WHERE username = @username AND password = @password");
if (this.OpenConnection() == true)
{
mySQLcommand.Parameters.AddWithValue("username", UsernameTextBox.Text);
mySQLcommand.Parameters.AddWithValue("password", PasswordTextBox.Text);
MySqlDataReader dataReader = mySQLcommand.ExecuteReader();
while(dataReader.Read())
{
mainpage = new MainPage();
mainpage.Show();
}
dataReader.Close();
}
//mainpage = new MainPage();
// mainpage.Show();
* */
DBConnect db = new DBConnect();
DataTable dataTable = db.GetUser(PasswordTextBox.Text, UsernameTextBox.Text);
if (dataTable != null)
{
mainpage = new MainPage();
mainpage.Show();
//MessageBox.Show(dataTable.ToString());
}
else MessageBox.Show("Noe gikk galt");
}
public bool CheckSiteStatus()
{
LogManager.WriteLog("Inside CheckSiteStatus method", LogManager.enumLogLevel.Info);
DBConnect oDbConnect = new DBConnect();
return oDbConnect.GetSiteStatus();
}
/// <summary>
/// This method must have the implementation of the work that is going to perform by this job.
/// </summary>
public void DoWork()
{
//Dictionary<string, string> dictServiceentries = null;
//RegistrySetting oRegistrySetting = null;
try
{
DBConnect oDbConnect = new DBConnect();
if ((oDbConnect.RunHourlyVTPService()) && (HourlyDailyEntity.IsReadInHourly) && (HourlyDailyEntity.HasReadRunWithHourly))
{
LogManager.WriteLog("Read has been run with Hourly, so update the registry entries for last auto read.", LogManager.enumLogLevel.Info);
// dictServiceentries = new Dictionary<string, string>();
// oRegistrySetting = new RegistrySetting();
// dictServiceentries.Add(HourlyDailyEntity.sRegistryPath + "\\\\LastAutoRead", DateTime.Now.ToString("dd MMM yyyy"));
// oRegistrySetting.SetRegistryEntries(dictServiceentries, HourlyDailyEntity.sRegistryPath);
BMCRegistryHelper.SetRegKeyValue(HourlyDailyEntity.sRegistryPath, "LastAutoRead", Microsoft.Win32.RegistryValueKind.String, DateTime.Now.ToString("dd MMM yyyy"));
HourlyDailyEntity.IsReadInHourly = false;
}
oDbConnect.UpdateHourlyStatsGamingday();
//HourlyDailyEventLog.WriteToEventLog(HourlyDailyEntity.EventLogName, "Hourly Service DoWork: ", "Hourly has been executed successfully.", EventLogEntryType.SuccessAudit);
}
catch (Exception ex)
{
// HourlyDailyEventLog.WriteToEventLog(HourlyDailyEntity.EventLogName, "Hourly Service DoWork: ", "Message: " + ex.Message + "Source: " + ex.Source, EventLogEntryType.Error);
ExceptionManager.Publish(ex);
}
}
public frmMain()
{
InitializeComponent();
dbConnect = new DBConnect();
License = new License();
}
/// <summary>
/// �̾�CMS���������o��ܤ��e
/// </summary>
/// <param name="type"></param>
/// <param name="dr"></param>
/// <returns></returns>
object CMS_GetMessRuleData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.CmsCategory)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return SetCMSDislay(dr[5].ToString(), dr[6].ToString(), Convert.ToInt32(dr[7]), Convert.ToInt32(dr[9]));
}
else if (type == DBConnect.DataType.MessColor)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return new MessColor(Convert.ToInt32(dr[0]), dr[1].ToString(), System.Drawing.Color.FromArgb(Convert.ToInt32(dr[3].ToString(), 16)), System.Drawing.Color.FromArgb(Convert.ToInt32(dr[4].ToString(), 16)));
}
else if (type == DBConnect.DataType.BlockMeg1)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return new BlockMeg1(Convert.ToInt32(dr[0]), dr[1].ToString(), (dr[2].ToString() == "1") ? true : false);
}
else if (type == DBConnect.DataType.BlockMeg2)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return dr[3].ToString();
}
else
return null;
}
static void Connecting(object client_obj)
{
DBConnect DB = new DBConnect();
Byte[] byte1 = new Byte[256];
Byte[] byte2 = new Byte[256];
Byte[] byte3 = new Byte[256];
string[] txt_msg = new string[2];
int[] arr = new int[5];
TcpClient client = client_obj as TcpClient;
NetworkStream stream = client.GetStream();
int i;
i = stream.Read(byte1, 0, byte1.Length);
txt_msg[0] = System.Text.Encoding.Unicode.GetString(byte1, 0, i);
i = stream.Read(byte2, 0, byte2.Length);
txt_msg[1] = System.Text.Encoding.Unicode.GetString(byte2, 0, i);
i = stream.Read(byte3, 0, byte3.Length);
arr = (from j in byte3 select (int)j).ToArray();
DB.Insert(txt_msg[0], txt_msg[1], arr);
client.Close();
}
static void Main(string[] args)
{
DBConnect db = new DBConnect();
db.Insert("user1", "passwd1", 1);
db.Insert("user2", "passwd2", 2);
db.Insert("user3", "passwd3", 3);
db.Update("user2", "passwd4");
db.Delete("user3");
}
public void loadProductsIntoGridView(int purchaseID)
{
DBConnect dbobj = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_GETPurchases";
objCommand.Parameters.AddWithValue("@PurchaseID", purchaseID);
gvPurchasedProducts.DataSource = dbobj.GetDataSetUsingCmdObj(objCommand);
gvPurchasedProducts.DataBind();
}
//REPEATER METHODS
//load Credit Cards into Repeater [will be removed]
public void loadCreditCards(string email)
{
DBConnect dbobj = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TPgetCustomerCard";
objCommand.Parameters.AddWithValue("@email", email);
DataSet ds = dbobj.GetDataSetUsingCmdObj(objCommand);
rptPaymentOptions.DataSource = ds;
rptPaymentOptions.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserEmail"] != null)
{
db = new DBConnect();
getDetails();
fillDetails();
}
else
Response.Redirect("Index.aspx");
}
protected void initSes()
{
if (Session["UserEmail"] != null)
{
db = new DBConnect();
userData = db.query("SELECT * FROM user LEFT JOIN profile ON user.user_id = "+
"profile.user_id WHERE user.email = '" + Session["UserEmail"].ToString() + "'");
}
else
Response.Redirect("Index.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserEmail"] != null)
{
db = new DBConnect();
initSes();
if(!IsPostBack)
getPublications();
}
else
Response.Redirect("Index.aspx");
}
public Boolean Purchase(String ProductID, int Quantity, String APIKey, string[] customercardinfo)
{
//copied and pasted code from project3ws and modiefied to work with this project
//my verify method was super weird and very specific to the previous project
//however i still use the basic functionality with the verifyinfo stored procedure
DBConnect db = new DBConnect();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "UpdateProduct";
command.Parameters.AddWithValue("@productID", int.Parse(ProductID.ToString()));
command.Parameters.AddWithValue("@quantity", Quantity);
command.Parameters.AddWithValue("@API", APIKey);
db.DoUpdateUsingCmdObj(command);
//-------------------------update product-------------------------------------------------
//-------------------------------update customer--------------------------------------------
SqlCommand hank = new SqlCommand();
hank.CommandType = CommandType.StoredProcedure;
hank.CommandText = "UpdateCustomer";
hank.Parameters.AddWithValue("@Email", customercardinfo[0]);
hank.Parameters.AddWithValue("@productID", int.Parse(ProductID.ToString()));
hank.Parameters.AddWithValue("@Quantity", Quantity);
hank.Parameters.AddWithValue("@Name", customercardinfo[1]);
hank.Parameters.AddWithValue("@ShippingAddress", customercardinfo[2]);
hank.Parameters.AddWithValue("@ShippingCity", customercardinfo[3]);
hank.Parameters.AddWithValue("@ShippingState", customercardinfo[4]);
hank.Parameters.AddWithValue("@ShippingCountry", customercardinfo[5]);
hank.Parameters.AddWithValue("@ShippingZipCode", customercardinfo[6]);
hank.Parameters.AddWithValue("@BillingAddress", customercardinfo[7]);
hank.Parameters.AddWithValue("@BillingCity", customercardinfo[8]);
hank.Parameters.AddWithValue("@BillingState", customercardinfo[9]);
hank.Parameters.AddWithValue("@BillingZip", customercardinfo[10]);
// int RETVAL = 0;
// string tempTest = command.Parameters["@RETVAL"].Value.ToString();
//RETVAL = int.Parse(tempTest);
//SqlCommand c = new SqlCommand();
//c.CommandType = CommandType.StoredProcedure;
//c.CommandText = "TPVerifyInfo";
//c.Parameters.AddWithValue("@CreditCardNum", customercardinfo[11]);
//c.Parameters.AddWithValue("@CVV", customercardinfo[12]);
//db.DoUpdateUsingCmdObj(c);
if (db.DoUpdateUsingCmdObj(hank) > 0)
{
return true;
}
return true;
}
public DataSet GetDepartments()
{
DBConnect DB = new DBConnect();
//This method returns a list of Department Numbers and Department Names from the Department table in your database.
//The Dataset returned by the function consists of 2 columns corresponding to the Department Number and Department Name.
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetDepartments";
DataSet DepDS = DB.GetDataSetUsingCmdObj(command);
DepDS.Tables[0].Columns[0].ColumnName = "DepartmentNumber";
DepDS.Tables[0].Columns[1].ColumnName = "DepartmentName";
return DepDS;
}
//load purchaseIDs into dropdown
public void loadPurchaseIDs()
{
string email = Session["emailSession"].ToString();
DBConnect dbobj = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_GetPurchaseIDs";
objCommand.Parameters.AddWithValue("@email", email);
DataSet ds = dbobj.GetDataSetUsingCmdObj(objCommand);
ddlPurchaseID.DataSource = ds;
ddlPurchaseID.DataTextField = "PurchaseID";
ddlPurchaseID.DataValueField = "PurchaseID";
ddlPurchaseID.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserEmail"] != null)
{
db = new DBConnect();
if (Request["search"] != "")
{
getFollowers();
}
else
Response.Redirect("newsfeed.aspx");
}
else
Response.Redirect("Index.aspx");
}
object cod_GetReaderData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.LaneCount)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
System.Collections.Hashtable laneCount = new System.Collections.Hashtable();
laneCount.Add(0, Convert.ToString(dr[7]));
laneCount.Add(1, Convert.ToString(dr[6]));
laneCount.Add(2, Convert.ToString(dr[5]));
laneCount.Add(3, Convert.ToString(dr[4]));
laneCount.Add(4, Convert.ToString(dr[3]));
laneCount.Add(5, Convert.ToString(dr[2]));
return laneCount;
}
else
return null;
}
//load customer info into Account Settings Field
public void loadCustomerAccountSettings()
{
string email = Session["emailSession"].ToString();
string customerName = lblCustomerName.Text;
string customerEmail = lblEmail.Text;
string password = lblpassword.Text;
DBConnect dbobj = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TP_GetCustNameEmailPw";
objCommand.Parameters.AddWithValue("@email", email);
DataSet ds = dbobj.GetDataSetUsingCmdObj(objCommand);
//Set label values equal to appropriate values from dataset
lblCustomerName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
lblEmail.Text = ds.Tables[0].Rows[0]["Email"].ToString();
lblpassword.Text = ds.Tables[0].Rows[0]["password"].ToString();
}
public DataSet GetProductCatalog(String DepartmentNumber)
{
//This method accepts a Department Number as input and returns a DataSet containing the Product Number, Description, Price,
//and image URL for all products in that Department. Dataset consists of 4 columns corresponding to the Product Number,
//Description, Price, and image URL.
DBConnect DB = new DBConnect();
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "ProductCatalog";
command.Parameters.AddWithValue("@DepartmentNumber", DepartmentNumber);
DataSet ProdDS = DB.GetDataSetUsingCmdObj(command);
ProdDS.Tables[0].Columns[0].ColumnName = "ProductID";
ProdDS.Tables[0].Columns[1].ColumnName = "Description";
ProdDS.Tables[0].Columns[2].ColumnName = "Price";
ProdDS.Tables[0].Columns[3].ColumnName = "QuantityOnHand";
ProdDS.Tables[0].Columns[4].ColumnName = "DepartmentNumber";
ProdDS.Tables[0].Columns[5].ColumnName = "URL";
return ProdDS;
}
static void Main(string[] args)
{
DBConnect DBC = new DBConnect(); // Create an object
DBC.Initialize();
TcpListener server = null;
try
{
int MaxThreadsCount = Environment.ProcessorCount * 4;
ThreadPool.SetMaxThreads(MaxThreadsCount, MaxThreadsCount);
ThreadPool.SetMinThreads(2, 2);
Int32 port = 9595;
IPAddress localAddr = IPAddress.Parse("127.0.0.1");
int counter = 0;
server = new TcpListener(localAddr, port);
server.Start();
while (true)
{
Console.Write("\n\tWaiting for a connection... ");
ThreadPool.QueueUserWorkItem(Connecting, server.AcceptTcpClient());
counter++;
Console.Write("\nConnection №" + counter.ToString() + "!");
}
}
catch (SocketException e)
{
Console.WriteLine("SocketException: {0}", e);
}
finally
{
server.Stop();
}
Console.WriteLine("\nHit enter to continue...");
Console.Read();
}
object com_GetReaderData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.Decorators)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
System.Collections.Hashtable decHT = new System.Collections.Hashtable();
for (int i = 0; i < dr.FieldCount; i++)
{
if (!decHT.ContainsKey(dr.GetName(i))) decHT.Add(dr.GetName(i), dr[i]);
}
return decHT;
}
else if (type == DBConnect.DataType.LaneCount)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
System.Collections.Hashtable laneCount = new System.Collections.Hashtable();
laneCount.Add(0, Convert.ToString(dr[2]));
laneCount.Add(1, Convert.ToString(dr[3]));
laneCount.Add(2, Convert.ToString(dr[4]));
laneCount.Add(3, Convert.ToString(dr[5]));
laneCount.Add(4, Convert.ToString(dr[6]));
laneCount.Add(5, Convert.ToString(dr[7]));
laneCount.Add(6, Convert.ToString(dr[8]));
laneCount.Add(7, Convert.ToString(dr[9]));
laneCount.Add(8, Convert.ToString(dr[10]));
laneCount.Add(9, Convert.ToString(dr[11]));
laneCount.Add(10, Convert.ToString(dr[12]));
laneCount.Add(11, Convert.ToString(dr[13]));
laneCount.Add(12, Convert.ToString(dr[14]));
laneCount.Add(13, Convert.ToString(dr[15]));
laneCount.Add(14, Convert.ToString(dr[16]));
return laneCount;
}
else
return null;
}
public string GetSettingDetail(string strSetting)
{
LogManager.WriteLog("Inside GetSettingDetail method", LogManager.enumLogLevel.Info);
DBConnect oDbConnect = new DBConnect();
return oDbConnect.GetSettingFromDB(strSetting, string.Empty);
}
private void button3_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(UserID))
{
MessageBox.Show("Please select the user ");
return;
}
string type = "";
string deliver = deliveryChk.Checked ? "Yes" : "No";
string followup = followupChk.Checked ? "Yes" : "No";
string pickup = pickupChk.Checked ? "Yes" : "No";
if (deliveryChk.Checked)
{
type = "Delivery";
}
if (followupChk.Checked)
{
type = "Follow up";
}
if (pickupChk.Checked)
{
type = "Pickup";
}
if (string.IsNullOrEmpty(type))
{
MessageBox.Show("Delivery /follow up / pick up ? ");
return;
}
double tax = GenericCollection.caseTransactions.Sum(x => x.Tax);
double amount = GenericCollection.caseTransactions.Sum(x => x.Payable);
string method = "Invoice";
int ItemCount = GenericCollection.caseTransactions.Count();
string ids = Guid.NewGuid().ToString();
Invoice iw = new Invoice(ids, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, "Credit", "Sale", Helper.CompanyName, CustomerID, method, amount, noTxt.Text, tax, amount, amount, amount, ItemCount, userCbx.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
string save = MySQL.Insert(iw);
if (save != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(save), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
}
Dictionary <string, string> transDic = new Dictionary <string, string>();
string id = Guid.NewGuid().ToString();
Delivery i = new Delivery(id, noTxt.Text, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), deliver, followup, pickup, type, PractitionerID, CustomerID, commentTxt.Text, userCbx.Text, Convert.ToDateTime(dateDeliveredTxt.Text).ToString("dd-MM-yyyy"), recievedByTxt.Text, signatureTxt.Text, reasonTxt.Text, recievedByTxt.Text, Convert.ToDouble(totalTxt.Text), DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
string savef = MySQL.Insert(i);
if (savef != "")
{
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(savef), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
string it = t.Id;
if (!transDic.ContainsKey(it))
{
transDic.Add(it, t.Date);
CaseTransaction c = new CaseTransaction(it, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, noTxt.Text, id, t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
DBConnect.UpdateMySql(c, it);
}
}
MessageBox.Show("Information Saved");
this.Close();
}
}
/// <summary>
/// This method must have the implementation of the work that is going to perform by this job.
/// </summary>
public void DoWork()
{
//Dictionary<string, string> dictServiceentries = null;
RegistrySetting oRegistrySetting = null;
try
{
DBConnect oDbConnect = new DBConnect();
// Fix for Read run twice for a day - Begin
if (HourlyDailyEntity.HasReadRunWithHourly)
{
LogManager.WriteLog("Read has been run with Hourly, so skip the daily Read process", LogManager.enumLogLevel.Info);
return;
}
// Fix for Read run twice for a day - End
if (oDbConnect.RunDailyReadService())
{
//dictServiceentries = new Dictionary<string, string>();
oRegistrySetting = new RegistrySetting();
//dictServiceentries.Add(HourlyDailyEntity.sRegistryPath + "\\\\LastAutoRead", DateTime.Now.ToString("dd MMM yyyy"));
//oRegistrySetting.SetRegistryEntries(dictServiceentries, HourlyDailyEntity.sRegistryPath);
BMCRegistryHelper.SetRegKeyValue(HourlyDailyEntity.sRegistryPath, "LastAutoRead", Microsoft.Win32.RegistryValueKind.String, DateTime.Now.ToString("dd MMM yyyy"));
}
//HourlyDailyEventLog.WriteToEventLog(HourlyDailyEntity.EventLogName, "DailyService DoWork: ", "Daily Read has been executed successfully.", EventLogEntryType.SuccessAudit);
}
catch (Exception ex)
{
// HourlyDailyEventLog.WriteToEventLog(HourlyDailyEntity.EventLogName, "DailyService DoWork: ", "Message: " + ex.Message + "Source: " + ex.Source, EventLogEntryType.Error);
ExceptionManager.Publish(ex);
}
}
protected void htdispositivo(object sender, EventArgs e)
{
DBConnect conector = new DBConnect();
string idtipo = htipo.SelectedValue;
DDcapacidad.Items.Clear();
modelo.Text = "";
if ((idtipo == "7") || (idtipo == "9"))
{
if (idtipo == "7")
{
modelo.Visible = false;
DDcapacidad.Visible = true;
DataTable lista = conector.Scapacidaddd();
ListItem opct = new ListItem();
opct.Text = "Seleccione";
opct.Value = "0";
DDcapacidad.Items.Add(opct);
ListItem opctodos = new ListItem();
opctodos.Text = "TODOS";
opctodos.Value = "99";
DDcapacidad.Items.Add(opctodos);
for (int i = 0; i < lista.Rows.Count; i++)
{
ListItem opct2 = new ListItem();
opct2.Text = lista.Rows[i]["nombre"].ToString();
opct2.Value = lista.Rows[i]["id"].ToString();
DDcapacidad.Items.Add(opct2);
}
DDcapacidad.DataBind();
}
if (idtipo == "9")
{
modelo.Visible = false;
DDcapacidad.Visible = true;
DataTable lista = conector.Scapacidadram();
ListItem opct = new ListItem();
opct.Text = "Seleccione";
opct.Value = "0";
DDcapacidad.Items.Add(opct);
ListItem opctodos = new ListItem();
opctodos.Text = "TODOS";
opctodos.Value = "99";
DDcapacidad.Items.Add(opctodos);
for (int i = 0; i < lista.Rows.Count; i++)
{
ListItem opct2 = new ListItem();
opct2.Text = lista.Rows[i]["nombre"].ToString();
opct2.Value = lista.Rows[i]["id"].ToString();
DDcapacidad.Items.Add(opct2);
}
DDcapacidad.DataBind();
}
}
else
{
modelo.Visible = true;
ListItem opct = new ListItem();
opct.Text = "Seleccione";
opct.Value = "0";
DDcapacidad.Items.Add(opct);
DDcapacidad.SelectedItem.Text = "Seleccione";
DDcapacidad.SelectedValue = "0";
DDcapacidad.Visible = false;
}
}
private void btnSubmitAds_Click(object sender, EventArgs e)
{
string title = txtTitle.Text;
//string month = combxMonth.GetItemText(combxMonth.SelectedItem);
//string year = combxYear.GetItemText(combxYear.SelectedItem);
//string date = month + ", " + year;
string date = dtpDate.Text;
string size = txtSize.Text;
string bedroom = txtBedroom.Text;
string bathroom = txtBathroom.Text;
string corridor = txtCorridor.Text;
string rent = txtRent.Text;
string renttype = null;
if (rbtnFixed.Checked)
{
renttype = "(Fixed)";
}
else if (rbtnNegotiable.Checked)
{
renttype = "(Negotiable)";
}
String specialFacility = null;
if (chkLift.Checked == true && chkWifi.Checked == true && chkGenerator.Checked == true)
{
specialFacility = "Lift, Generator, WiFi";
}
else if (chkLift.Checked == true && chkGenerator.Checked == true)
{
specialFacility = "Lift, Generator";
}
else if (chkGenerator.Checked == true && chkWifi.Checked == true)
{
specialFacility = "Generator, WiFi";
}
else if (chkLift.Checked == true && chkWifi.Checked == true)
{
specialFacility = "Lift, WiFi";
}
else if (chkLift.Checked)
{
specialFacility = "Lift";
}
else if (chkGenerator.Checked)
{
specialFacility = "Generator";
}
else if (chkWifi.Checked)
{
specialFacility = "WiFi";
}
string address = txtAddress.Text;
string city = combxCity.GetItemText(combxCity.SelectedItem);
string area = combxArea.GetItemText(combxArea.SelectedItem);
string details = txtDetails.Text;
string ownerName = txtOwnerName.Text;
string ownerEmail = txtOwnerEmail.Text;
string ownerPhone = txtOwnerPhone.Text;
SavePicture();
try
{
DBConnect dbc = new DBConnect();
string query = "insert into FlatDetails(userid, title, date, size, bedroom, bathroom, corridor, rent, renttype, specialfacility, address, city, area, details, name, email, phone, photo) values("
+ userid + ",'" + title + "','" + date + "'," + size + "," + bedroom + "," + bathroom + "," + corridor + ","
+ rent + ",'" + renttype + "','" + specialFacility + "','" + address + "','" + city + "','" + area + "','"
+ details + "','" + ownerName + "','" + ownerEmail + "','" + ownerPhone + "','" + dpath + "' " + ");";
dbc.InsertIntoDatabase(query);
MessageBox.Show("Ads Posted! Wait For Verification");
OwnerHomePage ohp = new OwnerHomePage(userid, status);
ohp.Show();
this.Hide();
}
catch (Exception er)
{
MessageBox.Show("Enter All Data Correctly");
Console.WriteLine("Error : " + er);
}
}
public GuestRepository(DBConnect db) : base(db)
{
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Server.HtmlEncode(Request.QueryString["id"]);
string fechasol = "";
string departamento = "";
string solicitante = "";
string sa = "";
string ss = "";
string so = "";
string app = "";
string win = "";
string off = "";
string otr = "";
string observacioness = "";
string scpu = "";
string impresora = "";
string monitor = "";
string teclado = "";
string mouse = "";
string regulador = "";
string conexionr = "";
string conexioni = "";
string observacionesh = "";
string fecharesp = "";
string soporte = "";
string falla = "";
string observacionesf = "";
string solucion = "";
DBConnect conector = new DBConnect();
DataTable listado = conector.Srespuesta(id);
for (int i = 0; i < listado.Rows.Count; i++)
{
ListItem opcion = new ListItem();
fechasol = listado.Rows[i][1].ToString();
departamento = listado.Rows[i][2].ToString();
solicitante = listado.Rows[i][3].ToString();
fecharesp = listado.Rows[i][4].ToString();
soporte = listado.Rows[i][5].ToString();
falla = listado.Rows[i][6].ToString();
observacionesf = listado.Rows[i][7].ToString();
solucion = listado.Rows[i][8].ToString();
sa = listado.Rows[i][9].ToString();
ss = listado.Rows[i][10].ToString();
so = listado.Rows[i][11].ToString();
app = listado.Rows[i][12].ToString();
win = listado.Rows[i][13].ToString();
off = listado.Rows[i][14].ToString();
otr = listado.Rows[i][15].ToString();
observacioness = listado.Rows[i][16].ToString();
scpu = listado.Rows[i][17].ToString();
impresora = listado.Rows[i][18].ToString();
monitor = listado.Rows[i][19].ToString();
teclado = listado.Rows[i][20].ToString();
mouse = listado.Rows[i][21].ToString();
regulador = listado.Rows[i][22].ToString();
conexionr = listado.Rows[i][23].ToString();
conexioni = listado.Rows[i][24].ToString();
observacionesh = listado.Rows[i][25].ToString();
}
Response.ContentType = "application/pdf";
//System.Web.HttpContext.Current.Server.MapPath
sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezadorpt.gif"), "encabezado");
myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
/*Table's creation*/
sharpPDF.pdfPage myFirstPage = myDoc.addPage();
sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
myTable.borderSize = 1;
myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
myTable.coordX = 60;
myTable.coordY = 640;
myTable.tableHeader.addColumn(100);
myTable.tableHeader.addColumn(210);
myTable.tableHeader.addColumn(67);
myTable.tableHeader.addColumn(115);
myFirstPage.addImage(myDoc.getImageReference("encabezado"), 50, 700);
myFirstPage.addText("SOLICITUD DE SERVICIO", 60, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
myRow[0].addText("Departamento:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow[1].addText(departamento, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow[2].addText("Telefono:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow[3].addText("0243-2721295", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myTable.addRow(myRow);
myRow = null;
myFirstPage.addTable(myTable, 600);
sharpPDF.Tables.pdfTable myTable2 = new sharpPDF.Tables.pdfTable(myDoc);
myTable2.borderSize = 1;
myTable2.borderColor = new sharpPDF.pdfColor(0, 0, 0);
myTable2.coordX = 60;
myTable2.coordY = 617;
myTable2.tableHeader.addColumn(146);
myTable2.tableHeader.addColumn(164);
myTable2.tableHeader.addColumn(49);
myTable2.tableHeader.addColumn(133);
sharpPDF.Tables.pdfTableRow myRow2 = myTable2.createRow();
myRow2[0].addText("Nombre del Solicitante:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow2[1].addText(solicitante, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow2[2].addText("Fecha:", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myRow2[3].addText(fechasol, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 12, new sharpPDF.pdfColor(0, 51, 153));
myTable2.addRow(myRow2);
myRow2 = null;
myFirstPage.addTable(myTable2, 600);
myFirstPage.addText("Descripcion del Tipo de Falla", 60, 580, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12);
myFirstPage.drawRectangle(60, 578, 552, 497, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Software", 65, 560, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
if (sa == "1")
{
myFirstPage.drawRectangle(65, 540, 75, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Sistemas Administrativos", 80, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(65, 540, 75, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Sistemas Administrativos", 80, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (ss == "1")
{
myFirstPage.drawRectangle(220, 540, 230, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Sistemas de Salud", 235, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(220, 540, 230, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Sistemas de Salud", 235, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (so == "1")
{
myFirstPage.drawRectangle(340, 540, 350, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Sistema Operativo", 355, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(340, 540, 350, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Sistema Operativo", 355, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (app == "1")
{
myFirstPage.drawRectangle(460, 540, 470, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Aplicaciones", 475, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(460, 540, 470, 550, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Aplicaciones", 475, 540, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (win == "1")
{
myFirstPage.drawRectangle(65, 520, 75, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Windows", 80, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(65, 520, 75, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Windows", 80, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (off == "1")
{
myFirstPage.drawRectangle(220, 520, 230, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Office", 235, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(220, 520, 230, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Office", 235, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (otr == "1")
{
myFirstPage.drawRectangle(340, 520, 350, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Otro", 355, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(340, 520, 350, 530, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Otro", 355, 520, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
myFirstPage.addText(observacioness, 65, 500, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
/// hardware
myFirstPage.drawRectangle(60, 497, 552, 409, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Hardware", 65, 477, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
if (scpu == "1")
{
myFirstPage.drawRectangle(65, 457, 75, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("C.P.U.", 80, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(65, 457, 75, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("C.P.U.", 80, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (impresora == "1")
{
myFirstPage.drawRectangle(220, 457, 230, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Impresora", 235, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(220, 457, 230, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Impresora", 235, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (monitor == "1")
{
myFirstPage.drawRectangle(340, 457, 350, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Monitor", 355, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(340, 457, 350, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Monitor", 355, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (teclado == "1")
{
myFirstPage.drawRectangle(460, 457, 470, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Teclado", 475, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(460, 457, 470, 467, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Teclado", 475, 457, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (mouse == "1")
{
myFirstPage.drawRectangle(65, 437, 75, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Mouse", 80, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(65, 437, 75, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Mouse", 80, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (regulador == "1")
{
myFirstPage.drawRectangle(220, 437, 230, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Regulador", 235, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(220, 437, 230, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Regulador", 235, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (conexionr == "1")
{
myFirstPage.drawRectangle(340, 437, 350, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Conexion de Red", 355, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(340, 437, 350, 447, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Conexion de Red", 355, 437, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
if (conexioni == "1")
{
myFirstPage.drawRectangle(65, 417, 75, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(0, 0, 0));
myFirstPage.addText("Conexion de Internet", 80, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
else
{
myFirstPage.drawRectangle(65, 417, 75, 427, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Conexion de Internet", 80, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
}
myFirstPage.addText(observacioness, 220, 417, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Datos del Servicio", 200, 395, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(60, 390, 552, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(276, 390, 552, 375, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Conforme Notificacion", 280, 377, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(276, 375, 414, 360, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Firma Solicitante", 280, 362, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(414, 375, 552, 360, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Firma Tecnico", 416, 362, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(276, 360, 414, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(414, 360, 552, 320, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Fecha de notificacion al Tecnico:", 75, 375, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText(fechasol, 90, 360, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(60, 320, 552, 250, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Falla Encontrada:", 70, 310, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText(falla, 180, 310, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Solucion Aplicada:", 70, 285, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText(solucion, 180, 285, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Observaciones:", 70, 260, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText(observacionesf, 180, 260, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Finalizacion del Servicio", 60, 240, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(60, 230, 552, 150, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(226, 230, 552, 215, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Certifico la solucion del problema y que el equipo queda 100% operativo", 228, 218, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 10, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.drawRectangle(226, 215, 552, 200, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(389, 215, 552, 200, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(226, 200, 552, 150, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.drawRectangle(389, 200, 552, 150, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("Firma y Sello Solicitante", 228, 202, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Firma Tecnico", 391, 202, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("Fecha de Finalizacion", 65, 215, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("del Servicio:", 65, 200, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText(fecharesp, 65, 160, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 12, new sharpPDF.pdfColor(0, 51, 153));
myTable = null;
myFirstPage = null;
myDoc.createPDF(Response.OutputStream);
myDoc = null;
}
protected void btnCreateItem_Click(object sender, EventArgs e)
{
string name = txtItemName.Text;
string price = txtItemPrice.Text;
string image = fleuplItemImage.FileName;
string type = ddlType.SelectedValue.ToString();
if (validate.checkBuildItem(name, price, image, type) == 1)
{
Response.Write(@"<script langauge='text/javascript'>alert
('Please fill out all fields');</script>");
return;
}
else if (validate.checkBuildItem(name, price, image, type) == 2)
{
Response.Write(@"<script langauge='text/javascript'>alert
('The price should only represented with numbers and a '.' inbetween');</script>");
return;
}
else
{
DBConnect objDB = new DBConnect();
SqlCommand objCommand = new SqlCommand();
string fileName = "";
string photoPath = "";
string fileExtension = "";
dbCommand.Parameters.Clear();
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "TP_NewMenuItem";
SqlParameter inputItemName = new SqlParameter("@ItemName", txtItemName.Text);
SqlParameter inputItemType = new SqlParameter("@ItemType", ddlType.SelectedValue.ToString());
SqlParameter inputItemPrice = new SqlParameter("@ItemPrice", double.Parse(txtItemPrice.Text));
SqlParameter inputItemEmail = new SqlParameter("@Email", email);
SqlParameter inputPhoto = new SqlParameter();
if (fleuplItemImage.HasFile)
{
fileName = fleuplItemImage.FileName;
fileExtension = fileName.Substring(fileName.LastIndexOf("."));
if (fileExtension == ".jpg" || fileExtension == ".jpeg" || fileExtension == ".bmp" || fileExtension == ".gif" || fileExtension == ".png")
{
photoPath = "~/images/" + fileName;
fleuplItemImage.SaveAs(Server.MapPath(@"~\images\" + fileName));
inputPhoto = new SqlParameter("@ItemPhoto", photoPath);
}
}
inputItemName.Direction = ParameterDirection.Input;
inputItemName.SqlDbType = SqlDbType.VarChar;
inputItemType.Direction = ParameterDirection.Input;
inputItemType.SqlDbType = SqlDbType.VarChar;
inputItemPrice.Direction = ParameterDirection.Input;
inputItemPrice.SqlDbType = SqlDbType.Float;
inputItemEmail.Direction = ParameterDirection.Input;
inputItemEmail.SqlDbType = SqlDbType.VarChar;
inputItemEmail.Direction = ParameterDirection.Input;
inputItemEmail.SqlDbType = SqlDbType.VarChar;
dbCommand.Parameters.Add(inputItemName);
dbCommand.Parameters.Add(inputItemType);
dbCommand.Parameters.Add(inputItemPrice);
dbCommand.Parameters.Add(inputItemEmail);
dbCommand.Parameters.Add(inputPhoto);
int countMenuItem = db.DoUpdateUsingCmdObj(dbCommand);
int menuID;
menuID = GetMenuID(txtItemName.Text, email);
Session["MenuID"] = menuID;
if (menuID >= 1)
{
btnCreateItem.Enabled = false;
txtItemName.Enabled = false;
txtItemPrice.Enabled = false;
fleuplItemImage.Enabled = false;
gvAddOn.Visible = true;
lblAddOns.Visible = true;
lblAddOns.Text = "Create Item Add Ons";
btnNewAddOn.Visible = true;
ddlType.Enabled = false;
}
}
}
public ProfilRepository(DBConnect db) : base(db)
{
}
private void CargarGrid()
{
DBConnect conexion = new DBConnect();
DataTable datos = conexion.SAllPCs();
DataTable datos3 = new DataTable();
DataTable datos4 = new DataTable();
DataColumn columna1 = new DataColumn("Id");
DataColumn columna2 = new DataColumn("Nombre");
DataColumn columna3 = new DataColumn("Responsable");
DataColumn columna4 = new DataColumn("Departamento");
columna1.AllowDBNull = true;
columna2.AllowDBNull = true;
columna3.AllowDBNull = true;
columna4.AllowDBNull = true;
datos3.Columns.Add(columna1);
datos3.Columns.Add(columna2);
datos3.Columns.Add(columna3);
datos3.Columns.Add(columna4);
int rec = 0;
if (datos.Rows.Count > 0)
{
for (rec = 0; rec < datos.Rows.Count; rec++)
{
DataRow dr = datos3.NewRow();
dr["Id"] = datos.Rows[rec]["Id"].ToString();
dr["Nombre"] = datos.Rows[rec]["Nombre"].ToString();;
dr["Responsable"] = datos.Rows[rec]["Responsable"].ToString();
dr["Departamento"] = datos.Rows[rec]["Departamento"].ToString();;
datos3.Rows.Add(dr);
}
GridView1.DataSource = datos3;
GridView1.DataBind();
}
else
{
DataColumn columna5 = new DataColumn("Id");
DataColumn columna6 = new DataColumn("Nombre");
DataColumn columna7 = new DataColumn("Responsable");
DataColumn columna8 = new DataColumn("Departamento");
columna5.AllowDBNull = true;
columna6.AllowDBNull = true;
columna7.AllowDBNull = true;
columna8.AllowDBNull = true;
datos4.Columns.Add(columna5);
datos4.Columns.Add(columna6);
datos4.Columns.Add(columna7);
datos4.Columns.Add(columna8);
DataRow dr3 = datos4.NewRow();
dr3["Id"] = null;
dr3["Nombre"] = null;
dr3["Responsable"] = null;
dr3["Departamento"] = null;
datos4.Rows.Add(dr3);
GridView1.DataSource = datos4;
GridView1.DataBind();
int TotalColumns = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GridView1.Rows[0].Cells[0].Text = "No existen Equipos!!";
}
}
public displaytest()
{
dbConnect = new DBConnect();
InitializeComponent();
}
private void CargarGrid()
{
if (Session["Session"] != null)
{
string hmedico = (string)this.Session["hmedico"];
string tipousuario = (string)this.Session["tipousuario"];
DateTime dt = DateTime.Now;
int d = dt.Day;
int m = dt.Month;
int y = dt.Year;
string dia;
string mes;
if (d < 10)
{
dia = "0" + Convert.ToString(d);
}
else
{
dia = Convert.ToString(d);
}
if (m < 10)
{
mes = "0" + Convert.ToString(m);
}
else
{
mes = Convert.ToString(m);
}
string fecha = y + "-" + mes + "-" + dia;
DBConnect conexion = new DBConnect();
DataTable datos = new DataTable();
if (tipousuario == "9")
{
datos = conexion.SPacCardAD("14", hmedico, fecha);
}
else
{
datos = conexion.SPacCardADADM("14", fecha);
}
if (datos.Rows.Count > 0)
{
GridView1.DataSource = datos;
GridView1.DataBind();
GridView1.SelectedIndex = 0;
}
else
{
DataTable datos2 = new DataTable();
DataColumn columna1 = new DataColumn("Numero");
DataColumn columna2 = new DataColumn("Nombre");
DataColumn columna3 = new DataColumn("Cedula");
DataColumn columna4 = new DataColumn("Edad");
DataColumn columna5 = new DataColumn("Sexo");
columna1.AllowDBNull = true;
columna2.AllowDBNull = true;
columna3.AllowDBNull = true;
columna4.AllowDBNull = true;
columna5.AllowDBNull = true;
datos2.Columns.Add(columna1);
datos2.Columns.Add(columna2);
datos2.Columns.Add(columna3);
datos2.Columns.Add(columna4);
datos2.Columns.Add(columna5);
DataRow dr = datos2.NewRow();
dr["Numero"] = null;
dr["Nombre"] = null;
dr["Cedula"] = null;
dr["Edad"] = null;
dr["Sexo"] = null;
datos2.Rows.Add(dr);
GridView1.DataSource = datos2;
GridView1.DataBind();
int TotalColumns = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GridView1.Rows[0].Cells[0].Text = "No existen pacientes por atender!!";
}
}
else
{
string devuelveFecha = "<script language='JavaScript'>" +
"window.document.forms[0].target = '_parent'; window.document.forms[0].action = '../salida.aspx';" +
"window.document.forms[0].submit(); </script>";
ClientScript.RegisterStartupScript(this.GetType(), "CambiaTarget", devuelveFecha);
}
}
protected void gridView_SelectedIndex(object sender, EventArgs e)
{
if (Session["Session"] != null)
{
string hmedico = (string)this.Session["hmedico"];
string tipousuario = (string)this.Session["tipousuario"];
DateTime dt = DateTime.Now;
int d = dt.Day;
int m = dt.Month;
int y = dt.Year;
string dia;
string mes;
if (d < 10)
{
dia = "0" + Convert.ToString(d);
}
else
{
dia = Convert.ToString(d);
}
if (m < 10)
{
mes = "0" + Convert.ToString(m);
}
else
{
mes = Convert.ToString(m);
}
string fecha = y + "-" + mes + "-" + dia;
DBConnect conexion = new DBConnect();
DataTable datos = new DataTable();
Label Lblnumero = GridView1.Rows[Convert.ToInt32(GridView1.SelectedIndex.ToString())].FindControl("Lblnumero") as Label;
Label Lblnombre = GridView1.Rows[Convert.ToInt32(GridView1.SelectedIndex.ToString())].FindControl("Lblnombre") as Label;
Label Lblcedula = GridView1.Rows[Convert.ToInt32(GridView1.SelectedIndex.ToString())].FindControl("Lblcedula") as Label;
Label Lbledad = GridView1.Rows[Convert.ToInt32(GridView1.SelectedIndex.ToString())].FindControl("Lbledad") as Label;
Label Lblsexo = GridView1.Rows[Convert.ToInt32(GridView1.SelectedIndex.ToString())].FindControl("Lblsexo") as Label;
string numero = Lblnumero.Text;
string nombre = Lblnombre.Text;
string cedula = Lblcedula.Text;
string edad = Lbledad.Text;
string sexo = Lblsexo.Text;
string hdocumento = "";
string hpaciente = "";
if (tipousuario == "9")
{
datos = conexion.SPacCardADIND(numero, "14", hmedico, fecha);
for (int i = 0; i < datos.Rows.Count; i++)
{
hdocumento = datos.Rows[i]["hdocumento"].ToString();
hpaciente = datos.Rows[i]["hpaciente"].ToString();
}
}
else
{
datos = conexion.SPacCardADADMIND(numero, "14", fecha);
for (int i = 0; i < datos.Rows.Count; i++)
{
hdocumento = datos.Rows[i]["hdocumento"].ToString();
hpaciente = datos.Rows[i]["hpaciente"].ToString();
}
}
Button1.Enabled = true;
Button2.Enabled = false;
vhdocumento.Value = hdocumento;
vhpaciente.Value = hpaciente;
}
else
{
string devuelveFecha = "<script language='JavaScript'>" +
"window.document.forms[0].target = '_parent'; window.document.forms[0].action = '../salida.aspx';" +
"window.document.forms[0].submit(); </script>";
ClientScript.RegisterStartupScript(this.GetType(), "CambiaTarget", devuelveFecha);
}
}
protected void RegisterUserButton_Click(object sender, EventArgs e)
{
//Validate
ValidateUserRegistration();
if (UserRegistrationError.Count == 0)
{
//Check if email already exist
String UserEmail = RegisterEmailTxtBox.Text;
Boolean flag = CheckIfEmailExist(UserEmail);
if (flag == true)
{
Response.Write("Email already exist");
}
else
{
//Register
DBConnect dbConnection = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TPRegisterUser";
SqlParameter inputParameter = new SqlParameter("@Email", RegisterEmailTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.NVarChar;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@Name", RegisterNameTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@Address", RegisterAddressTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@City", CityTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@Zip", int.Parse(ZipTxtBox.Text.ToString()));
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.Int;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@Password", RegisterPasswordTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
inputParameter = new SqlParameter("@State", StateTxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
int ResponseReceived = dbConnection.DoUpdateUsingCmdObj(objCommand);
if (ResponseReceived == 1)
{
//User Registered
//Save UserEmail in Session Called UserEmail
Session.Add("userEmail", RegisterEmailTxtBox.Text.ToString());
RegisterUserDetails.Visible = false;
PrivacyQuestionsDiv.Visible = true;
}
else
{
Response.Write("Error Occured on the DATABASE");
}
}
}
else
{
for (int i = 0; i < UserRegistrationError.Count; i++)
{
Response.Write(UserRegistrationError[i] + "<br/>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DataTable temp = (DataTable)Session["temporal"];
temp.DefaultView.RowFilter = string.Format("htipo = 9");
DataTable DTram = temp.DefaultView.ToTable();
string ide = Server.HtmlEncode(Request.QueryString["id"]);
idequipo.Value = ide;
DBConnect conexion = new DBConnect();
idmram.Value = ide + Convert.ToString(DTram.Rows.Count);
int instalados = DTram.Rows.Count;
CargarGrid();
Label1.Text = "Número de Modulos: " + Convert.ToString(instalados);
HiddenField1.Value = Convert.ToString(DTram.Rows.Count);
if (!IsPostBack)
{
htipo.Items.Clear();
}
DataTable lista = conexion.Scapacidadram();
ListItem opct = new ListItem();
opct.Text = "Seleccione";
opct.Value = "0";
capacidadram.Items.Add(opct);
for (int i = 0; i < lista.Rows.Count; i++)
{
ListItem opct2 = new ListItem();
opct2.Text = lista.Rows[i]["nombre"].ToString();
opct2.Value = lista.Rows[i]["id"].ToString();
capacidadram.Items.Add(opct2);
}
capacidadram.DataBind();
DataTable lsoporte = conexion.Shtdispositivo("9");
ListItem inicio = new ListItem();
inicio.Text = "Seleccione";
inicio.Value = "0";
htipo.Items.Add(inicio);
for (int i = 0; i < lsoporte.Rows.Count; i++)
{
ListItem opcion = new ListItem();
opcion.Text = lsoporte.Rows[i]["nombre"].ToString();
opcion.Value = lsoporte.Rows[i]["id"].ToString();
htipo.Items.Add(opcion);
}
htipo.DataBind();
if (instalados > 3)
{
TextBox1.Enabled = false;
TextBox2.Enabled = false;
TextBox3.Enabled = false;
capacidadram.Enabled = false;
Button1.Enabled = false;
}
else
{
TextBox1.Enabled = true;
TextBox2.Enabled = true;
TextBox3.Enabled = true;
capacidadram.Enabled = true;
Button1.Enabled = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserEmail"] != null)
{
db = new DBConnect();
user_id = Request["user"].ToString();
//Dataset Storing all Proflie's data
profileData = db.query(String.Format("SELECT user.user_id,user.name,user.lastname,user.gender "+
" ,user.online,profile.url,profile.relationship,profile.looking_for,profile_photo.file_name"+
" FROM user LEFT JOIN profile ON (user.user_id = profile.user_id) LEFT JOIN profile_photo"+
" ON (profile_photo.user_id = user.user_id) WHERE profile.url= '{0}' ",user_id));
//Variables to store Current Browser's name,last name
user_browsing_dt = db.query(String.Format("SELECT user.user_id,user.name,user.lastname"+
" FROM user WHERE user.email = '{0}'", Session["UserEmail"].ToString()));
user_browsing_name = String.Format("{0} {1}", user_browsing_dt.Rows[0]["name"].ToString()
, user_browsing_dt.Rows[0]["lastname"].ToString());
if(profileData.Rows.Count == 0 )
Response.Redirect("newsfeed.aspx");
else
initProfile();
if(!IsPostBack)
getPublications();
}
else
Response.Redirect("Index.aspx");
friendprof1.ToolTip = "@nombre del amigo";
friendprof2.ToolTip = "@nombre del amigo";
friendprof3.ToolTip = "@nombre del amigo";
friendprof4.ToolTip = "@nombre del amigo";
friendprof5.ToolTip = "@nombre del amigo";
friendprof6.ToolTip = "@nombre del amigo";
friendprof7.ToolTip = "@nombre del amigo";
friendprof8.ToolTip = "@nombre del amigo";
}
public UserOBJ GetProfile(String requestingEmail, String requestedEmail, String token)
{
DBConnect objDB = new DBConnect();
UserOBJ thisUser = new UserOBJ();
SqlCommand LoginUser = new SqlCommand();
LoginUser.CommandType = CommandType.StoredProcedure;
LoginUser.CommandText = "TP_FindUser";
LoginUser.Parameters.AddWithValue("@Email", requestingEmail);
LoginUser.Parameters.AddWithValue("@Password", decode(token));
SqlParameter outputPar = new SqlParameter("@Out", SqlDbType.Int, 50);
outputPar.Direction = ParameterDirection.Output;
LoginUser.Parameters.Add(outputPar);
objDB.GetDataSetUsingCmdObj(LoginUser);
//check token to see if user is logged in with same Email and pass
string a = LoginUser.Parameters["@Out"].Value.ToString();
if (a.Equals("1"))
{
SqlCommand FindSettings = new SqlCommand();
FindSettings.CommandType = CommandType.StoredProcedure;
FindSettings.CommandText = "TP_FindUserSettings";
FindSettings.Parameters.AddWithValue("@Email", requestedEmail);
DataSet Settings = objDB.GetDataSetUsingCmdObj(FindSettings);
SettingsOBJ mySettings = new SettingsOBJ();
foreach (DataRow UserSetting in Settings.Tables[0].Rows)
{
mySettings.Login = UserSetting["LoginSetting"].ToString();
mySettings.Personal = UserSetting["PersonalContactSetting"].ToString();
mySettings.Photos = UserSetting["PhotoSetting"].ToString();
mySettings.Profile = UserSetting["ProfileInfoSetting"].ToString();
}
SqlCommand FindUsers = new SqlCommand();
FindUsers.CommandType = CommandType.StoredProcedure;
FindUsers.CommandText = "TP_FindUserByEmail";
FindUsers.Parameters.Clear();
FindUsers.Parameters.AddWithValue("@Email", requestedEmail);
DataSet Friend = objDB.GetDataSetUsingCmdObj(FindUsers);
if (requestingEmail != requestedEmail)
{
SqlCommand CheckFriends = new SqlCommand();
CheckFriends.CommandType = CommandType.StoredProcedure;
CheckFriends.CommandText = "TP_ChecksFriendship";
CheckFriends.Parameters.AddWithValue("@Email1", requestingEmail);
CheckFriends.Parameters.AddWithValue("@Email2", requestedEmail);
SqlParameter outputPar1 = new SqlParameter("@found", SqlDbType.Int, 50);
outputPar1.Direction = ParameterDirection.Output;
CheckFriends.Parameters.Add(outputPar1);
objDB.GetDataSetUsingCmdObj(CheckFriends).ToString();
string Friends = CheckFriends.Parameters["@found"].Value.ToString();
//SqlCommand CheckFriendsofFriends = new SqlCommand();
//CheckFriendsofFriends.CommandType = CommandType.StoredProcedure;
//CheckFriendsofFriends.CommandText = "TP_ChecksFriendship";
//CheckFriendsofFriends.Parameters.AddWithValue("@Email1", requestingEmail);
//CheckFriendsofFriends.Parameters.AddWithValue("@Email2", requestedEmail);
//string FriendsofFriends = objDB.GetDataSetUsingCmdObj(CheckFriendsofFriends).ToString();
switch (mySettings.Profile)
{
case "Public":
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = UserInfo["First_Name"].ToString();
thisUser.Last = UserInfo["Last_Name"].ToString();
thisUser.Email = UserInfo["Email"].ToString();
if (mySettings.Personal == "Public")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else if (mySettings.Personal == "Only Friends")
{
if (Friends == "1")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else
{
thisUser.Phone = "Only Friends can view this info";
}
}
thisUser.City = UserInfo["City"].ToString();
thisUser.State = UserInfo["State"].ToString();
thisUser.Organization = UserInfo["Organization"].ToString();
thisUser.ProfileURL = UserInfo["ProfilePhotoURL"].ToString();
return(thisUser);
}
break;
case "Only Friends":
if (Friends == "1")
{
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = UserInfo["First_Name"].ToString();
thisUser.Email = UserInfo["Email"].ToString();
thisUser.Last = UserInfo["Last_Name"].ToString();
if (mySettings.Personal == "Public")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else if (mySettings.Personal == "Only Friends")
{
if (Friends == "1")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else
{
thisUser.Phone = "Only Friends can view this info";
}
}
thisUser.City = UserInfo["City"].ToString();
thisUser.State = UserInfo["State"].ToString();
thisUser.Organization = UserInfo["Organization"].ToString();
thisUser.ProfileURL = UserInfo["ProfilePhotoURL"].ToString();
return(thisUser);
}
}
else
{
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = "";
thisUser.Last = "";
thisUser.Email = "";
thisUser.City = "";
thisUser.Phone = "";
thisUser.State = "";
thisUser.Organization = "";
thisUser.ProfileURL = "";
return(thisUser);
}
}
break;
case "Friends and Friends of Friends":
if (Friends == "1")
{
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = UserInfo["First_Name"].ToString();
thisUser.Last = UserInfo["Last_Name"].ToString();
thisUser.Email = UserInfo["Email"].ToString();
thisUser.City = UserInfo["City"].ToString();
if (mySettings.Personal == "Public")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else if (mySettings.Personal == "Only Friends")
{
if (Friends == "1")
{
thisUser.Phone = UserInfo["Phone#"].ToString();
}
else
{
thisUser.Phone = "Only Friends can view this info";
}
}
thisUser.State = UserInfo["State"].ToString();
thisUser.Organization = UserInfo["Organization"].ToString();
thisUser.ProfileURL = UserInfo["ProfilePhotoURL"].ToString();
return(thisUser);
}
}
else
{
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = "";
thisUser.Last = "";
thisUser.Email = "";
thisUser.City = "";
thisUser.Phone = "";
thisUser.State = "";
thisUser.Organization = "";
thisUser.ProfileURL = "";
return(thisUser);
}
}
break;
}
}
else
{
foreach (DataRow UserInfo in Friend.Tables[0].Rows)
{
thisUser = new UserOBJ();
thisUser.First = UserInfo["First_Name"].ToString();
thisUser.Last = UserInfo["Last_Name"].ToString();
thisUser.Email = UserInfo["Email"].ToString();
thisUser.City = UserInfo["City"].ToString();
thisUser.Phone = UserInfo["Phone#"].ToString();
thisUser.State = UserInfo["State"].ToString();
thisUser.Organization = UserInfo["Organization"].ToString();
thisUser.ProfileURL = UserInfo["ProfilePhotoURL"].ToString();
return(thisUser);
}
}
}
return(thisUser);
}
public IActionResult OnPost()
{
ActiveRecord = new SessionActive();
ActiveRecord.Active_SessionID = HttpContext.Session.GetString(Session_SessionID);
ActiveRecord.Active_EmailAddress = HttpContext.Session.GetString(Session_EmailAddress);
ActiveRecord.Active_FirstName = HttpContext.Session.GetString(Session_FirstName);
ActiveRecord.Active_ModLevel = HttpContext.Session.GetInt32(Session_ModLevel);
// if session isn't active then redirect to login page
if (string.IsNullOrEmpty(ActiveRecord.Active_EmailAddress) && string.IsNullOrEmpty(ActiveRecord.Active_FirstName) && string.IsNullOrEmpty(ActiveRecord.Active_SessionID))
{
ActiveRecord.Active_Sesson = false;
return(RedirectToPage("/Login/Login"));
}
else
{
ActiveRecord.Active_Sesson = true;
}
// get database connection
DBConnect G24database_connection = new DBConnect();
string DBconnection = G24database_connection.DatabaseString();
SqlConnection connect = new SqlConnection(DBconnection);
connect.Open();
//create the file path to upload the image to
const string Path2 = "ImgUploads";
var FileToUpload = Path.Combine(_env.WebRootPath, Path2, ImgFile.FileName);
// upload the image on the filestream
using (var Fstream = new FileStream(FileToUpload, FileMode.Create))
{
ImgFile.CopyTo(Fstream);
}
using (SqlCommand command = new SqlCommand())
{
command.Connection = connect;
// insert the images data into the database
command.CommandText = @"INSERT INTO Images ( ImgURL, Type, ImgName, UserID) VALUES ( @ImgURL, @Type, @ImgName, @UserID)";
command.Parameters.AddWithValue("@ImgURL", ImgFile.FileName);
command.Parameters.AddWithValue("@Type", Tidy_case(ImgRecord.Type));
command.Parameters.AddWithValue("@ImgName", ImgRecord.ImgName);
command.Parameters.AddWithValue("@UserID", ImgRecord.UserID);
command.ExecuteNonQuery();
}
using (SqlCommand ID_command = new SqlCommand())
{
ID_command.Connection = connect;
ID_command.CommandText = @"SELECT ImgID FROM Images WHERE ImgURL = @ImgURL";
ID_command.Parameters.AddWithValue("@ImgURL", ImgFile.FileName);
SqlDataReader ID_reader = ID_command.ExecuteReader();
while (ID_reader.Read())
{
uploadID = ID_reader.GetInt32(0);
}
}
//close database connection
connect.Close();
// redirects to the image page for the image uploaded passing through the image ID
return(RedirectToPage("/ImgController/Index", new { imgid = uploadID }));
}
// BaseControlのコンストラクタ。DBConnectクラスのインスタンスを作成します。
public BaseControl(string dbName)
{
// データベースをオープンする
DBConnect = new DBConnect(dbName);
}
public int[] GetTimeline(int userId)
{
//string path = "https://localhost:44386/api/User/";
//WebRequest request = WebRequest.Create(path + "GetFriends/" + userId);
//WebResponse response = request.GetResponse();
//Stream theDataStream = response.GetResponseStream();
//StreamReader reader = new StreamReader(theDataStream);
//String data = reader.ReadToEnd();
//reader.Close();
//response.Close();
//JavaScriptSerializer js = new JavaScriptSerializer();
//User[] friends = js.Deserialize<User[]>(data);
DBConnect objDB = new DBConnect();
// get the friend 2 if the FriendReq has them as friend 1
string sqlString = "" +
"SELECT f2.UserId, f2.FirstName, f2.LastName, f2.Email, " +
"f2.ProfilePicture, f2.Bio, f2.City, " +
"f2.State, f2.Interests, f2.Verified " +
"FROM TP_Users f1 INNER JOIN TP_FriendRequests rec " +
"ON f1.UserId=rec.Friend1Id " +
"INNER JOIN TP_Users f2 " +
"ON rec.Friend2Id=f2.UserId " +
"WHERE f1.UserId=" + userId + " " +
"AND Accept=1";
DataSet ds = objDB.GetDataSet(sqlString);
List <int> timelineUsers = new List <int>();
timelineUsers.Add(userId);
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
User user = new User();
DataRow record = ds.Tables[0].Rows[i];
user.UserId = int.Parse(record["UserId"].ToString());
user.FirstName = record["FirstName"].ToString();
user.LastName = record["LastName"].ToString();
user.Email = record["Email"].ToString();
user.Bio = record["Bio"].ToString();
user.City = record["City"].ToString();
user.State = record["State"].ToString();
user.Interests = record["Interests"].ToString();
user.Verified = record["Verified"].ToString();
timelineUsers.Add(user.UserId);
}
}
// get the friend 1 if the FriendReq has them as friend 2
sqlString = "SELECT f1.UserId, f1.FirstName, f1.LastName, f1.Email, " +
"f1.ProfilePicture, f1.Bio, f1.City, " +
"f1.State, f1.Interests, f1.Verified " +
"FROM TP_Users f1 INNER JOIN TP_FriendRequests rec " +
"ON f1.UserId=rec.Friend1Id " +
"INNER JOIN TP_Users f2 " +
"ON rec.Friend2Id=f2.UserId " +
"WHERE f2.UserId=" + userId + " " +
"AND Accept=1";
ds = objDB.GetDataSet(sqlString);
if (ds.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
User user = new User();
DataRow record = ds.Tables[0].Rows[i];
user.UserId = int.Parse(record["UserId"].ToString());
user.FirstName = record["FirstName"].ToString();
user.LastName = record["LastName"].ToString();
user.Email = record["Email"].ToString();
user.Bio = record["Bio"].ToString();
user.City = record["City"].ToString();
user.State = record["State"].ToString();
user.Interests = record["Interests"].ToString();
user.Verified = record["Verified"].ToString();
timelineUsers.Add(user.UserId);
}
}
//return Array.ConvertAll(friends, x => x.ToString());
//Okay now friends and userId from the param is a list of all users
//Which i need to grab the posts from and return in a list of posts
//bada bing bada boom
//
List <Post> tempTimeline = new List <Post>();
foreach (int user in timelineUsers)
{
sqlString = "SELECT * FROM TP_Posts WHERE UserId=" + user;
ds = objDB.GetDataSet(sqlString);
//String tempString = "User: "******"PostId"];
//tempString += "Post text: " + record["Text"].ToString() + Environment.NewLine +
// "PostId: " + record["PostId"].ToString() + Environment.NewLine;
post.Timestamp = (DateTime)record["Timestamp"];
// ...
tempTimeline.Add(post);
}
//tempTimeline.Add(tempString);
}
}
tempTimeline.Sort((x, y) => DateTime.Compare(x.Timestamp, y.Timestamp));
int[] timeline = new int[tempTimeline.Count];
int r = 0;
foreach (Post post in tempTimeline)
{
timeline[r] = post.PostId;
r++;
}
return(timeline);
}
//Ajout Frequentation
public IActionResult AjoutFreq(string ste, string typeSte, string matr, string nomAG, string SA, int etab, string nomPat, int typePat, string dateNais, int age, char sexe, string adr, int numero, string natConsul, string codeMed, string act, string prest)
{
DBConnect c = new DBConnect();
OracleConnection conn = c.GetConnection();
conn.Open();
FonctionFreq f = new FonctionFreq();
int id = f.IDFreq();
OracleTransaction trans = conn.BeginTransaction();
string type = "INTERNE";
if (typeSte.Equals(type))
{
OracleCommand cmd = new OracleCommand
{
CommandText = "INSERT INTO FREQMALA_JDE(FREQMALA, NUMERO , MATR , ETAB , IDENTIFIANT , STE , TYPE_CLI , TYPAT , CODE_ACT , CODE_PREST , NAT_CONSULT , SA , NOM , DNAIS , ADRESSE, SEXE, AGE, DFREQ ) VALUES('" + id + "' , '" + numero + "' , '" + matr + "' ,'" + etab + "', '" + codeMed + "' , '" + ste + "' , '" + typeSte + "' , '" + typePat + "', '" + act + "' , '" + prest + "' , '" + natConsul + "' , '" + SA + "' , '" + nomPat + "',TO_DATE('" + dateNais + "', 'DD/MM/YYYY') , '" + adr + "' , '" + sexe + "', '" + age + "' , sysdate)",
Connection = conn,
CommandType = CommandType.Text
};
try
{
// Exécution de la requête
dr = cmd.ExecuteReader();
// On soumet la requête au serveur: tout s'est bien déroulé , la requête est exécutée
trans.Commit();
TempData["text"] = "Insertion reussie";
conn.Close();
}
catch (Exception ex)
{
// Une erreur est survenue: on ne valide pas la requête
trans.Rollback();
TempData["text"] = "Requete non effectuee \nErreur: " + ex.Message;
}
finally
{ // Libération des ressources
cmd.Dispose();
}
}
else
{
OracleCommand cmd = new OracleCommand
{
CommandText = "INSERT INTO FREQMALA_JDE(FREQMALA, NUMERO , IDENTIFIANT , STE , TYPE_CLI , CODE_ACT , CODE_PREST , NAT_CONSULT, NOM, DNAIS , ADRESSE, SEXE, AGE, DFREQ ) VALUES('" + id + "' , '" + numero + "' , '" + codeMed + "' , '" + ste + "' , '" + typeSte + "' , '" + act + "' , '" + prest + "' , '" + natConsul + "' , '" + nomPat + "', TO_CHAR(TO_DATE('" + dateNais + "', 'DD/MM/YYYY'), 'DD/MM/YYYY') , '" + adr + "', '" + sexe + "', '" + age + "', sysdate)",
Connection = conn,
CommandType = CommandType.Text
};
try
{
// Exécution de la requête
dr = cmd.ExecuteReader();
// On soumet la requête au serveur: tout s'est bien déroulé , la requête est exécutée
trans.Commit();
TempData["text"] = "Insertion reussie";
conn.Close();
}
catch (Exception ex)
{
// Une erreur est survenue: on ne valide pas la requête
trans.Rollback();
TempData["text"] = "Requete non effectue \nErreur: " + ex.Message;
}
finally
{ // Libération des ressources
cmd.Dispose();
}
}
return(RedirectToAction("Index", "Frequentation"));
}
protected void Page_Load(object sender, EventArgs e)
{
db = new DBConnect();
FillProjectList();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Session"] != null)
{
if (!IsPostBack)
{
iddoc.Value = Server.HtmlEncode(Request.QueryString["iddoc"]);
DBConnect conector = new DBConnect();
DataTable DTdocumento = conector.SDocumento(iddoc.Value);
DataTable DTcupos = conector.Scupos(iddoc.Value);
string vfactura = "";
string vhservicio = "";
string vhistoria = "";
string vpaciente = "";
string vmedico = "";
string vfecha = "";
string vcedula = "";
string vnombre = "";
string vnommedico = "";
string vnomservicio = "";
string vhturno = "";
for (int i = 0; i < DTdocumento.Rows.Count; i++)
{
vfactura = DTdocumento.Rows[i]["numero"].ToString();
vhservicio = DTdocumento.Rows[i]["hdestino"].ToString();
vfecha = DTdocumento.Rows[i]["fecha"].ToString();
vmedico = DTdocumento.Rows[i]["hmedico"].ToString();
vpaciente = DTdocumento.Rows[i]["horigen"].ToString();
}
for (int i = 0; i < DTcupos.Rows.Count; i++)
{
vhturno = DTcupos.Rows[i]["hturno"].ToString();
}
factura.Text = vfactura;
DataTable DTpaciente = conector.Spaciente(vpaciente);
for (int j = 0; j < DTpaciente.Rows.Count; j++)
{
vhistoria = DTpaciente.Rows[j]["historia"].ToString();
vcedula = DTpaciente.Rows[j]["cedula"].ToString();
vnombre = DTpaciente.Rows[j]["nombre"].ToString();
}
paciente.Text = vnombre;
historia.Text = vhistoria;
DataTable DTmedico = conector.Smedicos(vmedico);
for (int k = 0; k < DTmedico.Rows.Count; k++)
{
vnommedico = DTmedico.Rows[k]["nombre"].ToString();
}
medico.Text = vnommedico;
DataTable DTservicio = conector.Sservicio_IND(vhservicio);
for (int l = 0; l < DTservicio.Rows.Count; l++)
{
vnomservicio = DTservicio.Rows[l]["nombre"].ToString();
}
servicio.Text = vnomservicio;
string dia = vfecha.Substring(0, 2);
string mes = vfecha.Substring(3, 2);
string anio = vfecha.Substring(6, 4);
string vnfecha = anio + "-" + mes + "-" + dia;
fecha.Text = vnfecha;
numero.Text = conector.Snumerocupo(vhservicio, vmedico, vnfecha, vpaciente);
hora.Text = conector.SHORA(vhservicio, vmedico, vhturno);
}
}
else
{
string devuelveFecha = "<script language='JavaScript'>" +
"window.document.forms[0].target = '_parent'; window.document.forms[0].action = '../salida.aspx';" +
"window.document.forms[0].submit(); </script>";
ClientScript.RegisterStartupScript(this.GetType(), "CambiaTarget", devuelveFecha);
}
}
private void FrameStackerXml()
{
try
{
DBConnect db_st = new DBConnect();
string strAlert = string.Empty;
string strAlertTracking = string.Empty;
string Version = string.Empty;
//StackerLevelTracking - If it is true, then start the Stacker tracking
strAlertTracking = GetSettingDetail("StackerLevelTracking");
DataTable dtVer = DBConnect.GetVersion();
if (dtVer != null && dtVer.Rows.Count > 0)
{
Version = dtVer.Rows[0]["VersionName"].ToString();
}
if (strAlertTracking != null && strAlertTracking.Trim().ToUpper().Equals("TRUE"))
{
DataTable dt_stack = db_st.CheckStackerLevelStatus();
// Stacker Level Alert - If it is true, then STM alert will be sent
strAlert = GetSettingDetail("StackerLevelAlert");
if (strAlert != null && strAlert.Trim().ToUpper().Equals("TRUE"))
{
if (dt_stack != null && dt_stack.Rows.Count > 0)
{
foreach (DataRow dr in dt_stack.Rows)
{
XElement xml_stack =
new XElement("BMCRequest",
new XElement("Source", "STACK"),
new XElement("BMCVersion", Version),
new XElement("ExceptionCode", StackerExceptionCode),
new XElement("OperatorId", "000"),
new XElement("SubCode", ""),
new XElement("Company", dr["CompanyName"] ?? string.Empty),
new XElement("Region", dr["RegionName"] ?? string.Empty),
new XElement("Area", dr["AreaName"] ?? string.Empty),
new XElement("SiteId", dr["SiteId"].ToString()),
new XElement("SiteName", dr["SiteName"] ?? string.Empty),
new XElement("Asset", dr["Asset"] ?? string.Empty),
new XElement("Stand", dr["Stand"] ?? string.Empty),
new XElement("StackerLevel", dr["StackerLevel"].ToString()),
new XElement("StackerExceedLimit", dr["StackerExceedLimit"].ToString()),
new XElement("MessageDateTime", string.Format("{0:G}", Convert.ToDateTime(dr["MessageDateTime"]))));
if (db_st.ExportToSTM("STACK", dr["SiteId"].ToString(), xml_stack.ToString()))
{
LogManager.WriteLog("ExportToSTM Succeed Type: STACK", LogManager.enumLogLevel.Info);
if (db_st.UpdateStackerAlertStatus(Convert.ToInt32(dr["Installation_No"]), true))
{
LogManager.WriteLog("Stacker Alert Status Updated Successfully", LogManager.enumLogLevel.Info);
}
}
}
}
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
LogManager.WriteLog("FrameStackerXml Exception Message : " + ex.Message, LogManager.enumLogLevel.Error);
}
}
object com_GetMessRuleData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.MessRule)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
System.Collections.Hashtable laneCount = new System.Collections.Hashtable();
laneCount.Add(0, Convert.ToString(dr[3]));
laneCount.Add(1, Convert.ToString(dr[4]));
laneCount.Add(2, Convert.ToString(dr[5]));
laneCount.Add(3, Convert.ToString(dr[6]));
laneCount.Add(4, Convert.ToString(dr[7]));
laneCount.Add(5, Convert.ToString(dr[8]));
laneCount.Add(6, Convert.ToString(dr[9]));
laneCount.Add(7, Convert.ToString(dr[10]));
laneCount.Add(8, Convert.ToString(dr[11]));
laneCount.Add(9, Convert.ToString(dr[12]));
laneCount.Add(10, Convert.ToString(dr[13]));
laneCount.Add(11, Convert.ToString(dr[14]));
laneCount.Add(12, Convert.ToString(dr[15]));
laneCount.Add(13, Convert.ToString(dr[16]));
laneCount.Add(14, Convert.ToString(dr[17]));
return laneCount;
}
else if (type == DBConnect.DataType.EndSectionName)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return dr[0].ToString();
}
else if (type == DBConnect.DataType.Priority)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
return Convert.ToInt32(dr[2]);
}
else
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
if (GetMessRuleData != null)
{
return GetMessRuleData(type, dr);
}
else
return null;
}
}
private void updateBtn_Click(object sender, EventArgs e)
{
string type = "";
string save = "";
string deliver = deliveryChk.Checked ? "Yes" : "No";
string followup = followupChk.Checked ? "Yes" : "No";
string pickup = pickupChk.Checked ? "Yes" : "No";
if (deliveryChk.Checked)
{
type = "Delivery";
}
if (followupChk.Checked)
{
type = "Follow up";
}
if (pickupChk.Checked)
{
type = "Pickup";
}
if (string.IsNullOrEmpty(type))
{
MessageBox.Show("Delivery /follow up / pick up ? ");
return;
}
double tax = GenericCollection.caseTransactions.Sum(x => x.Tax);
double amount = GenericCollection.caseTransactions.Sum(x => x.Payable);
string method = "Invoice";
int ItemCount = GenericCollection.caseTransactions.Count();
if (MessageBox.Show("YES or NO?", "Would you like to generate a new invoice based on this information? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string Query = "DELETE from invoice WHERE no ='" + noTxt.Text + "'";
MySQL.Query(Query);
string ids = Guid.NewGuid().ToString();
Invoice iw = new Invoice(ids, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, "Credit", "Sale", Helper.CompanyName, CustomerID, method, amount, noTxt.Text, tax, amount, amount, amount, ItemCount, userCbx.Text, DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
save = MySQL.Insert(iw);
}
Dictionary <string, string> transDic = new Dictionary <string, string>();
Delivery i = new Delivery(ID, noTxt.Text, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), deliver, followup, pickup, type, PractitionerID, CustomerID, commentTxt.Text, userCbx.Text, Convert.ToDateTime(dateDeliveredTxt.Text).ToString("dd-MM-yyyy"), recievedByTxt.Text, signatureTxt.Text, reasonTxt.Text, recievedByTxt.Text, Convert.ToDouble(totalTxt.Text), DateTime.Now.ToString("dd-MM-yyyy H:m:s"), "false", Helper.CompanyID);
DBConnect.UpdateMySql(i, ID);
if (MessageBox.Show("YES or NO?", "Would you like to add these products to your invoice ? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string Query = "DELETE from transaction WHERE no ='" + noTxt.Text + "'";
MySQL.Query(Query);
foreach (CaseTransaction t in GenericCollection.caseTransactions)
{
string it = Guid.NewGuid().ToString();
if (!transDic.ContainsKey(it))
{
transDic.Add(it, t.Date);
CaseTransaction c = new CaseTransaction(it, Convert.ToDateTime(dateTxt.Text).ToString("dd-MM-yyyy"), noTxt.Text, t.ItemID, noTxt.Text, ID, t.Qty, t.Cost, t.Units, t.Total, t.Tax, t.Coverage, t.Self, t.Payable, t.Limits, t.Setting, t.Period, t.Height, t.Weight, t.Instruction, t.Created, "false", Helper.CompanyID);
MySQL.Insert(c);
}
}
}
MessageBox.Show("Information Saved");
this.Close();
}
static void Main(string[] args)
{
//get current runtime
DateTime currentRunTime = DateTime.Now;
// get the session directory servers we will talk to
NameValueCollection appSettings = ConfigurationManager.AppSettings;
//this is the string defined in app.config
//the string can have multiple entries, seperate each entry by a semi-colon (;)
//each entry must be in the form of: "servername/clustername"
string connectionBrokers = appSettings.Get("connectionBrokers");
//what is our error log
string errLog = appSettings.Get("errorLog");
//split the connectionBrokers app.config string by semi-colons
string[] sessionDirs = connectionBrokers.Split(';');
// get our DB object
DBConnect db = new DBConnect();
//update the database with the current runtime date
//we MUST do this first so that all the updates and statistics calls will have latest data and satisfy FK constraints in the DB
//insertCurrentRuntime marks the "complete" column to false. this is so we can insert a new runtime, but the web application will
//not see the new runtime until we mark the complete column to true, which is done after the new stats are gathered/generated etc..
db.InsertCurrentRuntime(currentRunTime);
//connect to the session directories, and collect/insert the session info into the DB
CBConnect cb = new CBConnect();
cb.LastUpdate = currentRunTime;
foreach (string entry in sessionDirs)
{
string[] currentSD = entry.Split('/');
if (currentSD.Length == 2)
{
//set the properties for the current Session Directory/Broker to process
cb.ServerName = currentSD[0];
cb.ClusterName = currentSD[1];
Console.WriteLine("\nGathering session info for Cluster: {0} on Connection Broker: {1}", cb.ClusterName, cb.ServerName);
//Get the stats and write them to our DB
cb.GetStats();
}
else
{
string sdErr = "Error Parsing session directory string: " + entry + ", please verify that it is correct!\n";
Console.WriteLine("!!ERROR!!");
Console.WriteLine(" {0}\n", sdErr);
Exception sessionDirException = new Exception(sdErr);
CatchError(sessionDirException);
}
}
//try and updat the stats
//note that each method checks to make sure there were no errors before updating the stats.
Console.WriteLine("\n\nNow Generating Latest Stats for newly collected info...");
//update the server Stats
db.UpdateServerStats();
//update the domain stats
db.UpdateDomainStats();
//update the cluster/per farm stats
db.UpdateClusterStats();
//update the curSessions Table
db.UpdateCurSessions(currentRunTime);
//get current time
DateTime endTime = DateTime.Now;
TimeSpan runtime = endTime.Subtract(currentRunTime);
//mark this last runtime as complete
//this needs to be done before we clean out the old stuff from curSessions table
//so the website/views have data to grab (current runtime is marked as complete
db.CompleteUpdate(currentRunTime, runtime.Seconds);
//clean out any old crap from the curSessions table
db.CleanCurSessions(currentRunTime);
Console.WriteLine("Done\n");
//check for errors
if (Rdscbmon.err)
{
//there were errors - so record them
Console.WriteLine("\n{0} error(s) were encountered: ", exceptions.Count.ToString());
Console.WriteLine("Please check the log file {0} for more information", errLog);
//open our error log
System.IO.StreamWriter errFile = new System.IO.StreamWriter(errLog);
//write all the exceptions to the error log
foreach (Exception e in exceptions)
{
errFile.WriteLine("{0}\n\n\n", e);
}
//close the error log
errFile.Close();
}
//exit the program with our exit code
Environment.Exit(code);
}
object CSLS_GetMessRuleData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.CSLS)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
decrease = Convert.ToInt32(dr[0]);
range = Convert.ToInt32(dr[1]);
switch (degree)
{
case Degree.L:
minSpeed = Convert.ToInt32(dr[3]);
maxSpeed = Convert.ToInt32(dr[2]);
break;
case Degree.M:
minSpeed = Convert.ToInt32(dr[5]);
maxSpeed = Convert.ToInt32(dr[4]);
break;
case Degree.H:
minSpeed = Convert.ToInt32(dr[7]);
maxSpeed = Convert.ToInt32(dr[6]);
break;
case Degree.S:
minSpeed = Convert.ToInt32(dr[9]);
maxSpeed = Convert.ToInt32(dr[8]);
break;
default:
minSpeed = maxSpeed;
break;
}
return null;
}
else
{
return null;
}
}
protected void SecurityButton_Click(object sender, EventArgs e)
{
ValidateUserQuestions();
//Validate Security Question Answer
if (UserRegistrationSecurityAnswers.Count == 0)
{
DBConnect dbConnection = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TPInsertSecurityQuestion";
SqlParameter inputParameter = new SqlParameter("@Email", Session["userEmail"].ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.NVarChar;
objCommand.Parameters.Add(inputParameter);
//Question 1
inputParameter = new SqlParameter("@Q1", PrivacyQ1TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
//Answer 1
inputParameter = new SqlParameter("@A1", PrivacyA1TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
//Question 2
inputParameter = new SqlParameter("@Q2", PrivacyQ2TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
//Answer 2
inputParameter = new SqlParameter("@A2", PrivacyA2TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
//Question 3
inputParameter = new SqlParameter("@Q3", PrivacyQ3TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
//Answer 3
inputParameter = new SqlParameter("@A3", PrivacyA3TxtBox.Text.ToString());
inputParameter.Direction = ParameterDirection.Input;
inputParameter.SqlDbType = SqlDbType.VarChar;
objCommand.Parameters.Add(inputParameter);
int ResponseRecevied = dbConnection.DoUpdateUsingCmdObj(objCommand);
if (ResponseRecevied == 1)
{
//Security Questions Inserted
PrivacyQuestionsDiv.Visible = false;
PreferencesDiv.Visible = true;
}
}
else
{
for (int i = 0; i < UserRegistrationSecurityAnswers.Count; i++)
{
Response.Write(UserRegistrationSecurityAnswers[i] + "<br/>");
}
}
}
public static Graph Populate(String publicAddress, int degree, int tooBigToAddToNetwork)
{
var database = new DBConnect();
database.OpenConnection();
database.SetMaxAddressQuerryTime(500);
var graph = new Graph();
var count = 0;
var currentDegree = new Queue <String>();
var nextDegree = new Queue <String>();
graph.addNode(publicAddress, 0);
currentDegree.Enqueue(publicAddress);
while (count < degree)
{
var currentAddress = currentDegree.Dequeue();
Console.WriteLine("Network has {0} nodes", graph._nodeList.Count);
Console.Write("{0} Deg: {1} Qrying ", currentAddress, count);
if (currentAddress.Substring(0, 5) != "1dice")
{
var sendersList = database.getSentTo(currentAddress);
var reciverList = database.getRecivedFrom(currentAddress);
if (sendersList != null && reciverList != null)
{
Console.WriteLine(" Proc {0} trans", (sendersList.Count + reciverList.Count));
if (sendersList.Count < tooBigToAddToNetwork)
{
foreach (var sender in sendersList)
{
if (!graph._index.ContainsKey(sender.Target))
{
nextDegree.Enqueue(sender.Target);
graph.addNode(sender.Target, count + 1);
//graph.addDirectedEdge(sender.source, sender.target, Convert.ToDecimal(sender.value), sender.weight, count+1);
}
//else
{
graph.addDirectedEdge(sender.Source, sender.Target, Convert.ToDecimal(sender.Value), sender.Weight, count + 1);
}
}
foreach (var reciver in reciverList)
{
if (!graph._index.ContainsKey(reciver.Source))
{
nextDegree.Enqueue(reciver.Source);
graph.addNode(reciver.Source, count + 1);
//graph.addDirectedEdge(reciver.source, reciver.target, Convert.ToDecimal(reciver.value), reciver.weight, count+1);
}
//else
{
graph.addDirectedEdge(reciver.Source, reciver.Target, Convert.ToDecimal(reciver.Value), reciver.Weight, count + 1);
}
}
}
}
}
Console.WriteLine(currentDegree.Count + " queries to go");
if (currentDegree.Count > 0)
{
continue;
}
count++;
currentDegree = nextDegree;
nextDegree = new Queue <String>();
}
database.CloseConnection();
return(graph);
}
protected void SubmitPreferencesButton_Click(object sender, EventArgs e)
{
//No Need for Validation
DBConnect dbConnection = new DBConnect();
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "TPInsertUserPreference";
objCommand.Parameters.AddWithValue("@Email", Session["userEmail"].ToString());
objCommand.Parameters.AddWithValue("@Login", LoginPreferenceDropDown.SelectedValue);
objCommand.Parameters.AddWithValue("@Theme", ThemePreferenceDropDown.SelectedValue);
objCommand.Parameters.AddWithValue("@ProfileInfoPrivacy", PrivacyPreferenceDropDown.SelectedValue);
objCommand.Parameters.AddWithValue("@PhotoPrivacy", PhotoPrivacyDropDown.SelectedValue);
objCommand.Parameters.AddWithValue("@FeedPrivacy", FeedPrivacyDropDown.SelectedValue);
int ResponseRecevied = dbConnection.DoUpdateUsingCmdObj(objCommand);
Settings userSettings = new Settings();
userSettings.LoginPreference = LoginPreferenceDropDown.SelectedValue;
userSettings.Theme = ThemePreferenceDropDown.SelectedValue;
userSettings.ProfileInfoPrivacy = PrivacyPreferenceDropDown.SelectedValue;
userSettings.PhotoPrivacy = PhotoPrivacyDropDown.SelectedValue;
userSettings.FeedPrivacy = FeedPrivacyDropDown.SelectedValue;
Session.Add("userSettings", userSettings);
String plainTextEmail = RegisterEmailTxtBox.Text;
String plainTextPassword = RegisterPasswordTxtBox.Text;
String encryptedEmail;
String encryptedPassword;
System.Text.UTF8Encoding encoder = new UTF8Encoding();
Byte[] emailBytes;
Byte[] passwordBytes;
emailBytes = encoder.GetBytes(plainTextEmail);
passwordBytes = encoder.GetBytes(plainTextPassword);
RijndaelManaged rmEncryption = new RijndaelManaged();
MemoryStream memStream = new MemoryStream();
CryptoStream encryptionStream = new CryptoStream(memStream, rmEncryption.CreateEncryptor(key, vector), CryptoStreamMode.Write);
if (userSettings.LoginPreference == "Auto-Login")
{
//Email
encryptionStream.Write(emailBytes, 0, emailBytes.Length);
encryptionStream.FlushFinalBlock();
memStream.Position = 0;
Byte[] encryptedEmailBytes = new byte[memStream.Length];
memStream.Read(encryptedEmailBytes, 0, encryptedEmailBytes.Length);
encryptionStream.Close();
memStream.Close();
//password
memStream = new MemoryStream();
encryptionStream = new CryptoStream(memStream, rmEncryption.CreateEncryptor(key, vector), CryptoStreamMode.Write);
encryptionStream.Write(passwordBytes, 0, passwordBytes.Length);
encryptionStream.FlushFinalBlock();
memStream.Position = 0;
Byte[] encryptedPasswordBytes = new byte[memStream.Length];
memStream.Read(encryptedPasswordBytes, 0, encryptedPasswordBytes.Length);
encryptionStream.Close();
memStream.Close();
encryptedEmail = Convert.ToBase64String(encryptedEmailBytes);
encryptedPassword = Convert.ToBase64String(encryptedPasswordBytes);
HttpCookie myCookie = new HttpCookie("LoginCookie");
myCookie.Values["Email"] = encryptedEmail;
myCookie.Expires = new DateTime(2020, 2, 1);
myCookie.Values["Password"] = encryptedPassword;
myCookie.Expires = new DateTime(2020, 2, 1);
Response.Cookies.Add(myCookie);
}
else if (userSettings.LoginPreference == "Fast-Login")
{
encryptionStream.Write(emailBytes, 0, emailBytes.Length);
encryptionStream.FlushFinalBlock();
memStream.Position = 0;
Byte[] encryptedEmailBytes = new byte[memStream.Length];
memStream.Read(encryptedEmailBytes, 0, encryptedEmailBytes.Length);
encryptionStream.Close();
memStream.Close();
encryptedEmail = Convert.ToBase64String(encryptedEmailBytes);
HttpCookie myCookie = new HttpCookie("LoginCookie");
myCookie.Values["Email"] = encryptedEmail;
myCookie.Expires = new DateTime(2020, 2, 1);
Response.Cookies.Add(myCookie);
}
Response.Redirect("Feed.aspx");
//the code below happens in the session end event in the global.asax file
//BinaryFormatter serializer = new BinaryFormatter();
//MemoryStream memStream = new MemoryStream();
//serializer.Serialize(memStream, userSettings);
//Byte[] byteSettings = memStream.ToArray();
//objCommand.CommandType = CommandType.StoredProcedure;
//objCommand.CommandText = "TPUpdateUserSettings";
//objCommand.Parameters.AddWithValue("@theUserEmail", Session["userEmail"].ToString());
//objCommand.Parameters.AddWithValue("@theSettings", byteSettings);
//int retVal = dbConnection.DoUpdateUsingCmdObj(objCommand);
//if (ResponseRecevied == 1) {
// //Preferences Updated
//}
//if(retVal == 1)
//{
// Response.Write("Settings updated successfully.");
//}
//else
//{
// Response.Write("There was a problem updating your user settngs.");
//}
}
public User getUser(string email, string password)
{
SqlCommand objCommand = new SqlCommand();
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.CommandText = "OceanLogin";
objCommand.Parameters.AddWithValue("@email", email);
objCommand.Parameters.AddWithValue("@password", password);
DBConnect objDB = new DBConnect();
DataSet myData = objDB.GetDataSetUsingCmdObj(objCommand);
User tempUser = new User();
if (myData.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < myData.Tables[0].Rows.Count; i++)
{
DataRow row = myData.Tables[0].Rows[i];
tempUser.UserID = Int32.Parse(row["UserID"].ToString());
tempUser.FirstName = row["firstName"].ToString();
tempUser.LastName = row["lastName"].ToString();
tempUser.Email = row["email"].ToString();
string wishlist = row["wishlist"].ToString();
//deserialize wishlist and cart and add it to user
if (wishlist != "")
{
byte[] byteArrayWishlist = (byte[])row["wishlist"];
BinaryFormatter desearilizerWishlist = new BinaryFormatter();
MemoryStream memStreamWishlist = new MemoryStream(byteArrayWishlist);
ArrayList wishListArray = new ArrayList();
wishListArray = (ArrayList)desearilizerWishlist.Deserialize(memStreamWishlist);
tempUser.Wishlist = wishListArray;
}
else
{
tempUser.Wishlist = null;
}
string cart = row["cart"].ToString();
if (cart != "")
{
byte[] byteArrayCart = (byte[])row["cart"];
BinaryFormatter desearilizerCart = new BinaryFormatter();
MemoryStream memStreamCart = new MemoryStream(byteArrayCart);
ArrayList cartArray = new ArrayList();
cartArray = (ArrayList)desearilizerCart.Deserialize(memStreamCart);
tempUser.Cart = cartArray;
}
else
{
tempUser.Cart = null;
}
}
}
else
{
tempUser = null;
}
return(tempUser);
}
public FormBank()
{
InitializeComponent();
dbConnect = new DBConnect();
}
object LCS_GetMessRuleData(DBConnect.DataType type, object reader)
{
if (type == DBConnect.DataType.Tunnel)
{
System.Data.Odbc.OdbcDataReader dr = (System.Data.Odbc.OdbcDataReader)reader;
if (dr[7].ToString() == "1")
isEventFlash = true;
else
isEventFlash = false;
if (dr[8].ToString() == "1")
isReturnFlash = true;
else
isReturnFlash = false;
n_device = Convert.ToInt32(dr[6]);
return null;
}
else
return null;
}
//Bejelentkezés void
public void LoggingIn()
{
//Bevitt adatok ellenőrzése és a fomr hozzá igazítása (Színek, szövegek)
if (textBoxUserName.Text.ToString() == "" && textBoxPasswd.Text.ToString() == "")
{
labelMessage.Text = "Kérlek add meg a belépési adatokat.";
labelMessage.ForeColor = Color.Red;
}
if (textBoxUserName.Text.ToString() == "")
{
labelMessage.Text = "A felhasználónév mező üres. Kérlek ellenőrizd.";
labelMessage.ForeColor = Color.Red;
textBoxUserName.BackColor = Color.LightCoral;
textBoxPasswd.BackColor = Color.White;
}
if (textBoxPasswd.Text.ToString() == "")
{
labelMessage.Text = "A jelszó mező üres. Kérlek ellenőrizd.";
labelMessage.ForeColor = Color.Red;
textBoxPasswd.BackColor = Color.LightCoral;
if (textBoxUserName.Text != "")
{
textBoxUserName.BackColor = Color.White; //Ha már közben beírta a nevét, akkor ne maradjon piros az username mező.
}
}
if (textBoxUserName.Text.ToString() != "" && textBoxPasswd.Text.ToString() != "")
{
//Név mentése a Propertiesbe
Properties.Settings.Default.Username = textBoxUserName.Text;
Properties.Settings.Default.Save();
//Loading gif betöltése a formra.
if (File.Exists("image/loading.gif"))
{
pictureBox1.Image = Image.FromFile("image/loading.gif");
}
else
{
pictureBox1.Image = null;
}
pictureBox1.SizeMode = PictureBoxSizeMode.StretchImage;
//Bejelentkezési adatok ellenőrzése.
try
{
DBConnect conn = new DBConnect(); //Adatbázis csatlakozás
string mquerylogin = "******"" + (textBoxUserName.Text.ToLower()) + "\"";
MySqlCommand cmdlogin = new MySqlCommand(mquerylogin, conn.returnConnection());
conn.OpenConnection();
//Visszakapott adatok kinyerése
string name = "";
string passwd = "";
MySqlDataReader reader = cmdlogin.ExecuteReader();
while (reader.Read())
{
name = reader.GetString("name");
passwd = reader.GetString("passwd");
fullname = reader.GetString("fullname");
}
conn.CloseConnection();
//Megegyeznek-e az adatok a lekértekkel
if ((name != "" && name.ToLower() == textBoxUserName.Text.ToLower()) && (passwd != "" && passwd == textBoxPasswd.Text.ToString()))
{
loginname = name;
labelMessage.Text = "Sikeres belépés!";
labelMessage.ForeColor = Color.Green;
textBoxUserName.BackColor = Color.LightGreen;
textBoxPasswd.BackColor = Color.LightGreen;
//Ha már egyszer be volt zárva a HomeForm, akkor hozza létre újra.
if (homeForm.IsDisposed == true)
{
homeForm = new HomeForm();
}
homeForm.Show();
buttonLogin.Enabled = false;
buttonLogout.Enabled = true;
textBoxUserName.Enabled = false;
textBoxPasswd.Enabled = false;
pictureBox1.Image = null;
}
else
{
labelMessage.Text = "Sikertelen bejelentkezés. Kérjük ellenőrizze az adatokat.";
labelMessage.ForeColor = Color.Red;
pictureBox1.Image = null;
textBoxUserName.BackColor = Color.LightCoral;
textBoxPasswd.BackColor = Color.LightCoral;
}
}
catch (MySqlException ex)
{
MessageBox.Show("Kérjük mutassa meg ezt a fejlesztőnek:\n" + ex.Message, "Adatbázis hiba");
}
catch (Exception ex)
{
//conn.CloseConnection();
labelMessage.Text = "Hiba lépett fel";
labelMessage.ForeColor = Color.Red;
MessageBox.Show("Kérjük mutassa meg ezt a fejlesztőnek:\n" + ex.Message, "Hiba");
pictureBox1.Image = null;
}
}
}
public DBStore(DBConnect db)
{
conn = db;
}
protected abstract DBContext Initialize(DBConnect dbConnect);
protected void Page_Load(object sender, EventArgs e)
{
int mmm = 0;
string menu = Server.HtmlEncode(Request.QueryString["menu"]);
if (menu == "1")
{
mmm++;
}
else
{
Response.Redirect("../Default.aspx");
}
DBConnect conexion = new DBConnect();
DataTable DTv6 = conexion.Sv6();
int rec = DTv6.Rows.Count;
decimal d = rec / 25;
int t = Convert.ToInt16(decimal.Round(d, 1));
int n = 0;
Response.ContentType = "application/pdf";
//System.Web.HttpContext.Current.Server.MapPath
sharpPDF.pdfDocument myDoc = new sharpPDF.pdfDocument("Sample Application", "Me", false);
myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/encabezado.gif"), "encabezado");
myDoc.addImageReference(System.Web.HttpContext.Current.Server.MapPath("../Imagenes/piedepagina.gif"), "pie");
/*Table's creation*/
int k = 25;
int i = 0;
for (n = 0; n <= t; n++)
{
sharpPDF.pdfPage myFirstPage = myDoc.addPage(748, 1024);
//sharpPDF.pdfPage myFirstPage = myDoc.addPage(210, 297);
sharpPDF.Tables.pdfTable myTable = new sharpPDF.Tables.pdfTable(myDoc);
myTable.borderSize = 1;
myTable.borderColor = new sharpPDF.pdfColor(0, 0, 0);
myTable.coordX = 20;
myTable.coordY = 600;
myTable.tableHeader.addColumn(150);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(40);
myTable.tableHeader.addColumn(60);
myFirstPage.addImage(myDoc.getImageReference("encabezado"), 20, 690);
myFirstPage.addText("FALLAS DE HARDWARE REPORTADAS Y SOLVENTADAS POR CADA DEPARTAMENTO", 80, 650, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 20);
sharpPDF.Tables.pdfTableRow myRow = myTable.createRow();
myRow[0].addText("DEPARTAMENTO", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[1].addText("CPU", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[2].addText("CPUP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[3].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[4].addText("IMP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[5].addText("IMPP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[6].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[7].addText("MON", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[8].addText("MONP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[9].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[10].addText("TEC", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[11].addText("TECP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[12].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[13].addText("MOU", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[14].addText("MOUP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[15].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[16].addText("REG", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[17].addText("REGP", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myRow[18].addText("%", myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelveticaBold), 10, sharpPDF.pdfColor.DarkBlue);
myTable.addRow(myRow);
myRow = null;
while (i < k)
{
if (i < rec)
{
sharpPDF.Tables.pdfTableRow myRow2 = myTable.createRow();
myRow2[0].addText(DTv6.Rows[i]["departamento"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[1].addText(DTv6.Rows[i]["cpurep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[2].addText(DTv6.Rows[i]["cpures"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[3].addText(DTv6.Rows[i]["cpup"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[4].addText(DTv6.Rows[i]["impresorarep"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[5].addText(DTv6.Rows[i]["impresorares"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[6].addText(DTv6.Rows[i]["impresorap"].ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[7].addText(DTv6.Rows[i]["monitorrep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[8].addText(DTv6.Rows[i]["monitorres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[9].addText(DTv6.Rows[i]["cmonitor"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[10].addText(DTv6.Rows[i]["tecladorep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[11].addText(DTv6.Rows[i]["tecladores"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[12].addText(DTv6.Rows[i]["tecladop"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[13].addText(DTv6.Rows[i]["mouserep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[14].addText(DTv6.Rows[i]["mouseres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[15].addText(DTv6.Rows[i]["mousep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[16].addText(DTv6.Rows[i]["reguladorrep"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[17].addText(DTv6.Rows[i]["reguladorres"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myRow2[18].addText(DTv6.Rows[i]["reguladorp"].ToString().ToString(), myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csCourier), 9, sharpPDF.pdfColor.Blue);
myTable.addRow(myRow2);
myRow2 = null;
i++;
}
else
{
i++;
}
}
myFirstPage.addTable(myTable, 600);
myFirstPage.drawRectangle(20, 45, 990, 10, new sharpPDF.pdfColor(0, 0, 0), new sharpPDF.pdfColor(255, 255, 255));
myFirstPage.addText("CPU = CPU Reportados", 30, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("CPUP = Fallas de CPU resueltas", 30, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("IMP = Impresoras reportadas", 230, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("IMPP = Fallas de Impresoras resueltas", 230, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("MON = Monitores Reportados", 430, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("MONP = Fallas de Monitores Resueltas", 430, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("TEC = Teclados Reportados", 630, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("TECP = Fallas de Teclados Resueltas", 630, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("MOU = Mouse Reportados", 780, 35, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("MOUP = Fallas de Mouse Resueltas", 780, 25, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("REG = Reguladores Reportados", 30, 15, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myFirstPage.addText("REP = Fallas de Mouse Resueltas", 230, 15, myDoc.getFontReference(sharpPDF.Enumerators.predefinedFont.csHelvetica), 8, new sharpPDF.pdfColor(0, 51, 153));
myTable = null;
myFirstPage = null;
k = k + 25;
}
myDoc.createPDF(Response.OutputStream);
myDoc = null;
}
public List <PostOBJ> GetNewsFeed(String requestingEmail, String requestedEmail, String token)
{
DBConnect objDB = new DBConnect();
List <PostOBJ> myNewsFeed = new List <PostOBJ>();
SqlCommand LoginUser = new SqlCommand();
LoginUser.CommandType = CommandType.StoredProcedure;
LoginUser.CommandText = "TP_FindUser";
LoginUser.Parameters.AddWithValue("@Email", requestingEmail);
LoginUser.Parameters.AddWithValue("@Password", decode(token));
SqlParameter outputPar = new SqlParameter("@Out", SqlDbType.Int, 50);
outputPar.Direction = ParameterDirection.Output;
LoginUser.Parameters.Add(outputPar);
objDB.GetDataSetUsingCmdObj(LoginUser);
//check token to see if user is logged in with same Email and pass
string a = LoginUser.Parameters["@Out"].Value.ToString();
if (a.Equals("1"))
{
SqlCommand GetFriends = new SqlCommand();
GetFriends.CommandType = CommandType.StoredProcedure;
GetFriends.CommandText = "TP_GetFriends";
GetFriends.Parameters.AddWithValue("@Email", requestedEmail);
DataSet Friends = objDB.GetDataSetUsingCmdObj(GetFriends);
SqlCommand GetPosts = new SqlCommand();
GetPosts.CommandType = CommandType.StoredProcedure;
GetPosts.CommandText = "TP_GetPosts";
SqlCommand CheckFollow = new SqlCommand();
CheckFollow.CommandType = CommandType.StoredProcedure;
CheckFollow.CommandText = "TP_CheckFollow";
//get my Posts and add them to news feed collection
GetPosts.Parameters.AddWithValue("@Email", requestingEmail);
DataSet myPosts = objDB.GetDataSetUsingCmdObj(GetPosts);
foreach (DataRow thisUsersPosts in myPosts.Tables[0].Rows)
{
PostOBJ thisPost = new PostOBJ();
thisPost.EmailOwner = thisUsersPosts["EmailOwner"].ToString();
thisPost.EmailWriter = thisUsersPosts["EmailWriter"].ToString();
thisPost.Content = thisUsersPosts["Content"].ToString();
thisPost.Date = DateTime.Parse(thisUsersPosts["Date"].ToString());
myNewsFeed.Add(thisPost);
}
foreach (DataRow record in Friends.Tables[0].Rows)
{
GetPosts.Parameters.Clear();
GetPosts.Parameters.AddWithValue("@Email", record["Person2"].ToString());
DataSet Posts = objDB.GetDataSetUsingCmdObj(GetPosts);
foreach (DataRow thisUsersPosts in Posts.Tables[0].Rows)
{
CheckFollow.Parameters.Clear();
CheckFollow.Parameters.AddWithValue("@Email1", record["Person1"].ToString());
CheckFollow.Parameters.AddWithValue("@Email2", record["Person2"].ToString());
SqlParameter outputPar1 = new SqlParameter("@found", SqlDbType.Int, 50);
outputPar1.Direction = ParameterDirection.Output;
CheckFollow.Parameters.Add(outputPar1);
objDB.GetDataSetUsingCmdObj(CheckFollow);
if (CheckFollow.Parameters["@found"].Value.ToString() == "1")
{
PostOBJ thisPost = new PostOBJ();
thisPost.EmailOwner = thisUsersPosts["EmailOwner"].ToString();
thisPost.EmailWriter = thisUsersPosts["EmailWriter"].ToString();
thisPost.Content = thisUsersPosts["Content"].ToString();
thisPost.Date = DateTime.Parse(thisUsersPosts["Date"].ToString());
myNewsFeed.Add(thisPost);
}
}
}
List <PostOBJ> SortedList = myNewsFeed.OrderByDescending(o => o.Date).ToList();
return(SortedList);
}
else
{
return(myNewsFeed);
}
}
