public void AddRecord() { try { string Sql = "Select KeyId from KeywordInformation where KeywordName='" + txtKeyword.Text + "' "; string KeyId = Convert.ToString(cc.ExecuteScalar(Sql)); if (KeyId == "" || KeyId == null) { KBLL.KeywordName1 = Convert.ToString(txtKeyword.Text); KBLL.KeywordSyntax1 = Convert.ToString(txtSyntax.Text); KBLL.KeywordPurpose1 = Convert.ToString(txtPurpose.Text); KBLL.KeyDiscip1 = Convert.ToString(txtDiscrip.Text); KBLL.WebsiteGroup1 = Convert.ToString(ddlWebSite.SelectedValue); KBLL.EntryDate1 = Convert.ToString(DateFormat); int status = KBLL.AddInfo(KBLL); if (status == 1) { LoadData(); Clear(); Response.Write("<script>alert('Record Inserted.............!')</script>"); } else { } } } catch (Exception ex) { } }
public void AddRecord() { string str = "select GID from [Come2myCityDB].[dbo].[tbl_BCreateGat] where GatName='" + ddlGID.SelectedItem.ToString() + "'"; string sql = cc.ExecuteScalar(str); objBMemRegBLL.GID1 = Convert.ToString(sql); objBMemRegBLL.FName1 = Convert.ToString(txtFName.Text); objBMemRegBLL.LName1 = Convert.ToString(txtLName.Text); objBMemRegBLL.MobileNo1 = Convert.ToString(txtMobileNo.Text); objBMemRegBLL.Post1 = Convert.ToString(ddlPost.Text); objBMemRegBLL.DOJ1 = Convert.ToString(txtdate.Text); objBMemRegBLL.Subscription1 = Convert.ToString(txtSub.Text); objBMemRegBLL.Deposite1 = Convert.ToString(txtDeposit.Text); objBMemRegBLL.Loan1 = Convert.ToString(txtLoan.Text); objBMemRegBLL.UserId1 = Convert.ToString(Session["User"]); int Status = objBMemRegBLL.AddRecordBLL(objBMemRegBLL); if (Status == 1) { LoadGrid(); clear(); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Event Added Successfully')", true); } }
public void insertrecord() { usrBLL.usrMobileNo = txtmobileno.Text; string sqlfetch = "select usrUserid from usermaster where usrMobileNo='" + usrBLL.usrMobileNo + "'"; string userid = cc.ExecuteScalar(sqlfetch); status = usrBLL.BLLIsExistUserRegistrationInitial(usrBLL); if (status == 0) { string sqlcheck = "select id from SMSstatus where Userid='" + userid + "' "; string id = cc.ExecuteScalar(sqlcheck); if (id == null || id == "") { DateTime datetime = DateTime.Now; string smsstatus = "Deactive"; string sql = "insert into SMSstatus(Userid,SMS_status,sms_date)values('" + userid + "','" + smsstatus + "','" + datetime + "')"; string insertvalue = cc.ExecuteScalar(sql); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('SMS menu is deactivated successfully')", true); } //else //{ // ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('SMS menu is already deactivated to your account ')", true); //} } else { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('This number is not registered to www.myct.in')", true); } gridshow(); }
public int BLLTestUserFriendRelative(CommonSqlQueryCode ur) { SqlConnection con1 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); int flag = 0; try { string sql = "select FriRelId from friendRelationmaster where Userid='" + ur.frnrelUserId + "'and FriendId='" + ur.frnrelFriendId + "'"; string newflag = ccr.ExecuteScalar(sql); if (newflag.ToString() != "") { flag = Convert.ToInt32(ccr.ExecuteScalar(sql)); } if (flag > 0) { flag = 1; } else { flag = 0; } } catch (Exception ex) { throw ex; } finally { con1.Close(); } return(flag); }
private void downloadfile(string id) { string sql = "select FileName from committeedetail where Committee_url='" + strMyUrl + "'"; string filename = cc.ExecuteScalar(sql); DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/downloadfileSMT/" + filename + "")); fileDownload("'" + filename + "'", di.ToString(), id); }
public void CountTotal() { try { string Sql = "SELECT count([SendFrom]) FROM [Come2MyCityDB].[come2mycity].[sendSMSstatus] where CONVERT(NVARCHAR(25), sendDateTime, 126) like '" + DateFormat + "%' "; lblTotal.Text = Convert.ToString(cc.ExecuteScalar(Sql)); } catch (Exception ex) { } }
protected void Button3_Click(object sender, EventArgs e) { string cls = Convert.ToString(txtClassAdd.Text); if (cls.ToString() != "") { string sqlFind = "select ClassId from ClassMaster where ClassName='" + cls.ToString() + "'"; string find = ""; find = Convert.ToString(cc.ExecuteScalar(sqlFind)); if (find.ToString() == "") { string addStr = "insert into ClassMaster (ClassName) values('" + cls.ToString() + "')"; int jjj = cc.ExecuteNonQuery(addStr); if (jjj > 0) { txtClassAdd.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Class added.')", true); } } else { txtClassAdd.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Class Already Added.')", true); } } else { txtClassAdd.Text = ""; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Enter Class Name.')", true); } FillClassList(); //CheckBox1.Checked = false; txtClassAdd.Text = ""; }
private void PopulateRootLevelM() { string sql1 = ""; UserName = Convert.ToString(Session["MarketingUser"]); SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); if (UserName == "Admin") { sql1 = "select usrMobileNo as FullName,usrFirstName+''+usrLastName as name,id,userid,(select count(*) FROM TreeDemo WHERE parentID=sc.id) childnodecount FROM TreeDemo sc inner join usermaster" + " on usrUserId =userid where parentID=0"; SqlCommand cmd = new SqlCommand(sql1, cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); PopulateNodesM(dt, TreeView1.Nodes); } else { string query = "select roleid from AdminSubMarketingSubUser where friendid='" + UserName + "'"; string roleid = cc.ExecuteScalar(query); if (roleid == "2") { sql1 = "select friendid from AdminSubMarketingSubUser where userid='" + UserName + "'"; DataSet ds = cc.ExecuteDataset(sql1); foreach (DataRow dr in ds.Tables[0].Rows) { string userid = Convert.ToString(dr["friendid"]); sql1 = "select usrMobileNo as FullName,usrFirstName+''+usrLastName as name,id,userid,(select count(*) FROM TreeDemo WHERE parentID=sc.id) childnodecount FROM TreeDemo sc inner join usermaster on usrUserId =userid where userid='" + userid + "' and parentID=0"; SqlCommand cmd = new SqlCommand(sql1, cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); PopulateNodesM(dt, TreeView1.Nodes); } } else { string query1 = "select id from Treedemo where userid='" + UserName + "'"; string parentid = cc.ExecuteScalar(query1); sql1 = "select friendid from AdminSubMarketingSubUser where userid='" + UserName + "'"; DataSet ds = cc.ExecuteDataset(sql1); foreach (DataRow dr in ds.Tables[0].Rows) { string userid = Convert.ToString(dr["friendid"]); sql1 = "select usrMobileNo as FullName,usrFirstName+''+usrLastName as name,id,userid,(select count(*) FROM TreeDemo WHERE parentID=sc.id) childnodecount FROM TreeDemo sc inner join usermaster on usrUserId =userid where userid='" + userid + "' and parentID='" + parentid + "'"; SqlCommand cmd = new SqlCommand(sql1, cn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); PopulateNodesM(dt, TreeView1.Nodes); } } } }
protected void Page_Load(object sender, EventArgs e) { //Response.ContentType = "image/jpg"; string strMyUrl = System.Web.HttpContext.Current.Request.Url.ToString(); //string strMyUrl = "http://www.myct.in/NCP/down.aspx?207935f2fd"; string fetchsql = "select usr_url from frienddownloadlink where frnd_url='" + strMyUrl + "'"; string a = cc.ExecuteScalar(fetchsql); string fetchsql2 = "select folderuserid,actual_filename from uploaddetails where url='" + a + "' "; DataSet ds = cc.ExecuteDataset(fetchsql2); string foldername = Convert.ToString(ds.Tables[0].Rows[0]["folderuserid"]); string actualfname = Convert.ToString(ds.Tables[0].Rows[0]["actual_filename"]); string[] newurl = strMyUrl.Split('?'); string firsturl = newurl[0]; string userResource = "User_Resource/"; firsturl = firsturl + userResource + newurl[1]; DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/User_Resource/" + foldername + ("/"))); string s6 = Server.MapPath(""); int i = 0; foreach (FileInfo fi in di.GetFiles()) { //if (System.IO.Path.GetExtension(di.Name).ToLower() != ".mp3" && System.IO.Path.GetExtension(di.Name).ToLower() != ".flv" && System.IO.Path.GetExtension(di.Name).ToLower() != ".avi" && System.IO.Path.GetExtension(di.Name).ToLower() != ".xlsx" && System.IO.Path.GetExtension(di.Name).ToLower() != ".pdf" && System.IO.Path.GetExtension(di.Name).ToLower() != ".jpg" && System.IO.Path.GetExtension(di.Name).ToLower() != ".png" && System.IO.Path.GetExtension(di.Name).ToLower() != ".gif" && System.IO.Path.GetExtension(di.Name).ToLower() != ".jpeg") if (System.IO.Path.GetExtension(di.Name).ToLower() != ".wav" && System.IO.Path.GetExtension(di.Name).ToLower() != ".mp4" && System.IO.Path.GetExtension(di.Name).ToLower() != ".txt" && System.IO.Path.GetExtension(di.Name).ToLower() != ".doc" && System.IO.Path.GetExtension(di.Name).ToLower() != ".xlsx" && System.IO.Path.GetExtension(di.Name).ToLower() != ".mp3" && System.IO.Path.GetExtension(di.Name).ToLower() != ".flv" && System.IO.Path.GetExtension(di.Name).ToLower() != ".avi" && System.IO.Path.GetExtension(di.Name).ToLower() != ".xls" && System.IO.Path.GetExtension(di.Name).ToLower() != ".pdf" && System.IO.Path.GetExtension(di.Name).ToLower() != ".jpg" && System.IO.Path.GetExtension(di.Name).ToLower() != ".png" && System.IO.Path.GetExtension(di.Name).ToLower() != ".gif" && System.IO.Path.GetExtension(di.Name).ToLower() != ".jpeg" && System.IO.Path.GetExtension(di.Name).ToLower() != ".csv") { string Sql = "insert into DownloadFile_Details(FileLink)values('" + di.FullName + "')"; ds = cc.ExecuteDataset(Sql); if (fi.Name == actualfname) { string sqlshow = "select flag from frienddownloadlink where frnd_url='" + strMyUrl + "'"; string check = cc.ExecuteScalar(sqlshow); if (check == "Active") { fileDownload(fi.Name, di.FullName + fi.Name); string updatequery = "update frienddownloadlink set flag='Deactive' where frnd_url='" + strMyUrl + "'"; int deac = cc.ExecuteNonQuery(updatequery); } else { Label1.Visible = true; Label1.Text = "You have already downloaded this file !!"; //Response.Write("You have already downloaded this file"); } } //fileDownload(fi.Name, Server.MapPath("~/User_Resource/02db0deb-c7b9-4843-ae4e-5d59834af43b/" + fi.Name)); } } }
public int DALExistcompanyno(BLLCompanyDetails obj) { using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { try { string sql = "select companyid from companydetails where contactno='" + obj.Contactno + "' "; string id = cc.ExecuteScalar(sql); if (id == "") { status = 1; } else { status = 0; } } catch (SqlException ex) { throw ex; } finally { con.Close(); } } return(status); }
public void GetAbstract() { try { string Sql = "select UDISE_StudentPresenty.SchoolCode,EntryDate, SUM(RegBoys) as RegBoys,SUM(RegGirls)as RegGirls,SUM(Present_B)as Present_B,SUM(Present_G)as Present_G " + "from UDISE_StudentPresenty where UDISE_StudentPresenty.EntryDate='" + DateFormat + "' " + "GROUP BY EntryDate,SchoolCode"; ds = cc.ExecuteDataset(Sql); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { SchoolCode = Convert.ToString(ds.Tables[0].Rows[i]["SchoolCode"]); EntryDate = Convert.ToString(ds.Tables[0].Rows[i]["EntryDate"]); RegBoys = Convert.ToString(ds.Tables[0].Rows[i]["RegBoys"]); RegGirls = Convert.ToString(ds.Tables[0].Rows[i]["RegGirls"]); Present_B = Convert.ToString(ds.Tables[0].Rows[i]["Present_B"]); Present_G = Convert.ToString(ds.Tables[0].Rows[i]["Present_G"]); string AspPreSql = "Select EntryDate from UDISE_AbstractSchoolPresenty where SchoolCode='" + SchoolCode + "' and EntryDate='" + DateFormat + "'"; string ChkEntry = Convert.ToString(cc.ExecuteScalar(AspPreSql)); if (ChkEntry == "" || ChkEntry == null) { string AddStudPre = "Insert into UDISE_AbstractSchoolPresenty (SchoolCode,EntryDate,RegBoys,RegGirls,Present_B,Present_G)" + " values('" + SchoolCode + "','" + DateFormat + "','" + RegBoys + "','" + RegGirls + "','" + Present_B + "','" + Present_G + "')"; int a = cc.ExecuteNonQuery(AddStudPre); if (a == 1) { } } else { string ChkEntryPre = "Select Sum(RegBoys)as RegBoys,Sum(RegGirls)as RegGirls,Sum(Present_B)as Present_B,Sum(Present_G)as Present_G from UDISE_StudentPresenty where SchoolCode='" + SchoolCode + "' and EntryDate ='" + DateFormat + "'"; DataSet ds1 = cc.ExecuteDataset(ChkEntryPre); if (ds1.Tables[0].Rows.Count > 0) { string RegBoys1 = Convert.ToString(ds1.Tables[0].Rows[0]["RegBoys"]); string RegGirls1 = Convert.ToString(ds1.Tables[0].Rows[0]["RegGirls"]); string Present_B1 = Convert.ToString(ds1.Tables[0].Rows[0]["Present_B"]); string Present_G1 = Convert.ToString(ds1.Tables[0].Rows[0]["Present_G"]); string UpdateTotal = "Update UDISE_AbstractSchoolPresenty set RegBoys=" + RegBoys1 + " , RegGirls=" + RegGirls1 + ", Present_B=" + Present_B1 + ",Present_G=" + Present_G1 + "" + " where SchoolCode='" + SchoolCode + "' and EntryDate ='" + DateFormat + "'"; int b = cc.ExecuteNonQuery(UpdateTotal); if (b == 1) { } } } } ZeroAttendence(); } catch (Exception ex) { } }
private string Profile(string Bstring, string MobileNo) { string[] stringArray = Bstring.Split(new char[] { '#', '*' }); string nonInsertedValues = string.Empty; string nonInsertedValues1 = string.Empty; int result; string uid = System.Guid.NewGuid().ToString(); string st = "select usrUserId from UserMaster where usrMobileNo='" + MobileNo + "'"; uid = cc.ExecuteScalar(st); if (uid == "" || uid == null) { for (int i = 1; i < stringArray.Length; i += 13) { SqlCommand cmd = new SqlCommand(); cmd.Connection = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]); cmd.Parameters.Add(new SqlParameter("@usrFirstName", stringArray[i].ToString())); cmd.Parameters.Add(new SqlParameter("@usrLastName", stringArray[i + 1].ToString())); cmd.Parameters.Add(new SqlParameter("@usrMobileNo", stringArray[i + 2].ToString())); cmd.Parameters.Add(new SqlParameter("@usrEmailId", stringArray[i + 3].ToString())); cmd.Parameters.Add(new SqlParameter("@usrAddress", stringArray[i + 4].ToString())); cmd.Parameters.Add(new SqlParameter("@usrState", stringArray[i + 5].ToString())); cmd.Parameters.Add(new SqlParameter("@strDevId", stringArray[i + 6].ToString())); cmd.Parameters.Add(new SqlParameter("@usrDistrict", stringArray[i + 7].ToString())); cmd.Parameters.Add(new SqlParameter("@usrTaluka", stringArray[i + 8].ToString())); cmd.Parameters.Add(new SqlParameter("@usrCity", stringArray[i + 9].ToString())); cmd.Parameters.Add(new SqlParameter("@usrUserId", uid)); cmd.CommandText = "uspMYCTUserMasterInsert"; cmd.CommandType = CommandType.StoredProcedure; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } result = cmd.ExecuteNonQuery(); //string str = "select max(GID) from [Come2myCityDB].[dbo].[tbl_BCreateGat] "; //string str1 = cc.ExecuteScalar(str); //nonInsertedValues1 += str1 + "*"; } } if (string.IsNullOrEmpty(nonInsertedValues)) { string sql = CommonCode.OK.ToString(); return(sql + nonInsertedValues1); } else { return(nonInsertedValues); } }
public void btnGetCoordinates() { Adress adrs = new Adress(); string sql1 = "Select usrAddress from UserMaster where usrUserId='" + Convert.ToString(Session["User"]) + "' "; Address = Convert.ToString(cc.ExecuteScalar(sql1)); adrs.Address = Address; adrs.GeoCode(); lblLattitude.Text = adrs.Latitude; lblLongtitude.Text = adrs.Longitude; AddControl(); }
private string PWPlayer(string PWPString, string UserMobileNo) { int result; string[] StringArray = PWPString.Split(new char[] { '#', '*' }); string nonInsertedValues = string.Empty; string nonInsertedValues1 = string.Empty; for (int i = 1; i < StringArray.Length; i += 13) { SqlCommand cmd = new SqlCommand(); SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]); cmd.Connection = con; if (StringArray[i].ToString() == "0") { cmd.Parameters.Add(new SqlParameter("@MobileNo", StringArray[i + 1].ToString())); cmd.Parameters.Add(new SqlParameter("@FName", StringArray[i + 2].ToString())); cmd.Parameters.Add(new SqlParameter("@LName", StringArray[i + 3].ToString())); cmd.Parameters.Add(new SqlParameter("@Remark", StringArray[i + 4].ToString())); cmd.Parameters.Add(new SqlParameter("@Position", StringArray[i + 5].ToString())); cmd.Parameters.Add(new SqlParameter("@Experience", StringArray[i + 6].ToString())); cmd.Parameters.Add(new SqlParameter("@TeamRep", StringArray[i + 7].ToString())); cmd.Parameters.Add(new SqlParameter("@Summary", StringArray[i + 8].ToString())); cmd.Parameters.Add(new SqlParameter("@Duration", StringArray[i + 9].ToString())); cmd.Parameters.Add(new SqlParameter("@LinkPages", StringArray[i + 10].ToString())); cmd.Parameters.Add(new SqlParameter("@LoginMobileNo", UserMobileNo)); cmd.Parameters.Add(new SqlParameter("@EntryDate", StringArray[i + 11].ToString())); } cmd.CommandText = "[come2mycity].[uspPWPInsertPlayer]"; cmd.CommandType = CommandType.StoredProcedure; if (cmd.Connection.State == ConnectionState.Closed) { cmd.Connection.Open(); } result = cmd.ExecuteNonQuery(); string str = "select max(PID) from [Come2myCityDB].[come2mycity].[PWP_tblPlayerInfo]"; string str1 = cc.ExecuteScalar(str); nonInsertedValues1 += str1 + "*"; } if (string.IsNullOrEmpty(nonInsertedValues)) { string s = CommonCode.OK.ToString() + "*"; return(s + nonInsertedValues1); } else { return(nonInsertedValues); } }
private void InsertLongCodeRegistration() { try { if (rblText.SelectedItem.Text == "") { lblmisscalltype.Visible = true; Response.Write("<script>alert('Please Select Miss Call Type..!')</script>"); } else { bllobjdatacollection.No_usefor = rdbUserfor.SelectedItem.Value; bllobjdatacollection.Customername = txtCustomerName.Text; bllobjdatacollection.Address = txtCustomeraddress.Text; bllobjdatacollection.Customer_contact = txtmobileno.Text; bllobjdatacollection.SIMno = txtsimno.Text; bllobjdatacollection.Mobileno = txtContactNo.Text; string sql = "select usrUserid from usermaster where usrMobileNo='" + txtContactNo.Text + "'"; string userid = cc.ExecuteScalar(sql); bllobjdatacollection.IMEIMO = txtIMINo.Text; bllobjdatacollection.Send_data = ddlsenddata.SelectedValue; bllobjdatacollection.Regdate = DateTime.Now.ToString(); bllobjdatacollection.MissCallType1 = Convert.ToString(rblText.SelectedItem.Text); //bllobjdatacollection.ResponseMsg = txtMessage.Text; bllobjdatacollection.Customer_contact1 = txtContactNo2.Text; bllobjdatacollection.Customer_contact2 = txtContactNo3.Text; bllobjdatacollection.Customer_contact3 = txtContactNo4.Text; bllobjdatacollection.Customer_contact4 = txtContactNo5.Text; status = bllobjdatacollection.BLLInsertLongCodeRegistration(bllobjdatacollection); if (status == 1) { string sql1 = "update [Come2myCityDB].[come2mycity].LongCodeRegistration set UsrUserid='" + userid + "' where IMEINO='" + txtIMINo.Text + "' and Sim_no='" + txtsimno.Text + "' and mobileno='" + txtContactNo.Text + "'"; string a = cc.ExecuteScalar(sql1); Longcodegridshow(); Response.Write("<script>alert('Record Inserted Successfully')</script>"); } else { Longcodegridshow(); Response.Write("<script>alert('Record Not Inserted ')</script>"); } clearAll(); } } catch (Exception ex) { throw ex; } }
public void Addrecord() { string str, result; if (txtCType.Text != "") { str = txtCType.Text; string sql = "select (ID) from [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='" + str + "' "; result = cc.ExecuteScalar(sql); } else { str = DDLCType.SelectedItem.Text; string sql = "select (ID) from [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='" + str + "' "; result = cc.ExecuteScalar(sql); } string str1, result1; if (txtCFDept.Text != "") { str1 = txtCFDept.Text; string sql1 = "select max(ID) from [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='" + str1 + "' "; result1 = cc.ExecuteScalar(sql1); } else { str1 = DDLCFDept.SelectedItem.Text; string sql1 = "select max(ID) from [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='" + str1 + "' "; result1 = cc.ExecuteScalar(sql1); } objECBLL.UserId1 = Convert.ToString(Session["User"]); objECBLL.CompType1 = Convert.ToString(result); objECBLL.Date1 = Convert.ToString(txtdate.Text); objECBLL.CompFDept1 = Convert.ToString(result1); objECBLL.CompName1 = Convert.ToString(txtCName.Text); objECBLL.CompSub1 = Convert.ToString(txtCSub.Text); objECBLL.CompDetails1 = Convert.ToString(txtCDetails.Text); objECBLL.Address1 = Convert.ToString(txtAddress.Text); objECBLL.MobileNo1 = Convert.ToString(txtMoblieNo.Text); int Status = objECBLL.AddrecordBLL(objECBLL); if (Status == 1) { Loadgrid(); ////clear(); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Event Added Successfully')", true); } }
private void count() { try { string mono = Convert.ToString(Session["Mobile"]); string s = "select count(*) from MartketingSubuser where MUMono='" + mono + "' and Active='1'"; string a = cc.ExecuteScalar(s); lblActiveCount.Text = "" + a.ToString(); } catch (Exception ex) { string m = ex.Message; } }
private void downloadfile() { // Download http://www.myct.in/NCP/down.aspx?crtevnt http://www.myct.in/NCP/down.aspx?ict http://www.myct.in/NCP/down.aspx?w7o10 & ur login pswd fr myct.in= xxxxx // if (strMyUrl == "http://localhost:50174/myctin/NCP.aspx?Win7&MS10") if (strMyUrl == "http://www.myct.in/NCP.aspx?crtevnt" || strMyUrl == "http://www.myct.in/ncp.aspx?crtevnt" || strMyUrl == "http://www.myct.in/NCP.aspx/crtevnt" || strMyUrl == "http://www.myct.in/ncp.aspx/crtevnt") { DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/current event.pdf")); fileDownload("current event.pdf", di.ToString()); } // if (strMyUrl == "http://localhost:50174/myctin/NCP.aspx?Eevent") else if (strMyUrl == "http://www.myct.in/NCP.aspx?ict" || strMyUrl == "http://www.myct.in/NCP.aspx/ict" || strMyUrl == "http://www.myct.in/ncp.aspx?ict" || strMyUrl == "http://www.myct.in/ncp.aspx/ict") { DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/ICT.pdf")); fileDownload("ICT.pdf", di.ToString()); } // if (strMyUrl == "http://localhost:50174/myctin/NCP.aspx?ebook") else if (strMyUrl == "http://www.myct.in/NCP.aspx?w7o10" || strMyUrl == "http://www.myct.in/NCP.aspx/w7o10" || strMyUrl == "http://www.myct.in/ncp.aspx?w7o10" || strMyUrl == "http://www.myct.in/ncp.aspx/w7o10") { DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/Test3.pdf")); fileDownload("Test3.pdf", di.ToString()); } // else if (strMyUrl == "http://localhost:50438/myctin/ncp.aspx/pressnote") else if (strMyUrl == "http://www.myct.in/ncp.aspx/pressnote") { string sql = "select filename from committeedetail where Id=33"; string filename = cc.ExecuteScalar(sql); DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/" + filename)); fileDownload("'" + filename + "'", di.ToString()); } else if (strMyUrl == "http://www.myct.in/ncp.aspx/videorelease") { string sql = "select filename from committeedetail where Id=35"; string filename = cc.ExecuteScalar(sql); DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/" + filename)); fileDownload("'" + filename + "'", di.ToString()); } else if (strMyUrl == "http://www.myct.in/ncp.aspx/ncpmagazine") { string sql = "select filename from committeedetail where Id=34"; string filename = cc.ExecuteScalar(sql); DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/download files/" + filename)); fileDownload("'" + filename + "'", di.ToString()); } }
//protected void gvItem_RowDataBound(object sender, GridViewRowEventArgs e) //{ // DataSet ds = new DataSet(); // //string str = // // " with Event as( " + // // " select *from( " + // // " (SELECT ID,[MID] as m,[PreBalance],[LoanAmt],[DateOfIssue],[MInstalment],[DueDate] FROM [Come2myCityDB].[dbo].[tbl_BIssueLoan] where [UserId]='"+Session["User"]+"') as t" + // // " left join " + // // " [Come2myCityDB].[dbo].[tbl_BMRegistration] as t1 " + // // " on " + // // " t.m=t1.MID " + // // " ) " + // // " ) "; // string str = "SELECT ID,[MID] as m,[PreBalance],[LoanAmt],[DateOfIssue],[MInstalment],[DueDate] FROM [Come2myCityDB].[dbo].[tbl_BIssueLoan] where MID='" + ddlSMember.SelectedValue + "'"; // ds = cc.ExecuteDataset(str); // decimal str1 = Convert.ToInt32(ds.Tables[0].Rows[0]["LoanAmt"]); // decimal str2 = Convert.ToInt32(ds.Tables[0].Rows[0]["DueDate"]); // string sql = "select IntOnLoan FROM [Come2myCityDB].[dbo].[tbl_BSSGRuleSetting]"; // ds = cc.ExecuteDataset(sql); // decimal sql1 = Convert.ToInt32(ds.Tables[0].Rows[0]["IntOnLoan"]); // decimal cal = ((str1 * str2 * sql1) / 100); // lblCal.Text = cal.ToString(); // //Label lbl = (Label)e.Row.FindControl("lblCal"); // //lbl.Text = cal.ToString(); // Label lbl = gvItem.Rows[rowIndex].FindControl("lblCal") as Label; // lbl.Text = Convert.ToString(cal); //} public string Sum() { string str = "select Sum(cast(SubAmt as int)) from [Come2myCityDB].[dbo].[tbl_BSubInstalment] where UserId='" + Session["User"] + "' "; string st = cc.ExecuteScalar(str); return(st); }
private void AddNew() { CommonCode cc = new CommonCode(); try { if (txtRoleName.Text == "") { lblError.Visible = true; lblError.Text = "Please Enter the Role Name"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Please Enter the Role Name')", true); } else { string Sql = "Select Roleid from [Come2myCityDB].[come2mycity].submenuPermission where RoleName='" + txtRoleName.Text.ToString() + "'"; string Id = Convert.ToString(cc.ExecuteScalar(Sql)); if (!(Id == null || Id == "")) { lblError.Visible = true; lblError.Text = "This Name is already exist"; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('This Name is already exist')", true); lblError.Text = ""; } else { string sql11 = "select roleid,referencerole from [Come2myCityDB].[come2mycity].submenuPermission where rolename='" + ddlRole.SelectedItem.Text + "' "; DataSet ds = cc.ExecuteDataset(sql11); string refrole = Convert.ToString(ds.Tables[0].Rows[0]["referencerole"]); if (refrole == "") { string roleid = Convert.ToString(ds.Tables[0].Rows[0]["roleid"]); refrole = roleid; } if (ddlRole.SelectedValue == "0") { refrole = ""; } Sql = "Insert into [Come2myCityDB].[come2mycity].submenuPermission(RoleName,RoleDescription,PageAccessPerm,UnderRole,referencerole) Values ('" + txtRoleName.Text.ToString() + "','" + txtRoleName.Text.ToString() + "','','" + ddlRole.SelectedValue + "','" + refrole.ToString() + "') "; int flag = cc.ExecuteNonQuery(Sql); txtRoleName.Text = ""; txtRoleDescription.Text = ""; lblError.Visible = true; getinfo(); lblError.Text = "Role Added Successfully"; lblError.Visible = false; ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Role added successfully')", true); getRole(); getinfo(); } } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Role not added')", true); } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { TextBox txtBackReply = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtReply"); Label lblMobile = (Label)GridView1.Rows[e.RowIndex].FindControl("lblMobileNo"); string sendTo = lblMobile.Text.ToString().Substring(2, 10); string sql = "select usrFirstName from userMaster where usrMobileNo='" + sendTo.ToString() + "'"; string reply = ""; string returnName = ""; returnName = cc.ExecuteScalar(sql); if (returnName != "") { reply = "Dear " + returnName.ToString() + "," + txtBackReply.Text.ToString() + " Thanks.via www.myct.in"; } else { reply = "Dear customer," + txtBackReply.Text.ToString() + " Thanks.via www.myct.in"; } string senderByCT = "myctin"; cc.SendMessageTra(senderByCT, sendTo, reply); GridView1.EditIndex = -1; string KeyName = ddlSubGroupName.SelectedItem.ToString(); loadGrid(KeyName); }
private void gvCommitteesshow() { try { string userid = Session["MarketingUser"].ToString(); if (userid == "6dde8c3d-1895-4904-b332-764f63206fc0") { string sql = "select Id,Committee_name,hiturl from committeedetail "; DataSet ds = cc.ExecuteDataset(sql); gvCommittees.DataSource = ds.Tables[0]; gvCommittees.DataBind(); } else { string sqlfetch = "select commitee_id from CommitteeRole where userid='" + userid + "'"; string commitee = cc.ExecuteScalar(sqlfetch); string sql = "select Committee_name,hiturl from committeedetail where Id in(" + commitee + ")"; DataSet ds = cc.ExecuteDataset(sql); gvCommittees.DataSource = ds.Tables[0]; gvCommittees.DataBind(); } } catch (Exception ex) { } }
//protected void btnUpdateContact_Click(object sender, EventArgs e) //{ // string Id = tmp.Value; // urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]); // urUserRegBLLObj.frnrelFriendId = Convert.ToString(Id); // urUserRegBLLObj.FrnrelPrefix = Convert.ToString(ddlprefix.SelectedItem.Text); // if (ddlprefix.SelectedItem.Text == null) // { // urUserRegBLLObj.FrnrelPrefix = "Dear"; // } // urUserRegBLLObj.Frnrelinfix = Convert.ToString(ddlinfix.SelectedItem.Text); // if (ddlinfix.SelectedItem.Text == null) // { // urUserRegBLLObj.Frnrelinfix = infix[0]; // } // urUserRegBLLObj.Frnrelpostfix = Convert.ToString(ddlpostfix.SelectedItem.Text); // if (ddlpostfix.SelectedItem.Text == null) // { // urUserRegBLLObj.Frnrelpostfix = " "; // } // try // { // status = urUserRegBLLObj.BLLPrefixUpdate(urUserRegBLLObj); // if (status == 0) // { // //ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('User already Exists')", true); // } // } // catch (Exception ex) // { // throw ex; // } // string Sql = "Delete from friendGroupRelation where RelId=" + Id + " "; // Sql = Sql + " Update FriendRelationMaster set Relation='" + txtRelation.Text.ToString() + "' " + // " where FriRelId=" + Id + " "; // //sql1=Sql+"update " // //for (int i = 0; i < chkGroup.Items.Count - 1; i++) // //{ // // if (chkGroup.Items[i].Selected == true) // // { // // Sql = Sql + " Insert into FriendGroupRelation (RelId, GroupId) Values " + // // " (" + Id + "," + chkGroup.Items[i].Value.ToString() + " ) "; // // } // //} // CommonCode cc = new CommonCode(); // int tmp1 = cc.ExecuteNonQuery(Sql); // urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]); // DataSet dtFriendRelList = urUserRegBLLObj.BLLFriendRelativeShowById(urUserRegBLLObj); // gvRemoveFriend.DataSource = dtFriendRelList; // gvRemoveFriend.DataBind(); // urUserRegBLLObj.frnrelUserId = Convert.ToString(Session["User"]); // string query = "select * from FriendRelationMaster where UserId='" + urUserRegBLLObj.frnrelUserId.ToString() + "'"; // DataSet ds = cc.ExecuteDataset(query); // foreach (DataRow dr in ds.Tables[0].Rows) // { // string userid = Convert.ToString(dr["UserId"]); // string frienduserid = Convert.ToString(dr["FriendId"]); // } //} public void LoadFriendGroup(UserRegistrationBLL ur) { //chkGroup DataTable dtFriendGroup = urUserRegBLLObj.BLLShowAllFriendGroup(urUserRegBLLObj); string Sql = " Select GroupName from UserMaster where usrUserId='" + Convert.ToString(Session["User"]) + "' "; string Data = Convert.ToString(cc.ExecuteScalar(Sql)); string[] tmp = Data.Split(','); int i = 0; foreach (DataRow dr in dtFriendGroup.Rows) { string tmpName = Convert.ToString(dr["GroupName"]); string tmpData = ""; try { tmpData = tmp[i].ToString(); } catch { } if (tmpData != "") { dr["GroupName"] = tmpData; } i++; } }
public void count() { string str = string.Empty; // string str = "select sum(EzeeDrugAppId) FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] where [keyword]='" + txtPName.Text + "' group by EzeeDrugAppId" ; // string str = "SELECT COUNT(EzeeDrugAppId) FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] WHERE [keyword]='" + ddlAllProjectName.SelectedValue + "' AND EntryDate LIKE '%" + txtDate.Text.Substring(0,7) + "%'"; if (ddlAllProjectName.SelectedValue != "0" && txtDate.Text != "") { str = "select COUNT(*) " + " FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] EDrug INNER JOIN [Come2myCityDB].[come2mycity].[DistrictMaster] DM ON EDrug.[District] = DM.[DistrictId] " + " where [keyword]='" + ddlAllProjectName.SelectedValue + "' AND EntryDate LIKE '%" + txtDate.Text.Substring(0, 7) + "%'"; } else if (ddlAllProjectName.SelectedValue != "0" && txtDate.Text == "") { str = "select COUNT(*) " + " FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] EDrug INNER JOIN [Come2myCityDB].[come2mycity].[DistrictMaster] DM ON EDrug.[District] = DM.[DistrictId] " + " where [keyword]='" + ddlAllProjectName.SelectedValue + "'"; } else { ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "anything", "alert('Please Select Project Name');", true); } DataSet ds = new DataSet(); string st = cc.ExecuteScalar(str); lblcount.Text = "All Registered Members Are : '" + st + "'"; }
protected void btnSubmit1_Click(object sender, EventArgs e) { bllobjCompanyDetails.Userid = Session["MarketingUser"].ToString(); string sql = "select id from companydetails where userid='" + bllobjCompanyDetails.Userid + "'"; string cid = cc.ExecuteScalar(sql); bllobjCompanyDetails.Id = Convert.ToInt32(cid); bllobjCompanyDetails.AdvertiseFromdate = txtFrom.Text; bllobjCompanyDetails.AdvertiseTodate = txtTo.Text; listitem(); fileupload(); string advstatus = "Active"; bllobjCompanyDetails.Jobstatus = advstatus; status = bllobjCompanyDetails.BLLAdvertiseInsert(bllobjCompanyDetails); if (status == 1) { Response.Write("<script>(alert)('Advertisement is inserted successfully')</script>"); viewadvertisement(); } else { Response.Write("<script>(alert)('Advertisement is not inserted')</script>"); } }
public void LoadPaidBal() { string usrIdSn = Convert.ToString(Session["User"]); string paidBal = "select paidCount from userMaster where usrUserId='" + usrIdSn.ToString() + "'"; string balVal = cc.ExecuteScalar(paidBal); if (balVal != "") { int bal = Convert.ToInt32(balVal); lblPaidBal.Text = Convert.ToString(bal) + " SMS"; } else { lblPaidBal.Text = "0 SMS"; } }
public int DALMiscalKeywordIsExist(KeywordBLL KB) { using (SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"])) { try { string sql = "select keywordId from KeywordDefinition where KeywordName='" + KB.keywordName + "'"; string id = cc.ExecuteScalar(sql); if (id == "" || id == null) { SqlParameter[] par = new SqlParameter[4]; par[0] = new SqlParameter("@KeywordName", KB.keywordName); par[1] = new SqlParameter("@IMEINO", KB.IMEINO); par[2] = new SqlParameter("@Sim_no", KB.Simno); par[3] = new SqlParameter("@status", 5); par[3].Direction = ParameterDirection.Output; SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "MiscalKeywordNameIsExist", par); status = (int)par[3].Value; } else { status = 0; } } catch (Exception ex) { } finally { con.Close(); } } return(status); }
public int DALGetstatus(JobSeekerdetailsBLL obj) { using (SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"])) { try { string sql = "select id from JobSeekerDetails where userid='" + obj.Userid + "'"; string id = cc.ExecuteScalar(sql); if (id == "") { status = 1; } else { status = 0; } } catch (SqlException ex) { throw ex; } finally { con.Close(); } } return(status); }
public void LoadGenaralBal() { string usrIdSn = Convert.ToString(Session["User"]); string paidBal = "select SMSbal from userMaster where usrUserId='" + usrIdSn.ToString() + "'"; string balValue = cc.ExecuteScalar(paidBal); if (balValue != "") { int bal = Convert.ToInt32(balValue); lblQuickGeneralBalance.Text = "SMS Balance is: " + Convert.ToString(bal) + " SMS"; } else { lblQuickGeneralBalance.Text = "SMS Balance is: 0 SMS"; } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { lblId.Text = Convert.ToString(e.CommandArgument); string id = lblId.Text; string command = Convert.ToString(e.CommandName); if (command == "Calculate") { string sql = "select MsgCharCount,msgcount from MiscalResponse where id='" + id + "'"; DataSet ds = cc.ExecuteDataset(sql); string count = Convert.ToString(ds.Tables[0].Rows[0]["MsgCharCount"]); if (count == "" || count == null) { count = "0"; } string msgtotalcount = Convert.ToString(ds.Tables[0].Rows[0]["msgcount"]); if (msgtotalcount == "" || msgtotalcount == null) { msgtotalcount = "0"; } lblMsgttlcount.Text = "Total Message Count: " + msgtotalcount; lblCount.Text = "Message Length: " + count; sql = "select count(*) from MiscalResponseCounter where Message_id='" + id + "'"; string usercount = cc.ExecuteScalar(sql); lblusercount.Text = "No. of user: "******"Total Calculation :" + calulation; } }