private void CreateInstance() { if (ConnObj == null) { ConnObj = new ConnectionClass(); } }
protected void DisplayMenu() { ConnectionClass ConnObj = new ConnectionClass(); SqlCommand cmd1 = new SqlCommand("sp_select_admin_userpanelpermission"); cmd1.Parameters.AddWithValue("@user_id", SessionState._BrandyyAdmin.admin_id); ConnObj.GetDataTab(cmd1); foreach (DataRow row in ConnObj.DataTab.Rows) { switch (Convert.ToString(row["panle_srtName"])) { //case "a1": // a1.Visible = true; // acc.Visible = true; // break; //case "a2": // a2.Visible = true; // acc.Visible = true; // break; //case "m1": // m1.Visible = true; // mark.Visible = true; // break; //case "m2": // m2.Visible = true; // mark.Visible = true; // break; //case "m3": // m3.Visible = true; // mark.Visible = true; // break; case "s1": s1.Visible = true; stng1.Visible = true; break; case "s2": s2.Visible = true; stng1.Visible = true; break; //case "s3": // s3.Visible = true; // stng.Visible = true; // break; //case "s4": // s4.Visible = true; // stng.Visible = true; // break; //case "c1": // c1.Visible = true; // break; //case "v1": // v1.Visible = true; // break; default: break; } } }
public static void Random_Set(string number, string pass) { try { string cmd = string.Format("EXEC dbo.Random2015_Set N'{0}', N'{1}'", number, pass); ConnectionClass obj = new ConnectionClass(); obj.fillDataset(cmd); } catch { } }
protected void DisplayMenu() { ConnectionClass ConnObj = new ConnectionClass(); SqlCommand cmd1 = new SqlCommand("sp_select_brand_userpanelpermission"); cmd1.Parameters.AddWithValue("@user_id", SessionState._BrandAdmin.user_id); ConnObj.GetDataTab(cmd1); //CheckIfActivitiesWaitingVerification(); PrintChildItems(ConnObj.DataTab); ConnObj.ReleaseConnection(); }
public ConnectionString this[ConnectionClass clazz, ConnectionType type] { get { if (!_dico.ContainsKey(new ConnectionDefinition(clazz, type))) _dico[new ConnectionDefinition(clazz, type)] = new ConnectionString(); return this[new ConnectionDefinition(clazz, type)]; } set { _dico[new ConnectionDefinition(clazz, type)] = value; } }
public static CellsetClass GetCellSet(string ASConnStr,string MDX) { ConnectionClass conn=null; try { conn = new ConnectionClass(); CellsetClass cst = new CellsetClass(); cst.ActiveConnection=conn; conn.Open(ASConnStr,"","",(int)ConnectModeEnum.adModeUnknown); cst.Open(MDX,conn); return cst; } catch{return null;} }
protected void btnShip_Click(object sender, EventArgs e) { //Get variables from Url string client = Request.QueryString["client"]; DateTime date = Convert.ToDateTime(Request.QueryString["date"]); //Get user info + user's placed orders User user = ConnectionClass.GetUserDetails(client); ArrayList orderList = ConnectionClass.GetDetailedOrders(client, date); //Update database and send confirmation e-mail. Afterwards send user back to 'Orders' Page ConnectionClass.UpdateOrders(client, date); SendEmail(user.Name, user.Email, orderList); Response.Redirect("~/Pages/Orders.aspx"); }
void Select_max_project_id() { SqlConnection conn = ConnectionClass.GetConnection_jodan_quote(); SqlCommand select_max_project = new SqlCommand(Statementsclass.select_max_project_id, conn); SqlDataReader read_max_project_id = select_max_project.ExecuteReader(); if (read_max_project_id.Read()) { Valuesclass.project_id = (Convert.ToInt32(read_max_project_id["Project ID"])) + 1; read_max_project_id.Close(); } ConnectionClass.Dispose_connection(conn); }
public void Save() { ArrayList values = new ArrayList() { Navn, Adresse_ID }; List <string> keys = new List <string>() { "Navn", "Adresse_ID" }; ConnectionClass.Insert(tableName, values, keys, conn); }
public void Update() { ArrayList values = new ArrayList() { Navn, Alder }; List <string> keys = new List <string>() { "Navn", "Alder" }; ConnectionClass.Update(tableName, values, keys, conn); }
public void filldata() { ConnectionClass mycon = new ConnectionClass(); string u_id = Session["u_id"].ToString(); if (Session["u_id"] == null) { Response.Write("<script>alert('NOT AUTHORIZED');</script>"); } else { DataCat.DataSource = mycon.select("select * from tbl_category where u_id='" + u_id + "'"); DataCat.DataBind(); } }
protected void btnRegister_Click(object sender, EventArgs e) { //Create a new user User user = new User(txtName.Text, txtPassword.Text, txtEmail.Text, "user"); //Register the user and return a result message if (ConnectionClass.RegisterUser(user)) { lblResult.Text = "Пользователь зарегистрирован"; } else { lblResult.Text = "Такой пользователь уже зарегестрирован"; } }
static void Main(string[] args) { connClass = new ConnectionClass(); var connectionFactory = connClass.getConnectionFactored(); var connection = connectionFactory.CreateConnection(); var channel = connection.CreateModel(); channel.BasicQos(0, 1, false); CarReceiver messageReceiver = new CarReceiver(channel); channel.BasicConsume("cars.queue", false, messageReceiver); channel.BasicConsume("reservation.queue", false, messageReceiver); Console.ReadLine(); }
public List <CostOfOwnership> GetCostOfOwnershipDetails(string FHnumber) { List <CostOfOwnership> lstCostOfOwnership = new List <CostOfOwnership>(); con = ConnectionClass.getConnection(); SqlCommand cmd = new SqlCommand(); try { cmd.Connection = con; cmd.CommandText = "sp_GetCostOfOwnerShipDetails"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FHnumber", SqlDbType.NVarChar).Value = FHnumber; cmd.Parameters.Add("@Action", SqlDbType.NVarChar).Value = "Select"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { CostOfOwnership costOfOwnership = new CostOfOwnership(); costOfOwnership.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); costOfOwnership.FHnumber = Convert.ToString(ds.Tables[0].Rows[i]["FHnumber"]); costOfOwnership.Associate = Convert.ToString(ds.Tables[0].Rows[i]["Associate"]); costOfOwnership.DateProcessed = Convert.ToDateTime(ds.Tables[0].Rows[i]["DateProcessed"]); costOfOwnership.TimeProcessed = (TimeSpan)ds.Tables[0].Rows[i]["TimeProcessed"]; costOfOwnership.TransactionName = Convert.ToString(ds.Tables[0].Rows[i]["TransactionName"]); costOfOwnership.Msg = Convert.ToString(ds.Tables[0].Rows[i]["Msg"]); costOfOwnership.TransactionCount = Convert.ToInt32(ds.Tables[0].Rows[i]["Count"]); lstCostOfOwnership.Add(costOfOwnership); } } ConnectionClass.closeconnection(con); } catch (Exception ex) { ConnectionClass.closeconnection(con); DataLogger.Write("Report-sp_GetCostOfOwnerShipDetails", ex.Message); } finally { ConnectionClass.closeconnection(con); } return(lstCostOfOwnership); }
void Copy_addon() { DataTable dt_copy_addon = new DataTable(); SqlConnection conn = ConnectionClass.GetConnection_jodan_quote(); SqlDataAdapter copy_addon = new SqlDataAdapter(Statementsclass.copy_addon, conn); copy_addon.SelectCommand.Parameters.AddWithValue("@ID", Valuesclass.id); copy_addon.Fill(dt_copy_addon); for (int i = 0; i < dt_copy_addon.Rows.Count; i++) { int add_on_id = Convert.ToInt32((dt_copy_addon.Rows[i]["add_on_id"]).ToString()); int add_on_width = Convert.ToInt32(dt_copy_addon.Rows[i]["add_on_width"].ToString()); int add_on_height = Convert.ToInt32(dt_copy_addon.Rows[i]["add_on_height"].ToString()); int material_id = Convert.ToInt32((dt_copy_addon.Rows[i]["material_id"]).ToString()); double?material_thickness = ((dt_copy_addon.Rows[i]["material_thickness"]) as double?) ?? 0; int add_on_material_id = Convert.ToInt32((dt_copy_addon.Rows[i]["add_on_material_id"]).ToString()); double?material_cost = ((dt_copy_addon.Rows[i]["material_cost"]) as double?) ?? 0; int? labour_hours = ((dt_copy_addon.Rows[i]["labour_hours"]) as int?) ?? 0; double?labour_cost = ((dt_copy_addon.Rows[i]["labour_cost"]) as double?) ?? 0; int? position = ((dt_copy_addon.Rows[i]["position"]) as int?) ?? 0; int? removable = ((dt_copy_addon.Rows[i]["removable"]) as int?) ?? 0; int? qty = ((dt_copy_addon.Rows[i]["qty"]) as int?) ?? 0; int? powder_coated = ((dt_copy_addon.Rows[i]["powder_coated"]) as int?) ?? 0; double?powder_coat_cost = ((dt_copy_addon.Rows[i]["powder_coat_cost"]) as double?) ?? 0; double?unit_material_cost = ((dt_copy_addon.Rows[i]["unit_material_cost"]) as double?) ?? 0; SqlCommand insert_add_on = new SqlCommand(Statementsclass.insert_add_on, conn); insert_add_on.Parameters.AddWithValue("@quotation_id", Valuesclass.quote_id); insert_add_on.Parameters.AddWithValue("@add_on_id", dt_copy_addon.Rows[i]["add_on_id"].ToString()); insert_add_on.Parameters.AddWithValue("@add_on_width", dt_copy_addon.Rows[i]["add_on_width"].ToString()); insert_add_on.Parameters.AddWithValue("@add_on_height", dt_copy_addon.Rows[i]["add_on_height"].ToString()); insert_add_on.Parameters.AddWithValue("@material_id", material_id); insert_add_on.Parameters.AddWithValue("@material_thickness", material_thickness); insert_add_on.Parameters.AddWithValue("@add_on_material_id", add_on_material_id); insert_add_on.Parameters.AddWithValue("@material_cost", material_cost); insert_add_on.Parameters.AddWithValue("@labour_hours", labour_hours); insert_add_on.Parameters.AddWithValue("@labour_cost", labour_cost); insert_add_on.Parameters.AddWithValue("@position", position); insert_add_on.Parameters.AddWithValue("@removable", removable); insert_add_on.Parameters.AddWithValue("@qty", qty); insert_add_on.Parameters.AddWithValue("@powder_coated", powder_coated); insert_add_on.Parameters.AddWithValue("@powder_coat_cost", powder_coat_cost); insert_add_on.Parameters.AddWithValue("@unit_material_cost", unit_material_cost); insert_add_on.ExecuteNonQuery(); } }
protected void DataFolder_ItemCommand(object source, DataListCommandEventArgs e) { ConnectionClass mycon = new ConnectionClass(); if (e.CommandName == "delete") { string path = e.CommandArgument.ToString(); mycon.iud("update tbl_pvt set status='INACTIVE' where path='" + path + "'"); string user_id = Session["u_id"].ToString(); mycon.iud("insert into tbl_logs values('You have deleted a file from your Private folder','" + user_id + "','" + DateTime.Now.ToString() + "')"); } else if (e.CommandName == "view") { string path = e.CommandArgument.ToString(); // done.NavigateUrl = path; string cd = Request.QueryString["c_id"]; string u_id = mycon.GetValue("select u_id from tbl_category where c_id=" + cd); string cdd = mycon.GetValue("select c_id from tbl_category where u_id='" + u_id + "'AND c_name='Text'"); if (Request.QueryString["c_id"].ToString() != cdd) { Response.Redirect(path); } else { SecureFile sf = new SecureFile(); string p = MapPath(path); int index = path.IndexOf('-'); int len = path.Length; string fname = path.Substring(index, len - index); if (passs.Text != "") { string pth = sf.decrypt(fname, p, passs.Text); // Response.Redirect(pth); if (pth != "") { string ext = Path.GetExtension(fname); Response.Redirect("~/folder/" + fname + "_decrypted" + ext); } else { Response.Write("INVALID PASSWORD"); } } } } fillfolderdata(); }
protected void btnSubmit_Click(object sender, EventArgs e) { if (FileUpload1.HasFile) { if (FileUpload1.PostedFile.ContentType.Equals("application/pdf")) { if (flag == true) { try { string filename = Path.GetFileName(FileUpload1.FileName); FileUpload1.PostedFile.SaveAs(Server.MapPath("~/Files/" + Session["login"] + "/Accounting/") + filename); } catch (Exception ex) { lblFileUpload.Text = "File could not be uploaded" + ex.Message; } } } else { lblFileUpload.Text = "File must be a PDF File"; } if (lblFileUpload.Text == "") { if (flag == true) { string selectedDate = txtDeadline.Text; DateTime dt1 = DateTime.Parse(selectedDate); ConsultationRequestClass consultationrequestclass = new ConsultationRequestClass(txtName.Text, Session["login"].ToString(), txtMail.Text, txtTitle.Text, DropDownList1.SelectedItem.Text, dt1, txtDescription.Text, FileUpload1.PostedFile.FileName.ToString(), "Processing", ""); string result = ConnectionClass.AddAccoutingRequest(consultationrequestclass); int a = ConnectionClass.RetrieveLastId("RqstAccounting"); ConnectionClass.UpdateAccountingFilenamebyId(a); string oldname = Server.MapPath("~/Files/" + Session["login"] + "/Accounting/") + FileUpload1.PostedFile.FileName; string newname = Server.MapPath("~/Files/" + Session["login"] + "/Accounting/") + Convert.ToString(a) + ".pdf"; File.Move(oldname, newname); lblResult.Text = result; Label1.Visible = false; } } else { lblResult.Text = ""; } } }
public static FBLoginDetails ActivateFBUser(FBLoginDetails _FBLoginDetails) { if ((SessionState._SignInUser != null)) { ConnectionClass conn = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_brandyy_select_SelectBySmUID"); cmd.Parameters.AddWithValue("@sm_uid", _FBLoginDetails.ID); cmd.Parameters.AddWithValue("@sm_id", 1); conn.GetDataSet(cmd); if (conn.IsSuccess && conn.DataSet.Tables[0].Rows.Count > 0 ) { // check if the logged in user is same as the fb user registered in our database if (Convert.ToString(conn.DataSet.Tables[0].Rows[0]["email"]) == Convert.ToString(_FBLoginDetails.Email)) { // get user long lived access token and other profile details importfbuserdetails t = new importfbuserdetails(); string longlivedtoken = t.getUserLongLivedAccessToken(_FBLoginDetails.AccessToken, SessionState._SignInUser.reg_uid); InsertIntoRegistrationTbl_Fb(_FBLoginDetails, longlivedtoken); t.getUserFriends(_FBLoginDetails.AccessToken, SessionState._SignInUser.reg_uid); _FBLoginDetails.Message = "SUCCESS"; _FBLoginDetails.LoginSuccessRedirectHomePage = "myprofile.aspx"; } else { _FBLoginDetails.Message = "There is another user registered with the same account.<br>Please contact admin if there is a genuine breach."; } } else { // get user long lived access token and other profile details importfbuserdetails t = new importfbuserdetails(); string longlivedtoken = t.getUserLongLivedAccessToken(_FBLoginDetails.AccessToken, SessionState._SignInUser.reg_uid); InsertIntoRegistrationTbl_Fb(_FBLoginDetails, longlivedtoken); t.getUserFriends(_FBLoginDetails.AccessToken, SessionState._SignInUser.reg_uid); _FBLoginDetails.Message = "SUCCESS"; _FBLoginDetails.LoginSuccessRedirectHomePage = "myprofile.aspx"; } } else { _FBLoginDetails.Message = "Your Login session has expired"; _FBLoginDetails.LoginSuccessRedirectHomePage = "login.aspx"; } return _FBLoginDetails; ; }
public static bool EnrollUserFinger(int iMachineNumber, int iUserId, int iFingerIndex, int iFlag, ref int iError, int iConType, string sIP, int iPort) { var con = new ConnectionClass(); bool bResult = false; int iTempError = 0; var bConnect = false; switch (iConType) { case 1: bConnect = con.ConnectViaUSB(); break; case 2: con.SIP = sIP; con.IPort = iPort; bConnect = con.ConnectViaNet(); break; default: break; } if (bConnect) { con.DDevice.CancelOperation(); con.DDevice.DelUserTmp(iMachineNumber, iUserId, iFingerIndex); if (con.DDevice.StartEnrollEx(iUserId.ToString(), iFingerIndex, iFlag)) { con.DDevice.StartIdentify(); bResult = true; } else { con.DDevice.GetLastError(ref iTempError); iError = iTempError; } } else { bResult = false; } return(bResult); }
protected void Page_Load(object sender, EventArgs e) { string uid = Request.QueryString["u_id"]; ConnectionClass mycon = new ConnectionClass(); DataTable dt = mycon.select("select * from user_regis where u_id=" + uid); backimage.ImageUrl = dt.Rows[0][14].ToString(); proimg.ImageUrl = dt.Rows[0][12].ToString(); fname.Text = dt.Rows[0][1].ToString(); mname.Text = dt.Rows[0][2].ToString(); lname.Text = dt.Rows[0][3].ToString(); username.Text = dt.Rows[0][4].ToString(); dateofb.Text = dt.Rows[0][11].ToString(); disc.Text = dt.Rows[0][15].ToString(); tint.Text = dt.Rows[0][16].ToString(); }
public void TestInit() { MySqlCommand cmd; ConnectionClass.OpenConnection(); cmd = ConnectionClass.con.CreateCommand(); //New Connection object cmd.CommandText = "INSERT INTO `17agileteam5db`.`logindetails` (`StaffID`, `Forename`, `Surname`, `Pass`, `Position`, `Email`) VALUES ('1', '1', '1', '1', '1', '*****@*****.**');SELECT LAST_INSERT_ID();"; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { userID = reader.GetString("LAST_INSERT_ID()"); } reader.Close(); ConnectionClass.CloseConnection(); }
public void CleanUp() { MySqlCommand cmd; ConnectionClass.OpenConnection(); cmd = ConnectionClass.con.CreateCommand(); //New Connection object cmd.CommandText = "DELETE FROM storedfiles WHERE ProjectID = " + projectID; cmd.ExecuteReader(); ConnectionClass.CloseConnection(); newProject.DeleteProject(projectID); ConnectionClass.OpenConnection(); cmd = ConnectionClass.con.CreateCommand(); //New Connection object cmd.CommandText = "DELETE FROM logindetails WHERE UserID = " + userID; cmd.ExecuteReader(); ConnectionClass.CloseConnection(); }
private void But_send_Click_1(object sender, EventArgs e) { ConnectionClass.Parameters(new SqlParameter("@DocId", DocId), new SqlParameter("@reservationid", ReservationId), X); ConnectionClass.SQLCommand("Cprco_AddNewPrescription", CommandType.StoredProcedure, ExecuteReaderOrNonQuery.executeNonQuery); int PrescriptionId = Convert.ToInt32(X.Value); for (int i = 0; i < IdList.Count; i++) { ConnectionClass.Parameters(new SqlParameter("@PrescriptionId", PrescriptionId), new SqlParameter("@drugID", IdList[i]), new SqlParameter("@Qnty", QntyLis[i]), new SqlParameter("@dose", DoseList[i])); ConnectionClass.SQLCommand("Cproc_AddPrescriptionDetail", CommandType.StoredProcedure, ExecuteReaderOrNonQuery.executeNonQuery); } MessageBox.Show("تم الإرسال بنجاح"); this.Close(); AddNewPrescription.Value.Clear(); }
static void Main(string[] args) { connClass = new ConnectionClass(); var connectionFactory = connClass.getConnectionFactored(); var connection = connectionFactory.CreateConnection(); var channel = connection.CreateModel(); channel.BasicQos(0, 1, false); /* RpcClientCCY messageReceiver = new RpcClientCCY(channel); * channel.BasicConsume("reservation.queue", false, messageReceiver); * channel.BasicConsume("request.reservation.getByID", false, messageReceiver); * Console.ReadLine(); */ }
public static string Random_Get() { string result = ""; try { ConnectionClass obj = new ConnectionClass(); DataSet ds = obj.fillDataset("EXEC dbo.Random2015_Get"); foreach (DataRow dr in ds.Tables[0].Rows) { result += dr[0].ToString() + ","; } } catch { } if (result.EndsWith(",")) result = result.Remove(result.Length - 1); return result; }
protected void Button1_Click(object sender, EventArgs e) { User user = ConnectionClass.LoginUser(TextBox1.Text, TextBox2.Text); if (user != null) { Session["admin"] = user.UserName; Response.Redirect("AdminHome.aspx"); } else { Label1.ForeColor = System.Drawing.Color.Red; Label1.Text = "Invalid Username and Password"; } }
public void combo_fill_Doctor() { ConnectionClass conPInfo = new ConnectionClass("RecDoctorInformation"); List <SqlParameter> sqlPInfo = new List <SqlParameter>(); sqlPInfo.Add(new SqlParameter("@CompanyId", Session["companyid"].ToString())); DataTable dtUserInfo = new DataTable(); dtUserInfo = conPInfo.DisplayUserData(sqlPInfo).Tables[0]; foreach (DataRow drUserInfo in dtUserInfo.Rows) { cmbDoctor.Items.Add(new ListItem(drUserInfo["CoFirstName"].ToString() + " " + drUserInfo["CoMiddleName"].ToString() + " " + drUserInfo["CoLastName"].ToString(), drUserInfo["CoLoginId"].ToString())); } }
void Fill_data() { DataTable dt_customer = new DataTable(); SqlConnection conn = ConnectionClass.GetConnection_jodan_quote(); SqlDataAdapter select_customer = new SqlDataAdapter(Statementsclass.select_customer, conn); select_customer.Fill(dt_customer); cmb_customers.DataSource = dt_customer; cmb_customers.DisplayMember = "customer_name"; cmb_customers.ValueMember = "customer_name"; cmb_customers.SelectedIndex = -1; cmb_customers.MaxDropDownItems = 5; ConnectionClass.Dispose_connection(conn); }
protected void btnLogin_Click(object sender, EventArgs e) { User user = ConnectionClass.LoginUser(txtLogin.Text, txtPassword.Text); if (user != null) { //Store login variables in session Session["user"] = user; Response.Redirect("/Default.aspx"); } else { lblError.Text = "Login failed"; } }
void CreateNewEntry() { Pages.Appointment appointment = new Pages.Appointment(); appointment.Title = titleTextBox.Text; appointment.Category = appointmentCategoryComboBox.SelectedValue.ToString(); appointment.FromDate = (DateTime)appointmentFromDatePicker.SelectedDate; appointment.ToDate = (DateTime)appointmentToDatePicker.SelectedDate; appointment.Priority = (int)appointmentPriorityComboBox.SelectedIndex; appointment.State = (int)appointmentStatusComboBox.SelectedIndex; ConnectionClass connection = new ConnectionClass(); connection.InsertAppointment(appointment); }
public void TestInit() { MySqlCommand cmd; ConnectionClass.OpenConnection(); cmd = ConnectionClass.con.CreateCommand(); //New Connection object cmd.CommandText = "INSERT INTO logindetails(StaffID,Forename,Surname,Pass,Position,Email)VALUES('testlogin',1,1,'testlogin',1,1);SELECT LAST_INSERT_ID();"; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { userID = reader.GetString("LAST_INSERT_ID()"); } reader.Close(); ConnectionClass.CloseConnection(); }
public DataTable GetProcedures() { Connection target = new ConnectionClass(); target.GetType().InvokeMember("Open", BindingFlags.InvokeMethod, null, target, new object[] { this.connectionString }); if ((this.defaultDatabase != null) && (this.defaultDatabase != "")) { target.DefaultDatabase = this.defaultDatabase; } Recordset rs = (Recordset)target.GetType().InvokeMember("OpenSchema", BindingFlags.InvokeMethod, null, target, new object[] { SchemaEnum.adSchemaProcedures }); DataTable table = ConvertRecordset(rs); rs.Close(); target.Close(); return(table); }
void Application_Start(object sender, EventArgs e) { // Code that runs on application startup RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); try { //conecta ao banco ConnectionClass.openConnection(); } catch (Exception) { //registra um log } }
public static List <SMSON_SEND_BOX> getAllSend(string UserId) { var sendList = new List <SMSON_SEND_BOX>(); var conn = ConnectionClass.GetConnection(); var cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "FSP_SEND_BOX_GA"; cmd.Parameters.Add(new SqlParameter("@USER_IDS", SqlDbType.VarChar, 50)); cmd.Parameters["@USER_IDS"].Value = UserId; conn.Open(); try { var data = cmd.ExecuteReader(); while (data.Read()) { var send = new SMSON_SEND_BOX(); send.MOBILE_NUMBER = data["MOBILE_NUMBER"].ToString(); send.MAKE_DT = DateTime.Parse(data["MAKE_DT"].ToString()); if (data["SMS_STATUS"].ToString().Equals("0")) { send.STATUS = "Pending"; } if (data["SMS_STATUS"].ToString().Equals("1")) { send.STATUS = "Sent"; } if (data["SMS_STATUS"].ToString().Equals("2")) { send.STATUS = "Not Sent"; } if (String.IsNullOrEmpty(data["GROUP_NAME"].ToString())) { send.GROUP_NAME = "none"; } else { send.GROUP_NAME = data["GROUP_NAME"].ToString(); } sendList.Add(send); } } catch { } finally { conn.Close(); } return(sendList); }
//Fill page with dynamic controls showing products in database private void GenerateShopControls() { ArrayList coffeeList = ConnectionClass.GetCoffeeByType("%"); foreach (Coffee coffee in coffeeList) { //Create Controls Panel coffeePanel = new Panel(); Image image = new Image { ImageUrl = coffee.Image, CssClass = "ProductsImage" }; Literal literal = new Literal { Text = "<br />" }; Literal literal2 = new Literal { Text = "<br />" }; Label lblName = new Label { Text = coffee.Name, CssClass = "ProductsName" }; Label lblPrice = new Label { Text = String.Format("{0:0.00}", coffee.Price) + "<br />", CssClass = "ProductsPrice" }; TextBox textBox = new TextBox { ID = coffee.Id.ToString(), CssClass = "ProductsTextBox", Text = "0", Width = 60 }; //Add validation so only numbers can be entered into the textfields var validator = new RegularExpressionValidator { ValidationExpression = "^[0-9]*", ControlToValidate = textBox.ID, ErrorMessage = "Please enter a number." }; //Add controls to Panels coffeePanel.Controls.Add(image); coffeePanel.Controls.Add(literal); coffeePanel.Controls.Add(lblName); coffeePanel.Controls.Add(literal2); coffeePanel.Controls.Add(lblPrice); coffeePanel.Controls.Add(textBox); coffeePanel.Controls.Add(validator); pnlProducts.Controls.Add(coffeePanel); } }
private void But_Receive_Click(object sender, EventArgs e) { decimal ValidAmount; if (!string.IsNullOrEmpty(Txt_amount.Text) || Txt_amount.Text == "0") { if (decimal.TryParse(Txt_amount.Text, out ValidAmount)) { string serial = ConnectionClass.PaymentSerial(); Hospital.Cproc_AddPayment(Reservation, serial, Convert.ToDecimal(Txt_amount.Text), Txt_Discription.Text); Txt_amount.Clear(); Txt_Discription.Clear(); var result = MessageBox.Show("تم الاستلام بالإيصال، هل تريد تسجيل خروج للمريض", serial, MessageBoxButtons.YesNo); if (result == System.Windows.Forms.DialogResult.Yes) { this.Close(); Checkout Checkout = new Checkout(); Checkout.fromAnotherForm = 1; Checkout.RoomId = IdRoom; Checkout.x = IdRoom; TextBox Tx = new TextBox(); Tx.Text = Checkout.RoomNO(IdRoom); Checkout.Controls[14].Hide(); Tx.Location = new System.Drawing.Point(375, 53); Tx.Enabled = false; Tx.RightToLeft = RightToLeft.Yes; Checkout.Controls.Add(Tx); Checkout.Show(); Checkout.WindowState = FormWindowState.Normal; Checkout.TopMost = true; } else { this.Close(); } } else { MessageBox.Show("يرجى كتابة المبلغ المستلم بشكل صحيح"); } } else { MessageBox.Show("يرجى إدخال المبلغ المدفوع"); } }
private void FillPage() { ArrayList inventoryList = new ArrayList(); if (!IsPostBack) { inventoryList = ConnectionClass.GetInventoryByType("%"); } else { inventoryList = ConnectionClass.GetInventoryByType(DropDownList1.SelectedValue); } StringBuilder sb = new StringBuilder(); foreach (Items items in inventoryList) { sb.Append( string.Format( @"<table class='itemTable'> <tr> <th rowspan='2' width='150px'><img runat='server' src='{2}' /></th> <th width='50px'>Name: </td> <td>{0}</td> </tr> <tr> <th>Category: </th> <td>{1}</td> </tr> <tr> <th>Description: </th> <td>{2} </td> </tr> <tr> <th>Description: </th> <td>{2} </td> </tr> </table>", items.name, items.categoryname, items.description /*items.available, items.staffonly, items.imagepath*/)); Label1.Text = sb.ToString(); } }
public List <Association> GetAssociation(string FHnumber) { List <Association> lstAssociation = new List <Association>(); con = ConnectionClass.getConnection(); SqlCommand cmd = new SqlCommand(); try { cmd.Connection = con; cmd.CommandText = "sp_InsertUpdateAssociation"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FHnumber", SqlDbType.NVarChar).Value = FHnumber; cmd.Parameters.Add("@Action", SqlDbType.NVarChar).Value = "Select"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Association association = new Association(); association.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); association.FHnumber = Convert.ToString(ds.Tables[0].Rows[i]["FHnumber"]); association.Associate = Convert.ToString(ds.Tables[0].Rows[i]["Associate"]); association.AssocCanceledBy = Convert.ToString(ds.Tables[0].Rows[i]["AssocCanceledBy"]); association.OriginalDateofAssoc = Convert.ToDateTime(ds.Tables[0].Rows[i]["OriginalDateofAssoc"]); association.AssocCanceledDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["AssocCanceledDate"]); association.AssocStatus = Convert.ToBoolean(ds.Tables[0].Rows[i]["AssocStatus"]); lstAssociation.Add(association); } } ConnectionClass.closeconnection(con); } catch (Exception ex) { ConnectionClass.closeconnection(con); DataLogger.Write("Admin-GetAssociationList", ex.Message); } finally { ConnectionClass.closeconnection(con); } return(lstAssociation); }
private string getAccessToken(Int64 page_id) { string token=""; if (page_tokens.ContainsKey(page_id)) token = page_tokens[page_id]; else { // get user access token SqlCommand cmd = new SqlCommand("sp_Get_brands_sm_token_by_page_id"); cmd.Parameters.AddWithValue("@page_id", page_id); ConnectionClass ConnObj1 = new ConnectionClass(); ConnObj1.GetDataSet(cmd); if (ConnObj1.IsSuccess && ConnObj1.DataSet.Tables.Count > 0 && ConnObj1.DataSet.Tables[0].Rows.Count > 0) { page_tokens.Add(page_id, Convert.ToString(ConnObj1.DataSet.Tables[0].Rows[0]["token"])); page_verifier.Add(page_id, Convert.ToString(ConnObj1.DataSet.Tables[0].Rows[0]["verifier"])); token = page_tokens[page_id]; } ConnObj1.ReleaseConnection(); } return token; }
private void CheckIfActivitiesWaitingVerification() { Int32 b_id = SessionState._BrandAdmin.brand_id; SqlCommand cmd = new SqlCommand("sp_brandyy_GetAllPendingActivitiesOverview"); cmd.Parameters.AddWithValue("@brand_id", SessionState._BrandAdmin.brand_id); cmd.Parameters.AddWithValue("@verification_status", 0); ConnectionClass ConnObj1 = new ConnectionClass(); ConnObj1.GetDataSet(cmd); if (ConnObj1.IsSuccess && ConnObj1.DataSet.Tables.Count > 0 && ConnObj1.DataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ConnObj1.DataSet.Tables[0].Rows) { if (Convert.ToInt64(dr["num_of_pending_activities"]) > 0) { display_verification = true; break; } } } ConnObj1.ReleaseConnection(); }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { fbuser t = user[0]; HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://api.instagram.com/v1/users/" + t.sm_uid + "/media/recent/?access_token=" + accessToken_1); request.Method = "GET"; request.ContentType = "application/x-www-form-urlencoded"; WebResponse response = request.GetResponse(); string responseData = new StreamReader(response.GetResponseStream()).ReadToEnd(); var tmpResult = JObject.Parse(responseData); var resultObject = tmpResult["data"].Values<JObject>() .Where(n => n["caption"].Count() > 0) .Where(n => n["caption"]["text"].Value<string>().Contains("@ichooseit")) .Select(n => new { img = n["images"]["thumbnail"]["url"], link = n["link"], text = n["caption"]["text"], mediaID = n["id"], created_time = n["created_time"], likes = n["likes"]["count"], Context = n.Parent }).ToArray(); //Loop through the returned users foreach (var i in resultObject) { Int32 brand_id1; Int64 campaign_id1; Int64 action_id1; string message = Convert.ToString( i.text ).ToLower(); hashtag = hashtag.Replace("@" + System.Configuration.ConfigurationManager.AppSettings["InstaIchooseItHashtag"], "").ToLower(); string[] hashtag_arr = hashtag.Split(' '); bool valid = true; foreach (string hash in hashtag_arr) { if (!message.Contains(hash.Trim())) { valid = false; break; } } if (valid == false) { //continue; } // case : default text defined for campaign if (defaulttext != "") { if (!message.Contains(defaulttext)) { valid = false; //continue; } } ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); // case : valid if (valid == true) { #region for brand post brand_id1 = brand_id; campaign_id1 = campaign_id; action_id1 = action_id; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))); cmd.Parameters.AddWithValue("@pid", Convert.ToString(i.mediaID)); decimal points = 0; no_of_friends = 0; no_of_likes = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if ( Convert.ToInt32( i.likes ) > 0 ) { no_of_likes = Convert.ToInt32( i.likes ); } points += (no_of_likes * reward_on_likes); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); #endregion } else { brand_id1 = 2; campaign_id1 = 8; action_id1 = 27; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))));// cmd.Parameters.AddWithValue("@pid", Convert.ToString( i.mediaID )); cmd.Parameters.AddWithValue("@reward_amount", 0); cmd.Parameters.AddWithValue("@reward_percent", 0); cmd.Parameters.AddWithValue("@reward_product", ""); cmd.Parameters.AddWithValue("@no_of_friends", 0); cmd.Parameters.AddWithValue("@no_of_likes", 0); cmd.Parameters.AddWithValue("@no_of_shares", 0); cmd.Parameters.AddWithValue("@reward_per_user", 0); cmd.Parameters.AddWithValue("@reward_on_friend", 0); cmd.Parameters.AddWithValue("@reward_on_likes", 0); cmd.Parameters.AddWithValue("@reward_on_shares", 0); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); // insert facebook post cmd = new SqlCommand("sp1_IChooseIT_User_Insta_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", ConvertFromUnixTimestamp(Convert.ToDouble( i.created_time)) ); cmd.Parameters.AddWithValue("@updated_time", ConvertFromUnixTimestamp(Convert.ToDouble(i.created_time))); cmd.Parameters.AddWithValue("@sm_img_link", Convert.ToString(i.img)); cmd.Parameters.AddWithValue("@link", Convert.ToString(i.link)); cmd.Parameters.AddWithValue("@sm_desc", Convert.ToString(i.text)); cmd.Parameters.AddWithValue("@fb_post_id", Convert.ToString(i.mediaID)); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserLikesAPage(string accessToken, List<fbuser> user, string page_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { // database will have the list of pages that a user likes already // we only need to cross check with the database fbuser t = user[0]; // get the list of user who like the given page ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp_IChooseIT_Get_Users_WhoLikeAPage"); cmd.Parameters.AddWithValue("@page_id", page_id); cmd.Parameters.AddWithValue("@sm_id", 3); ConnObj.GetDataSet(cmd); decimal points = 0; if (ConnObj.IsSuccess && ConnObj.DataSet.Tables.Count > 0 && ConnObj.DataSet.Tables[0].Rows.Count > 0) { ConnectionClass ConnObj2 = new ConnectionClass(); foreach (DataRow dr in ConnObj.DataSet.Tables[0].Rows) { if (Convert.ToInt64(dr["reg_uid"]) != t.reg_uid) continue; SqlCommand cmd1 = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd1.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd1.Parameters.AddWithValue("@brand_id", brand_id); cmd1.Parameters.AddWithValue("@campaign_id", campaign_id); cmd1.Parameters.AddWithValue("@action_id", action_id); cmd1.Parameters.AddWithValue("@created_on", DateTime.Now.ToString()); cmd1.Parameters.AddWithValue("@pid", ""); // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (reward_on_friend * no_of_friends); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd1.Parameters.AddWithValue("@reward_amount", reward_amount); cmd1.Parameters.AddWithValue("@reward_percent", reward_percent); cmd1.Parameters.AddWithValue("@reward_product", reward_product); cmd1.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd1.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd1.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd1.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd1.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd1.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd1.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd1.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj2.GetDataTab(cmd1); } ConnObj2.ReleaseConnection(); ConnObj.ReleaseConnection(); } }
public void checkIfUserLikedAPost(string accessToken, List<fbuser> user, string post_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { foreach (fbuser t in user) { HttpWebRequest request = (HttpWebRequest)WebRequest.Create("https://api.instagram.com/v1/media/" + post_id + "/likes?access_token=" + accessToken_1); request.Method = "GET"; request.ContentType = "application/x-www-form-urlencoded"; WebResponse response = request.GetResponse(); string responseData = new StreamReader(response.GetResponseStream()).ReadToEnd(); var tmpResult = JObject.Parse(responseData); var resultObject = tmpResult["data"].Values<JObject>() .Where(n => n["id"].Value<string>().Contains(t.sm_uid)) .Select(n => new { username = n["username"], id = n["id"], Context = n.Parent }).ToArray(); try { if (resultObject.Count() > 0) { #region save to sp1_IChooseIT_User_Activities_Insert ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ""); cmd.Parameters.AddWithValue("@pid", ""); decimal points = 0; no_of_friends = 0; no_of_likes = 0; no_of_shares = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); #endregion } } catch (Exception ex) { } } }
private string GetTreeXML(CatalogClass cat,ConnectionClass con) { string cube = "PsiMedicaDemoCube"; StringBuilder strDimBldr = new StringBuilder("<ContentMenu>"); CubeDef cubeDef = cat.CubeDefs[cube]; Member mebr = cubeDef.Dimensions["Payor"].Hierarchies[0].Levels["(All)"].Members["HI-TECH CORP (HMO)"]; for (int i=0; i<cubeDef.Dimensions.Count; i++) { // Write out the field or level names. Dimension curDim = cubeDef.Dimensions[i]; string sFolderCaption = ""; for (int j=0;j< curDim.Hierarchies.Count; j++) { sFolderCaption = curDim.Name; if (curDim.Hierarchies[j].Name != "") sFolderCaption += "." + curDim.Hierarchies[j].Name; strDimBldr.Append("<MenuItem id=\"" + curDim.Hierarchies[j].UniqueName + "\" type=\"dimension\" dimension=\"" + curDim.UniqueName + "\" FieldList=\"1\" name=\"" + sFolderCaption + "\">"); // for (int l=0;l<curDim.Hierarchies[j].Levels.Count; l++) // { // strDimBldr.Append("<MenuItem id=\"" + curDim.Hierarchies[j].Levels[l].UniqueName + "\" type=\"level\" dimension=\"" + curDim.Hierarchies[j].UniqueName + "\" source=\"FieldList\" dragEnabled=\"1\" level=\"1\" name=\"" + curDim.Hierarchies[j].Levels[l].Caption + "\">"); // for (int k=0;k<curDim.Hierarchies[j].Levels[l].Members.Count; k++) // { // strDimBldr.Append("<MenuItem id=\"" + curDim.Hierarchies[j].Levels[l].Members[k].UniqueName + "\" type=\"member\" dimension=\"" + curDim.Hierarchies[j].UniqueName + "\" source=\"FieldList\" dragEnabled=\"1\" member=\"1\" name=\"" + curDim.Hierarchies[j].Levels[l].Members[k].Caption + "\" />"); // } // strDimBldr.Append("</MenuItem>"); // } strDimBldr.Append("</MenuItem>"); } } Recordset rst=null; try { try { rst = (Recordset) con.GetType().InvokeMember( "OpenSchema", System.Reflection.BindingFlags.InvokeMethod , null, con, new object[] {SchemaEnum.adSchemaSets,new object[]{"PsiMedcaCubes",null,cube}} ); } catch {} if (rst.RecordCount>0) { // Write out the folder name for Named Sets strDimBldr.Append("<MenuItem id=\"Named Sets\" name=\"Named Sets\">"); while (! rst.EOF) { // Write out the named set if the function CreateVirtualDimension is not included - this was the means // by which 7.0 cubes create virtual dimensions and these should not be included twice. if (rst.Fields["EXPRESSION"].Value.ToString().IndexOf("CreateVirtualDimension") < 0) { // The funny replace expression on the dimensions is to add square brackets for // named sets with multiple dimensions. strDimBldr.Append("<MenuItem id=\"set" + rst.Fields["SET_NAME"] + "\" type=\"set\" source=\"FieldList\" dragEnabled=\"1\" set=\"" + rst.Fields["EXPRESSION"] + "\" dimension=\"[" + Regex.Replace(rst.Fields["DIMENSIONS"].Value.ToString(), @",","],[") + "]\" name=\"" + rst.Fields["SET_NAME"].Value.ToString() + "\"/>"); } rst.MoveNext(); } strDimBldr.Append("</MenuItem>"); } rst = null; } catch(Exception ex) { // Reserved. Don\"t report the error for now. Most likely caused by a 7.0/2000 version problem. strDimBldr.Append(ex.ToString()); } strDimBldr.Append("</ContentMenu>"); System.Xml.XmlDocument doc = new System.Xml.XmlDocument(); strDimBldr.Replace("&","&"); return strDimBldr.ToString(); }
private void PrintChildItems( DataTable tbl ) { ConnectionClass ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp_select_brand_panel"); ConnObj.GetDataTab(cmd); string close_tag_level_1 = ""; string close_tag_level_2 = ""; string visible_row = ""; foreach (DataRow row in ConnObj.DataTab.Rows) { visible_row = " style='display:none' "; if (tbl.Select("panel_id='"+Convert.ToString(row["panel_id"]+"'")).Length > 0) { visible_row = " style='display:' "; } if (Convert.ToInt64(row["panel_id"]) == 24 && display_store_verification == false) { visible_row = " style='display:none' "; } if (Convert.ToInt64(row["panel_id"]) == 25 && display_verification == false) { visible_row = " style='display:none' "; } if (Convert.ToInt16(row["menu_level"]) == 1) { lblMenu.Text += close_tag_level_2 + close_tag_level_1; close_tag_level_1 = ""; close_tag_level_2 = ""; lblMenu.Text += "<div id=\"" + Convert.ToInt64(row["panel_id"]) + "\" runat=\"server\" style=\"text-align:center;background-color:#dbd3d3;border-top:1px solid #fff;line-height:37px\">" + "<strong>" + Convert.ToString(row["panel_name"]) + "</strong></div>"; if (Convert.ToBoolean(row["has_child"])) { lblMenu.Text += "<ul class=\"sidebar-menu\">"; close_tag_level_1 = "</ul>" + close_tag_level_1; } } if (Convert.ToInt16(row["menu_level"]) == 2) { lblMenu.Text += close_tag_level_2; close_tag_level_2 = ""; if (Convert.ToBoolean(row["has_child"])) { lblMenu.Text += "<li id=\"" + Convert.ToInt64(row["panel_id"]) + "\" runat=\"server\" class=\"treeview\" " + visible_row + ">" + "<a href=\"" + SessionState.WebsiteURLBrand + Convert.ToString(row["url"]) + "\">" + "<i class=\"fa fa-th\"></i> <span>" + Convert.ToString(row["panel_name"]) + "</span>" +"<i class=\"fa fa-angle-left pull-right\"></i>" + "</a>" +"<ul class=\"treeview-menu\">"; close_tag_level_2 = "</ul></li>"; } else { lblMenu.Text += "<li id=\"" + Convert.ToInt64(row["panel_id"]) + "\" runat=\"server\" " + visible_row + ">" + "<a href=\"" + SessionState.WebsiteURLBrand + Convert.ToString(row["url"]) + "\">" + "<i class=\"fa fa-th\"></i> <span>" + Convert.ToString(row["panel_name"]) + "</span>" + "</a>" + "</li>"; } } if (Convert.ToInt16(row["menu_level"]) == 3) { lblMenu.Text += "<li id=\"" + Convert.ToInt64(row["panel_id"]) + "\" runat=\"server\" " + visible_row + ">" + "<a href=\"" + SessionState.WebsiteURLBrand + Convert.ToString(row["url"]) + "\">" + "<i class=\"fa fa-angle-double-right\"></i> " + Convert.ToString(row["panel_name"]) + "</a></li>"; } } close_tag_level_1 = close_tag_level_2 + close_tag_level_1; if (close_tag_level_1 != "") { lblMenu.Text += close_tag_level_1; } }
public void getUserFriends(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/friends"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString(reg_uid); string data_id; string sm_id; sm_id="1"; //Loop through the returned locations foreach (var i in posts["data"]) { data_id = i["id"]; insert_stmt += insert_stmt_comma + "(" + sm_id + ", " + uid + ", '" + data_id + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_Insert_IChooseIT_UseR_SM_Friends"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@sm_id", sm_id); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void getUserPageLikes(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/likes"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString( reg_uid ); string category; string page_name; DateTime created_time; string page_id; //Loop through the returned friends foreach (var i in posts["data"]) { category = System.Web.HttpUtility.HtmlEncode(i["category"]); page_name = System.Web.HttpUtility.HtmlEncode(i["name"]); created_time = Convert.ToDateTime( i["created_time"] ); page_id = i["id"]; insert_stmt += insert_stmt_comma + "(" + uid + ",'" + category + "', '" + page_name + "', '" + created_time.ToString() + "','" + page_id + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_brandyy_User_FB_Likes_Insert"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { var client = new FacebookClient(accessToken); dynamic posts; if ((last_cron_run == "")) { posts = client.Get("/cooseit/tagged"); } else { posts = client.Get("/cooseit/tagged?since=" + last_cron_run); } fbuser t = user[0]; //Loop through the returned users foreach (var i in posts["data"]) { Int32 brand_id1; Int64 campaign_id1; Int64 action_id1; string message = i["message"]; hashtag = hashtag.Replace("@ichoose", ""); string[] hashtag_arr = hashtag.Split(' '); bool valid = true; foreach (string hash in hashtag_arr) { if (!message.Contains(hash.Trim())) { valid = false; break; } } if (valid == false) { //continue; } // case : default text defined for campaign if (defaulttext != "") { if (!message.Contains(defaulttext)) { valid = false; //continue; } } // check if the post link contains the post id if (t.sm_uid == i["from"].id) { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); // case : valid if (valid == true) { brand_id1 = brand_id; campaign_id1 = campaign_id; action_id1 = action_id; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@pid", i["id"]); decimal points = 0; no_of_friends = 0; no_of_likes = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if (i.ContainsKey("likes")) { no_of_likes = i["likes"].data.Count; } points += (no_of_likes * reward_on_likes); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } else { brand_id1 = 2; campaign_id1 = 8; action_id1 = 16; cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@pid", i["id"]); cmd.Parameters.AddWithValue("@reward_amount", 0); cmd.Parameters.AddWithValue("@reward_percent", 0); cmd.Parameters.AddWithValue("@reward_product", ""); cmd.Parameters.AddWithValue("@no_of_friends", 0); cmd.Parameters.AddWithValue("@no_of_likes", 0); cmd.Parameters.AddWithValue("@no_of_shares", 0); cmd.Parameters.AddWithValue("@reward_per_user", 0); cmd.Parameters.AddWithValue("@reward_on_friend", 0); cmd.Parameters.AddWithValue("@reward_on_likes", 0); cmd.Parameters.AddWithValue("@reward_on_shares", 0); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); } string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); // insert facebook post cmd = new SqlCommand("sp1_IChooseIT_User_FB_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id1); cmd.Parameters.AddWithValue("@campaign_id", campaign_id1); cmd.Parameters.AddWithValue("@action_id", action_id1); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i["created_time"])); cmd.Parameters.AddWithValue("@updated_time", Convert.ToDateTime(i["updated_time"])); if (i.ContainsKey("picture")) { cmd.Parameters.AddWithValue("@sm_img_link", i["picture"]); } else { cmd.Parameters.AddWithValue("@sm_img_link", ""); } if (i.ContainsKey("link")) { cmd.Parameters.AddWithValue("@link", i["link"]); } else { if (i.ContainsKey("actions")) { cmd.Parameters.AddWithValue("@link", Convert.ToString(i["actions"][0]["link"])); } else { cmd.Parameters.AddWithValue("@link", ""); } } cmd.Parameters.AddWithValue("@sm_desc", i["message"]); cmd.Parameters.AddWithValue("@fb_post_id", i["id"]); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } } }
public void getAllProfileDetails(string accessToken) { var client = new FacebookClient(accessToken); //http://blog.prabir.me/posts/facebook-csharp-sdk-making-requests dynamic posts = (IDictionary<string, object>)client.Get("/me"); String insert_stmt = ""; String insert_stmt_comma = ""; //string reg_uid = Convert.ToString( SessionState._SignInUser.reg_uid ); string reg_uid = "1"; int verified_status=0; foreach (KeyValuePair<string, object> admObj in posts) { var id = Convert.ToString(admObj.Key); var value = Convert.ToString(admObj.Value); insert_stmt += insert_stmt_comma + "(1," + reg_uid + ",'" + id + "', '" + value + "', '/me' )"; insert_stmt_comma = ","; if (id == "verified") { verified_status = (value == "True") ? 1 : 0; } } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_Insert_IChooseIT_User_SM_All_Details"); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@sm_id", 1); ConnObj.GetDataTab(cmd); cmd = new SqlCommand("sp1_Update_IChooseIT_Registrations_FB_Verify"); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); cmd.Parameters.AddWithValue("@verified_status", verified_status); cmd.Parameters.AddWithValue("@sm_id", 1); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserSharedAPost(string accessToken, List<fbuser> user, string post_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/links/"); fbuser u = user[0]; //Loop through the returned link decimal points = 0; string post1 = post_id; if (post_id.Split('_').Length > 1) { post1 = post_id.Split('_')[1]; } string json = Newtonsoft.Json.JsonConvert.SerializeObject(posts); JObject tmpResult = JObject.Parse(json); var i = tmpResult["data"].Values<JObject>() .Where(n => n["link"].Value<string>().Contains(post1)) .Select(n => new { link = n["created_time"] }).ToArray(); // check if the post link contains the post id if (i.Count() > 0 ) { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", u.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", Convert.ToDateTime(i[0].link)); cmd.Parameters.AddWithValue("@pid", ""); // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = u.no_of_friends; points += (reward_on_friend * no_of_friends); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public void checkIfUserLikesAPage(string accessToken, List<fbuser> user, string page_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/likes/" + page_id); //Loop through the returned locations foreach (var i in posts["data"]) { decimal points = 0; fbuser t = user[0]; ConnectionClass ConnObj2 = new ConnectionClass(); SqlCommand cmd1 = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd1.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd1.Parameters.AddWithValue("@brand_id", brand_id); cmd1.Parameters.AddWithValue("@campaign_id", campaign_id); cmd1.Parameters.AddWithValue("@action_id", action_id); cmd1.Parameters.AddWithValue("@created_on", ""); cmd1.Parameters.AddWithValue("@pid", ""); // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (reward_on_friend * no_of_friends); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd1.Parameters.AddWithValue("@reward_amount", reward_amount); cmd1.Parameters.AddWithValue("@reward_percent", reward_percent); cmd1.Parameters.AddWithValue("@reward_product", reward_product); cmd1.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd1.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd1.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd1.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd1.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd1.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd1.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd1.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj2.GetDataTab(cmd1); } }
private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string query = "SELECT {{[Store].[All Stores],[Store].[All Stores].[USA],[Store].[All Stores].[USA].[CA],[Store].[All Stores].[USA].[OR],[Store].[All Stores].[USA].[WA]}*{[Gender].[All Gender].[F],[Gender].[All Gender].[M]}*{[Marital Status].[All Marital Status].[M],[Marital Status].[All Marital Status].[S]}*{[Product].[All Products].[Drink],[Product].[All Products].[Food],[Product].[All Products].[Non-Consumable]}} ON ROWS, " + "{{[Measures].[Unit Sales],[Measures].[Store Cost],[Measures].[Store Sales],[Measures].[Sales Count],[Measures].[Store Sales Net],[Measures].[Profit],[Measures].[Sales Average]}*{[Education Level].[All Education Level].[Bachelors Degree],[Education Level].[All Education Level].[Graduate Degree],[Education Level].[All Education Level].[High School Degree],[Education Level].[All Education Level].[Partial College],[Education Level].[All Education Level].[Partial High School]}*{[Time].[1997].[Q1],[Time].[1997].[Q2],[Time].[1997].[Q3],[Time].[1997].[Q4]}} ON COLUMNS " + "FROM [Sales]"; ConnectionClass conn = new ConnectionClass(); conn.Open("Provider=MSOLAP; Datasource=localhost; Initial Catalog=FoodMart 2000;","",string.Empty,(int)ADODB.ConnectOptionEnum.adConnectUnspecified); CellsetClass cs = new CellsetClass(); cs.Open(query,conn); Response.Write("<table border=1>"); for(int i=0;i<cs.Axes[0].DimensionCount;i++) { Response.Write("<tr>"); for(int j=0;j<cs.Axes[1].DimensionCount;j++) Response.Write("<th> </th>"); //string lastCaption= string.Empty;//cs.Axes[0].Positions[0].Members[i].Caption; int colspan=1; for(int j=0;j<cs.Axes[0].Positions.Count;j++ ) { Position pos = cs.Axes[0].Positions[j]; // if(lastCaption.Equals(pos.Members[i].Caption)) // { // Response.Write("<th> </th>"); // //colspan++; // } // else // { //Response.Write("<th colspan="+colspan+">" +cs.Axes[0].Positions[j-1].Members[i].Caption + "</th>"); //colspan=1; Response.Write("<th colspan="+colspan+">" +cs.Axes[0].Positions[j].Members[i].Caption + "</th>"); // lastCaption=pos.Members[i].Caption; // } //if(j==cs.Axes[0].Positions.Count-1) Response.Write("<th colspan="+colspan+">" +cs.Axes[0].Positions[j].Members[i].Caption + "</th>"); } Response.Write("</tr>"); } // string[] lastCaptions = new string[cs.Axes[1].DimensionCount]; for(int j=0;j<cs.Axes[1].Positions.Count;j++) { Position pos = cs.Axes[1].Positions[j]; Response.Write("<tr>"); for(int i=0;i<cs.Axes[1].DimensionCount;i++) { // if(pos.Members[i].Caption.Equals(lastCaptions[i])) // { // Response.Write("<th> </th>"); // continue; // } Response.Write("<th>" +pos.Members[i].Caption + "</th>" ); // lastCaptions[i]=pos.Members[i].Caption ; } for(int k=0;k<cs.Axes[0].Positions.Count;k++) { object[] coords=new object[]{k,j}; Cell cell = cs.get_Item(ref coords); Response.Write("<td>"+cell.FormattedValue + "</td>"); } Response.Write("</tr>"); } Response.Write("</table>"); }
/// <summary> /// Submit to execute program /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void submit_Click(object sender, EventArgs e) { string tableSrc = ""; string tableReading = ""; string errorMessageTotal = "Error List:\n\n"; //check parmeter to see if its empty if (sourceTable.TextLength ==0) { errorMessageTotal += "Error Missing Parameter For Source Table\n"; } //check parmeter to see if its empty if (destinationTable.TextLength == 0) { errorMessageTotal += "Error Missing Parameter For Destination Table\n"; } if ((sourceConnectionString == null) || (destinationConnectionString == null)) { errorMessageTotal += "Connection String Error\n"; } if (errorMessageTotal != "Error List:\n\n") { System.Windows.Forms.MessageBox.Show(errorMessageTotal); } else { //get the text for the table name tableReading = sourceTable.Text; //get the text for the table name tableSrc = destinationTable.Text; //create the ConnectionClass ConnectionClass connection = new ConnectionClass(sourceConnectionString, destinationConnectionString, tableReading, tableSrc); //Connect for the sorce and dest bool status = connection.Connect(); if(status == false) { //getting infromation about the table status = connection.GetInformation(); if (status == false) { //inserting it to the new table connection.SetInformation(); } else { //error message errorMessageTotal += "Writing Table Error\n"; System.Windows.Forms.MessageBox.Show(errorMessageTotal); } } else { errorMessageTotal += "Copying Table Error\n"; System.Windows.Forms.MessageBox.Show(errorMessageTotal); } } }
public void getUserTaggedPlaces(string accessToken, Int64 reg_uid) { var client = new FacebookClient(accessToken); dynamic posts = client.Get("/me/tagged_places"); String insert_stmt = ""; String insert_stmt_comma = ""; string uid = Convert.ToString(reg_uid); string location; string place_name; DateTime created_time; string data_id; string place_id; //Loop through the returned locations foreach (var i in posts["data"]) { created_time = Convert.ToDateTime(i["created_time"]); data_id = i["id"]; location = System.Web.HttpUtility.HtmlEncode(i["place"]["location"]); place_id = System.Web.HttpUtility.HtmlEncode(i["place"]["id"]); place_name = System.Web.HttpUtility.HtmlEncode(i["place"]["name"]); insert_stmt += insert_stmt_comma + "(" + uid + ", '" + data_id + "', '" + place_id + "','" + location + "', '" + place_name + "', '" + created_time.ToString() + "' )"; insert_stmt_comma = ","; } if (insert_stmt != "") { ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_FB_Locations_Insert"); cmd.Parameters.AddWithValue("@insert_stmt", insert_stmt); cmd.Parameters.AddWithValue("@reg_uid", reg_uid); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); } }
public ConnectionDefinition(ConnectionClass clazz, ConnectionType type) { Type= type; Class=clazz; }
public void checkIfUserHasAddedAnyPost(string accessToken, List<fbuser> user, string hashtag, string defaulttext, String last_cron_run, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { hashtag = hashtag.Replace("@" + System.Configuration.ConfigurationManager.AppSettings["TwitterIchooseItHashtag"], ""); string[] hashtag_arr = hashtag.Split(' '); hashtag = ""; foreach (string hash in hashtag_arr) { string hash1 = hash.Replace('#', ' ').Trim(); if (hash1 != "") { hashtag += "%23" + hash1; } } // //string str = "@ichooseit256%20from:" + SessionState._SignInUser.reg_email + "&result_type=mixed"; string str = "@ichooseit256" + hashtag + "&result_type=mixed"; string url = "https://api.twitter.com/1.1/search/tweets.json?q=" + str; string posts = Search(url, str); fbuser t = user[0]; try { var jsonDat = (JObject.Parse(posts)); foreach (var key in jsonDat) { if (key.Key.Equals("statuses")) { for (int x = 0; x < key.Value.Count(); x++) { // case : default text defined for campaign if (defaulttext != "") { // check if tweet contains the default text if (!Convert.ToString(key.Value[x]["text"]).Contains(defaulttext)) { continue; } } // check if the post link contains the post id if (t.sm_uid == Convert.ToString(key.Value[x]["user"]["id"])) { #region save to sp1_IChooseIT_User_Activities_Insert ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); string temp = Convert.ToString(key.Value[x]["created_at"]); cmd.Parameters.AddWithValue("@created_on", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); cmd.Parameters.AddWithValue("@pid", Convert.ToString(key.Value[x]["id"])); decimal points = 0; no_of_friends = 0; no_of_likes = 0; no_of_shares = 0; // reward table details if (reward_per_user > 0) { points = reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_on_likes > 0) { if (Convert.ToInt32(key.Value[x]["favorite_count"]) != 0) { no_of_likes = Convert.ToInt32(key.Value[x]["favorite_count"]); } points += (no_of_likes * reward_on_likes); } if (reward_on_shares > 0) { if (Convert.ToInt32(key.Value[x]["retweeted"]) != 0) { no_of_shares = Convert.ToInt32(key.Value[x]["retweeted"]); } points += (no_of_shares * reward_on_shares); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); string id = cmd.Parameters["@returnid"].Value.ToString(); if (id == "") { continue; } Int64 activity_id = Convert.ToInt64(id); #endregion #region save to IChooseIT_User_Activities_Tw_Post // insert twitter post cmd = new SqlCommand("sp1_IChooseIT_User_Tw_Activities_Insert"); cmd.Parameters.AddWithValue("@activity_id", activity_id); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); cmd.Parameters.AddWithValue("@updated_time", ParseDateTime(Convert.ToString(key.Value[x]["created_at"]))); if (Convert.ToString(key.Value[x]["entities"]["media"]) != "") { cmd.Parameters.AddWithValue("@sm_img_link", Convert.ToString(key.Value[x]["entities"]["media"][0]["media_url"])); } else { cmd.Parameters.AddWithValue("@sm_img_link", ""); } cmd.Parameters.AddWithValue("@sm_desc", Convert.ToString(key.Value[x]["text"])); string link = "https://twitter.com/" + Convert.ToString(key.Value[x]["user"]["screen_name"]) + "/status/" + Convert.ToString(key.Value[x]["id"]); cmd.Parameters.AddWithValue("@link", link); cmd.Parameters.AddWithValue("@fb_post_id", Convert.ToString(key.Value[x]["id"])); ConnObj.GetDataTab(cmd); ConnObj.ReleaseConnection(); #endregion } } } } } catch (Exception ex) { } }
protected void rpSocialProf_ItemCommand(object source, RepeaterCommandEventArgs e) { Int64 sm_id = Convert.ToInt64(e.CommandArgument); ConnectionClass conn = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_brandyy_Set_User_Photo"); cmd.Parameters.AddWithValue("@reg_uid", SessionState._SignInUser.reg_uid); cmd.Parameters.AddWithValue("@sm_id", sm_id); cmd.Parameters.Add("@returnurl", SqlDbType.VarChar, 250).Direction = ParameterDirection.Output; conn.ExecuteNonQuery(cmd); SessionState._SignInUser.profileurl = cmd.Parameters["@returnurl"].Value.ToString(); }
private static void InsertIntoRegistrationTbl_Fb(FBLoginDetails _FBLoginDetails, string accessToken) { ConnectionClass conn = new ConnectionClass(); SqlCommand cmd1 = new SqlCommand("sp_user_update_UserProfileDetails"); cmd1.Parameters.AddWithValue("@reg_uid", SessionState._SignInUser.reg_uid); cmd1.Parameters.AddWithValue("@sm_id", 1); cmd1.Parameters.AddWithValue("@name", _FBLoginDetails.Name); cmd1.Parameters.AddWithValue("@fname", _FBLoginDetails.FName); cmd1.Parameters.AddWithValue("@lname", _FBLoginDetails.LName); cmd1.Parameters.AddWithValue("@email", _FBLoginDetails.Email); cmd1.Parameters.AddWithValue("@gender", (_FBLoginDetails.Gender == "female") ? 'F' : 'M'); cmd1.Parameters.AddWithValue("@profile_img_link", _FBLoginDetails.ProfileImageUrl); cmd1.Parameters.AddWithValue("@no_of_friends", _FBLoginDetails.NoOfFriends); cmd1.Parameters.AddWithValue("@no_of_likes", "0"); cmd1.Parameters.AddWithValue("@profile_url", _FBLoginDetails.ProfileUrl); cmd1.Parameters.AddWithValue("@sm_uid", _FBLoginDetails.ID); cmd1.Parameters.AddWithValue("@token", accessToken); conn.ExecuteNonQuery(cmd1); }
public void checkIfUserSharedAPost(string accessToken, List<fbuser> user, string post_id, Int32 brand_id, Int64 campaign_id, Int64 action_id, decimal reward_amount, decimal reward_amount_max, decimal reward_percent, decimal reward_percent_max, string reward_product, decimal reward_point, Int32 no_of_friends, Int32 no_of_likes, Int32 no_of_shares, decimal reward_per_user, decimal reward_on_friend, decimal reward_on_likes, decimal reward_on_shares) { string str = ""; string url = "https://api.twitter.com/1.1/statuses/retweets/" + post_id + ".json?q=" + str; string posts = Search(url, str); fbuser t = user[0]; try { JArray jsonDat = JArray.Parse(posts); for (int x = 0; x < jsonDat.Count; x++) { // check if the post link contains the post id if (t.sm_uid == Convert.ToString(jsonDat[x]["user"]["id"])) { #region save to sp1_IChooseIT_User_Activities_Insert ConnObj = new ConnectionClass(); SqlCommand cmd = new SqlCommand("sp1_IChooseIT_User_Activities_Insert"); cmd.Parameters.AddWithValue("@reg_uid", t.reg_uid); cmd.Parameters.AddWithValue("@brand_id", brand_id); cmd.Parameters.AddWithValue("@campaign_id", campaign_id); cmd.Parameters.AddWithValue("@action_id", action_id); cmd.Parameters.AddWithValue("@created_on", ""); cmd.Parameters.AddWithValue("@pid", ""); decimal points = 0; no_of_friends = 0; no_of_likes = 0; no_of_shares = 0; // reward table details if (reward_per_user > 0) { points += reward_per_user; } if (reward_on_friend > 0) { // get number of friends for the user no_of_friends = t.no_of_friends; points += (no_of_friends * reward_on_friend); } if (reward_point > 0) { reward_amount = (reward_amount / reward_point) * points; reward_percent = (reward_percent / reward_point) * points; reward_amount = (reward_amount > reward_amount_max) ? reward_amount_max : reward_amount; reward_percent = (reward_percent > reward_percent_max) ? reward_percent_max : reward_percent; } cmd.Parameters.AddWithValue("@reward_amount", reward_amount); cmd.Parameters.AddWithValue("@reward_percent", reward_percent); cmd.Parameters.AddWithValue("@reward_product", reward_product); cmd.Parameters.AddWithValue("@no_of_friends", no_of_friends); cmd.Parameters.AddWithValue("@no_of_likes", no_of_likes); cmd.Parameters.AddWithValue("@no_of_shares", no_of_shares); cmd.Parameters.AddWithValue("@reward_per_user", reward_per_user); cmd.Parameters.AddWithValue("@reward_on_friend", reward_on_friend); cmd.Parameters.AddWithValue("@reward_on_likes", reward_on_likes); cmd.Parameters.AddWithValue("@reward_on_shares", reward_on_shares); cmd.Parameters.AddWithValue("@returnid", SqlDbType.BigInt).Direction = ParameterDirection.Output; ConnObj.GetDataTab(cmd); #endregion } } } catch (Exception ex) { } }
private void mainForm_Load(object sender, System.EventArgs e) { // First make use of an ADO Connection type. ConnectionClass cn = new ConnectionClass(); cn.Open("Provider=SQLOLEDB.1;data source=.;initial catalog=pubs;", "sa", "", -1); // Now make use of an ADO Recordset. RecordsetClass rs = new RecordsetClass(); rs.Open("Authors", cn, CursorTypeEnum.adOpenKeyset, LockTypeEnum.adLockOptimistic, -1); // Using the recordset, construct a DataTable // which will be bound to the DataGrid widget. DataTable theTable = new DataTable(); // Fill in column names. for(int i = 0; i < rs.Fields.Count; i++) theTable.Columns.Add(new DataColumn(rs.Fields[i].Name, typeof(string))); // Fill in rows. while(!rs.EOF) { DataRow currRow; currRow = theTable.NewRow(); for(int i = 0; i < rs.Fields.Count; i++) currRow[i] = rs.Fields[i].Value.ToString(); theTable.Rows.Add(currRow); rs.MoveNext(); } // Now bind to the DataGrid. theDataGrid.DataSource = theTable; // Close up ADO. rs.Close(); cn.Close(); }