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();
}
