public List<NewsBLL> getNewsDDL()
{
DataSet ds = new DataSet();
List<NewsBLL> news = new List<NewsBLL>();
try
{
string sql = "select * from GroupValue where GroupItemId=6";
ds = cc.ExecuteDataset(sql );
string nm = "";
int id = 0;
foreach (DataRow dr in ds.Tables[0].Rows )
{
NewsBLL obj1 = new NewsBLL();
id = Convert.ToInt32(dr["GroupValueId"]);
nm = Convert.ToString(dr["GroupValueName"]);
obj1.NewsPaperId = id;
obj1.NewsPaperName = nm;
news.Add(obj1 );
}
}
catch (Exception tt)
{
throw tt;
}
return news;
}
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)
{
}
}
public string ReturnPassMobile(string Mobileno)
{
string mobileNoPass = "";
//string SQl = " Select mobileNo from EzeeDrugsAppDetail where strDevId='" + IMEINo + "'";
//string Mobileno = Convert.ToString(cc.ExecuteScalar(SQl));
//if (Mobileno == "")
//{ }
//else
//{
string Sql = "Select usrMobileNo,usrPassword,strDevId from UserMaster where usrMobileNo='" + Mobileno + "'";
DataSet ds = cc.ExecuteDataset(Sql);
if (ds.Tables[0].Rows.Count > 0)
{
mobileNoPass = Convert.ToString(ds.Tables[0].Rows[0]["strDevId"]) + " * " + Convert.ToString(ds.Tables[0].Rows[0]["usrMobileNo"]) + " * " + cc.DESDecrypt(Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"]));
}
else
{
}
//}
return(mobileNoPass);
}
public decimal cal()
{
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 = "Simple Intrest=" + cal.ToString();
//Label lbl = gvItem.FindControl("lblCal") as Label;
//lbl.Text = Convert.ToString(cal);
return(cal);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//pnlPhoto.Visible = false;
if (Convert.ToString(Session["MarketingUser"]) == "")
{
Response.Redirect("Login.aspx");
}
else
{
DataSet ds = new DataSet();
string Sql = "Select GroupValueId, GroupValueName from GroupValue where GroupItemId=1 order by GroupValueName ";
Sql = Sql + " Select GroupValueId, GroupValueName from GroupValue where GroupItemId=2 order by GroupValueName ";
Sql = Sql + " Select GroupValueId, GroupValueName from GroupValue where GroupItemId=3 order by GroupValueName ";
Sql = Sql + " Select GroupValueId, GroupValueName from GroupValue where GroupItemId=4 order by GroupValueName ";
Sql = Sql + " Select GroupValueId, GroupValueName from GroupValue where GroupItemId=5 order by GroupValueName ";
Sql = Sql + " SELECT CityMaster.cityId as Id, StateMaster.stateName+' - '+ DistrictMaster.distName+' - '+ CityMaster.cityName as Name " +
" FROM CityMaster INNER JOIN DistrictMaster ON CityMaster.distId = DistrictMaster.distId INNER JOIN " +
" StateMaster ON DistrictMaster.stateId = StateMaster.stateId order by stateName,distName,cityName ";
ds = cc.ExecuteDataset(Sql);
ViewState["Group"] = ds;
LoadAllSocialGroup();
string MId = Convert.ToString(Request.QueryString["Id"]);
if (MId != null && MId != "")
{
LoadAllData(MId);
}
}
}
}
public void LoadData()
{
string str = string.Empty;
// string str = "select [keyword],[strDevId],[firstName],[lastName],[firmName],[mobileNo],[address],[eMailId],[typeOfUse_Id],[EntryDate],[RefMobileNo],[State],[District],[usertype],[Qualification] FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] where [keyword]='" + txtPName.Text.ToUpper() + "' and EntryDate='"+txtDate.Text+"'";
// string str = "SELECT [keyword],[strDevId],[firstName],[lastName],[firmName],[mobileNo],[address],[eMailId],[typeOfUse_Id],[EntryDate],[RefMobileNo],[State],[District],[usertype],[Qualification] FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] WHERE [keyword]='" + ddlAllProjectName.SelectedValue + "' AND EntryDate LIKE '%" + txtDate.Text.Substring(0,7) + "%'";
if (ddlAllProjectName.SelectedValue != "0" && txtDate.Text != "")
{
str = "select [keyword],[strDevId],[firstName],[lastName],[firmName],[mobileNo],[address],[eMailId],[typeOfUse_Id],[EntryDate],[RefMobileNo],DM.[DistrictName],[usertype],[Qualification] " +
" 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 [keyword],[strDevId],[firstName],[lastName],[firmName],[mobileNo],[address],[eMailId],[typeOfUse_Id],[EntryDate],[RefMobileNo],DM.[DistrictName],[usertype],[Qualification] " +
" 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();
ds = cc.ExecuteDataset(str);
gvItem.DataSource = ds.Tables[0];
gvItem.DataBind();
}
public string LoginCheck(String Password, string MobileNo)
{
//if (!string.IsNullOrEmpty(MobileNo))
//{
try
{
string s = string.Empty;
DataSet ds = new DataSet();
string str = "select usrPassword,usrUserId from [Come2myCityDB].[dbo].[UserMaster] where usrMobileNo='" + MobileNo + "' ";
ds = cc.ExecuteDataset(str);
string str1 = cc.DESDecrypt(Convert.ToString(ds.Tables[0].Rows[0]["usrPassword"]));
if (str1 == Password)
{
string sql = "select usertype FROM [Come2myCityDB].[dbo].[EzeeDrugsAppDetail] where UserId='" + Convert.ToString(ds.Tables[0].Rows[0]["usrUserId"]) + "'";
ds = cc.ExecuteDataset(sql);
s = ds.Tables[0].Rows[0]["usertype"].ToString();
}
if (s == "2" && s == "3")
{
return(s);
}
return("4");
}
catch (SqlException ex)
{
return(ex.Message);
}
}
public void viewaddressbook()
{
try
{
string usrIdSn = Convert.ToString(Session["User"]);
if (ddlMyFriendGroup.SelectedValue == "0")
{
if (txtGroupSMSFirst.Text != "" && txtGroupSMSLast.Text != "")
{
string FullName = txtGroupSMSFirst.Text + " " + txtGroupSMSLast.Text;
string newsql = "SELECT usrMobileNo,usrFirstName as usrFullName,usrAddress,usrDistrict,usrCity,usrPIN,usrCompanyName,usrMobileNo FROM FriendRelationMaster inner join UserMaster on " +
" FriendRelationMaster.Friendid=UserMaster.usrUserId where userid='" + Convert.ToString(Session["User"]) + "' and FriRelName like '" + txtGroupSMSFirst.Text + "'";
ds = cc.ExecuteDataset(newsql);
gvAddressBook.DataSource = ds.Tables[0];
gvAddressBook.DataBind();
}
else if (txtGroupSMSFirst.Text != "" && txtGroupSMSLast.Text == "")
{
string FullName = txtGroupSMSFirst.Text + " " + txtGroupSMSLast.Text;
string newsql = "SELECT usrMobileNo,usrFirstName as usrFullName,usrAddress,usrDistrict,usrCity,usrPIN,usrCompanyName ,usrMobileNo FROM FriendRelationMaster inner join UserMaster on " +
" FriendRelationMaster.Friendid=UserMaster.usrUserId where userid='" + Convert.ToString(Session["User"]) + "' and FriRelName like '" + txtGroupSMSFirst.Text + "%'";
ds = cc.ExecuteDataset(newsql);
gvAddressBook.DataSource = ds.Tables[0];
gvAddressBook.DataBind();
}
else if (txtGroupSMSFirst.Text == "" && txtGroupSMSLast.Text != "")
{
string FullName = txtGroupSMSFirst.Text + " " + txtGroupSMSLast.Text;
string newsql = "SELECT usrMobileNo,usrFirstName as usrFullName,usrAddress,usrDistrict,usrCity,usrPIN ,usrCompanyName,usrMobileNo FROM FriendRelationMaster inner join UserMaster on " +
" FriendRelationMaster.Friendid=UserMaster.usrUserId where userid='" + Convert.ToString(Session["User"]) + "' and FriRelName like '" + txtGroupSMSLast.Text + "%'";
ds = cc.ExecuteDataset(newsql);
gvAddressBook.DataSource = ds.Tables[0];
gvAddressBook.DataBind();
}
else
{
Response.Write("<script>alert('Please enter Name or Select Group.....!')</script>");
}
}
else
{
string FNumber = Convert.ToString(ddlMyFriendGroup.SelectedValue);
string newsql = "SELECT usrMobileNo,usrFirstName as usrFullName,usrAddress,usrDistrict,usrCity,usrPIN,usrCompanyName,usrMobileNo FROM FriendRelationMaster inner join UserMaster on " +
" FriendRelationMaster.Friendid=UserMaster.usrUserId where userid='" + Convert.ToString(Session["User"]) + "' and FR" + FNumber + "='" + ddlMyFriendGroup.SelectedValue + "'";
ds = cc.ExecuteDataset(newsql);
gvAddressBook.DataSource = ds.Tables[0];
gvAddressBook.DataBind();
}
}
catch (Exception ec)
{
}
}
public void loadGvLongCodeSMSReceve()
{
string sql = "select top(1000)* from come2mycity.test order by PK desc";
DataSet ds = cc.ExecuteDataset(sql);
gvLongCodeSMS.DataSource = ds.Tables[0];
gvLongCodeSMS.DataBind();
}
private void displayrecords()
{
string mono = Convert.ToString(Session["MobileNumber"]);
string sql = "select SMSbal,JoinGroup from usermaster where usrMobileNo='" + mono + "'";
DataSet ds = cc.ExecuteDataset(sql);
lblgroupname.Text = Convert.ToString(ds.Tables[0].Rows[0]["JoinGroup"]);
lblBalance.Text = Convert.ToString(ds.Tables[0].Rows[0]["SMSbal"]);
}
private void InsertBalanceTransfer()
{
string senderId = "myctin";
try
{
urBLL.Frmmobileno = "9422325020";
urBLL.Customermobileno = Convert.ToString(txtmobileno.Text);
urBLL.Transbal = Convert.ToString(txttransaction.Text);
urBLL.Prombal = Convert.ToString(txtPromotional.Text);
urBLL.Validfrom = Convert.ToString(txtvalidfrom.Text);
urBLL.Validupto = Convert.ToString(txtvalidupto.Text);
status = urBLL.BLLInsertBalanceTransfer(urBLL);
if (status == 1)
{
int Transactional = Convert.ToInt32(urBLL.Transbal);
int Promtional = Convert.ToInt32(urBLL.Prombal);
string mobileto = urBLL.Customermobileno;
string query = "select * from usermaster where usrMobileNo='" + mobileto + "'";
DataSet dss = cc.ExecuteDataset(query);
int SMSBal1 = Convert.ToInt32(dss.Tables[0].Rows[0]["SMSbal"]);
int PaidCount1 = Convert.ToInt32(dss.Tables[0].Rows[0]["paidCount"]);
SMSBal1 = SMSBal1 + Transactional;
PaidCount1 = PaidCount1 + Promtional;
string sql12 = "update usermaster set SMSbal='" + SMSBal1 + "' ,paidCount='" + PaidCount1 + "' where usrMobileNo='" + mobileto + "' ";
int aaa = cc.ExecuteNonQuery(sql12);
string messageto = "Dear user Your Transactional Bal is " + urBLL.Transbal + " & Promotional Bal is " + urBLL.Prombal + " updated successfully in ur a/c Thanks Via www.myct.in ";
cc.SendMessageTra(senderId, mobileto, messageto);
string sendto = "9422325020";
string sql = "select * from usermaster where usrMobileNo='" + sendto + "'";
DataSet ds = cc.ExecuteDataset(sql);
int SMSBal = Convert.ToInt32(ds.Tables[0].Rows[0]["SMSbal"]);
int PaidCount = Convert.ToInt32(ds.Tables[0].Rows[0]["paidCount"]);
SMSBal = SMSBal - Transactional;
PaidCount = PaidCount - Promtional;
string sql1 = "update usermaster set SMSbal='" + SMSBal + "' ,paidCount='" + PaidCount + "' where usrMobileNo='" + sendto + "' ";
int a = cc.ExecuteNonQuery(sql1);
string message = "Dear user Trans Bal= " + urBLL.Transbal + " & Promo Bal=" + urBLL.Prombal + " is transfer to " + urBLL.Customermobileno + "";
string sms = message + " Your Trans Bal is " + SMSBal + " & Promo Bal is" + PaidCount + " Thanks Via www.myct.in";
cc.SendMessageTra(senderId, sendto, sms);
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Balance Transfer successfully')", true);
Response.Write("<script>alert('Balance Transfer successfully')</script>");
gvbalanceshow();
clearall();
}
else
{
//ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Plz fill all information')", true);
Response.Write("<script>alert('Plz fill all information')</script>");
}
}
catch (Exception ex)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
string newSql = "select top(100)[FirstName],[LastName],[MobileNumber],[EmailId],[ProductName],[Amount],[TransactionDate],[TransactionStatus],[ScrachCode] from [Come2myCityDB].[dbo].[PaymentInformation] order by TransactionDate desc ";
ds = cc.ExecuteDataset(newSql);
gvReport.DataSource = ds.Tables[0];
gvReport.DataBind();
ds.Clear();
}
private void gvFriendShow()
{
urUserRegBLLObj.usrUserId = Convert.ToString(Session["User"]);
string sql = "select FriRelId,Relation from FriendRelationMaster where userid='" + urUserRegBLLObj.usrUserId + "'";
DataSet ds = cc.ExecuteDataset(sql);
gvRemoveFriend.DataSource = ds.Tables[0];
gvRemoveFriend.DataBind();
}
public void LoadGrid()
{
string str = "select [ProjectName],[ProjectType] FROM [Come2myCityDB].[come2mycity].[tbl_AbhinavITProjects] where ProjectType='WebSite'";
DataSet ds = new DataSet();
ds = cc.ExecuteDataset(str);
gvItem.DataSource = ds.Tables[0];
gvItem.DataBind();
}
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/SMT/down.aspx?af4";
// 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='" + strMyUrl + "' ";
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));
}
}
}
private void downloadfile()
{
string sql = "select Committee_name,FileName from committeedetail where Committee_url='" + strMyUrl + "'";
DataSet ds = cc.ExecuteDataset(sql);
string committeename = Convert.ToString(ds.Tables[0].Rows[0]["Committee_name"]);
string filename = Convert.ToString(ds.Tables[0].Rows[0]["FileName"]);
DirectoryInfo di = new DirectoryInfo(Server.MapPath("~/downloadfilesMLA/" + committeename + "/" + filename + ""));
fileDownload("'" + filename + "'", di.ToString());
}
private void gvUsershow()
{
string sysdate = DateTime.Now.ToString("MM/dd/yyyy");
string mobileno = Convert.ToString(Session["MobileNo"]);
string sql = "select msgTo,msgDate,sendername,Msg,Flagstatus from ReportData where msgFrom='" + mobileno + "' and msgDate like'" + sysdate + "%' order by Id desc";
DataSet ds = cc.ExecuteDataset(sql);
gvUser.DataSource = ds.Tables[0];
gvUser.DataBind();
}
//------------------------------------------------------Load Data on Page Load------------------------------------------------------------------
#region LoadDataonPageLoad
public void LoadData()
{
try
{//(usrFirstName+space(1)+usrLastName)
string Sql = "Select usrFirstName as FullName,usrMobileNo,ug.GroupId,GroupValueName,city,joindate from UserMaster um " +
"inner join UserGroup ug on um.usrUserId=ug.UserId inner join GroupValue gv on ug.GroupId= gv.GroupValueId " +
"where ug.GroupId=92";
if (txtFromDate.Text != "" && txtTodate.Text != "")
{
Sql = Sql + " and joindate between '" + txtFromDate.Text + "' and '" + txtTodate.Text + "' ";
}
if (txtcity.Text != "")
{
Sql = Sql + " and city='" + txtcity.Text + "' ";
}
Sql = Sql + " order by joindate desc";
DataSet ds = cc.ExecuteDataset(Sql);
if (ds.Tables[0].Rows.Count > 0)
{
gvItem.DataSource = ds.Tables[0];
gvItem.DataBind();
}
txtGroupSMSMsg.Text = " www.myct.in";
txtBjsMgs.Text = " www.myct.in";
txtMgsReplay.Text = " www.myct.in";
}
catch (Exception ex)
{ }
}
public void Bind_Qualification()
{
string sql2 = "select brduniId,brduniName from UserBoardUniversity";
DataSet dset = cc.ExecuteDataset(sql2);
ddlUniversity.DataSource = dset.Tables[0];
ddlUniversity.DataTextField = "brduniName";
ddlUniversity.DataValueField = "brduniId";
ddlUniversity.DataBind();
ddlUniversity.Items.Add("--Select--");
ddlUniversity.SelectedIndex = ddlUniversity.Items.Count - 1;
}
public DataSet GetDS(string MobileNO)
{
string SQl = " Select usrFirstName,usrMiddleName,usrLastName,usrAddress ,image from UserMaster " +
" left join storeimage on storeimage.usrAutoid=UserMaster.usrAutoid " +
"where usrmobileno='" + MobileNO + "'";
DataSet ds = cc.ExecuteDataset(SQl);
// Return the DataSet as an XmlElement.
XmlDataDocument xmldata = new XmlDataDocument(ds);
XmlElement xmlElement = xmldata.DocumentElement;
return(ds);
}
public void bindstate()
{
string sql;
sql = "select stateId, stateName from [Come2myCityDB].[dbo].[StateMaster]";
ds = cc.ExecuteDataset(sql);
ddlstate.DataSource = ds;
ddlstate.DataTextField = "stateName";
ddlstate.DataValueField = "stateId";
ddlstate.DataBind();
ddlstate.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void LoadAllUser()
{
string Sql = "SELECT [usrUserId] as UserId,[usrFirstName] +' '+[usrMiddleName]+' '+[usrLastName] as Name " +
" FROM [UserMaster] where isMarketingPerson='Y' and [usrFirstName] +' '+[usrMiddleName]+' '+[usrLastName] is not null ";
DataSet ds = cc.ExecuteDataset(Sql);
ddlMarketingPerson.DataSource = ds.Tables[0];
ddlMarketingPerson.DataTextField = "Name";
ddlMarketingPerson.DataValueField = "UserId";
ddlMarketingPerson.DataBind();
ddlMarketingPerson.Items.Add("--Select--");
ddlMarketingPerson.SelectedIndex = ddlMarketingPerson.Items.Count - 1;
}
private void BindAgent()
{
try
{
string sql = "select Id,friendid,usrFirstName+' '+usrLastName as usrName from AdminSubMarketingSubUser right outer join usermaster on AdminSubMarketingSubUser.friendid=usermaster.usrUserid where roleid=9 order by id desc ";
DataSet ds = cc.ExecuteDataset(sql);
ddlselectAgent.DataTextField = "usrName";
ddlselectAgent.DataValueField = "friendid";
ddlselectAgent.DataSource = ds.Tables[0];
ddlselectAgent.DataBind();
}
catch (Exception ex)
{ }
}
public void LoadGrid()
{
//objTodayBLL.UserId1 = Convert.ToString(Session["User"]);
//objTodayBLL.MeetingType1 = Convert.ToString(objTodayBLL.MeetingType1);
//DataSet ds = objTodayBLL.LoadgridBLL(objTodayBLL);
//DataSet ds = new DataSet();
//string str = "select ID FROM [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='"+ddltxt.Text+"' ";
//ds = cc.ExecuteDataset(str);
//string st =Convert.ToString(ds.Tables[0].Rows[0]["ID"]);
//string srt = DateTime.Now.Date.ToString("yyyy-MM-dd");
//string str1 = "select * from tbl_EventMeeting where MeetingType='" + st + "' and UserId='" + Convert.ToString(Session["User"]) + "' and FrmDate='" + srt + "'";
//ds = cc.ExecuteDataset(str1);
//if(ds.Tables[0].Rows.Count!=0)
//{
// gvItem.DataSource = ds;
// gvItem.DataBind();
//}
DataSet ds = new DataSet();
string str = "select ID FROM [Come2myCityDB].[dbo].[tbl_Main_ID] where Name='" + ddltxt.Text + "' ";
ds = cc.ExecuteDataset(str);
string srt = DateTime.Now.Date.ToString("yyyy-MM-dd");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string str1 = "select * from tbl_EventMeeting where MeetingType='" + ds.Tables[0].Rows[i]["ID"] + "' and UserId='" + Convert.ToString(Session["User"]) + "' and FrmDate='" + srt + "'";
ds = cc.ExecuteDataset(str1);
if (ds.Tables[0].Rows.Count != 0)
{
gvItem.DataSource = ds;
gvItem.DataBind();
}
}
}
public void bindprjnames()
{
DataSet ds = new DataSet();
string sql = "select [prj_Id],[prj_Name] FROM [Come2myCityDB].[come2mycity].[tblProjectList]";
ds = cc.ExecuteDataset(sql);
ddlNameofProject.DataSource = ds;
ddlNameofProject.DataTextField = "prj_Name";
ddlNameofProject.DataValueField = "prj_Id";
ddlNameofProject.DataBind();
ddlNameofProject.Items.Insert(0, new ListItem("--Select--", "0"));
ddlNameofProject.SelectedIndex = 0;
}
public void LoadData()
{
try
{
string Sql = "SELECT EzeeDrugAppId,keyword,strDevId,strSimSerialNo,firstName,lastName,firmName,mobileNo,address,eMailId,typeOfUse_Id,pincode,EntryDate,RefMobileNo FROM EzeeDrugsAppDetail order by EzeeDrugAppId desc";
DataSet ds = cc.ExecuteDataset(Sql);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
catch (Exception ex)
{ }
}
private void GetRecord()
{
try
{
string sql = "select usrFirstName+''+usrLastName as fullname,p5,p7,p9,p11,p13,send_date from DataCollection1" +
" inner join UserMaster on DataCollection1.sender_mobileno = UserMaster.usrUserId" +
" where main_ref='9c4cf910-25bc-4e87-948d-23a29a3402d0' or ref_id='9c4cf910-25bc-4e87-948d-23a29a3402d0'" +
" and send_date='04/17/2013'";
DataSet ds = cc.ExecuteDataset(sql);
gvdisplay.DataSource = ds.Tables[0];
gvdisplay.DataBind();
}
catch (Exception ex)
{ }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
//Search1(gvFriendContact, ddlQuickGroup, txtFirstName, txtLastName);
string usrIdSn = Convert.ToString(Session["User"]);
string sql = "select usrFirstName+' '+usrLastName as usrFullName,usrMobileNo " +
" from FriendRelationMaster Right Outer JOIN UserMaster " +
"ON UserMaster.usrUserId = FriendRelationMaster.FriendId " +
" where friendrelationmaster.userid='" + usrIdSn + "'" +
" and usrFirstName like '" + txtFirstName.Text + "'+'%' and usrLastName like '" + txtLastName.Text + "'+'%' and usrMobileNo='" + txtMobileNo.Text + "'";
DataSet ds = cc.ExecuteDataset(sql);
gvFriendContact.DataSource = ds;
gvFriendContact.DataBind();
}
public void LoadData()
{
try
{
string Sql4 = "SELECT EzeeDrugAppId,keyword,strSimSerialNo,firstName,lastName,firmName,mobileNo,address FROM EzeeDrugsAppDetail where keyword = 'MHVIDHANAPP' order by EntryDate desc";
DataSet ds = cc.ExecuteDataset(Sql4);
if (ds.Tables[0].Rows.Count > 0)
{
gridview1.DataSource = ds.Tables[0];
gridview1.DataBind();
}
}
catch (Exception ex)
{ }
}
public void loadGvLongCodeSMSReceve()
{
try
{
string sql = "select top(50)* from uvajagar order by id desc";
DataSet ds = cc.ExecuteDataset(sql);
if (ds.Tables[0].Rows.Count > 0)
{
gvLongCodeSMS.DataSource = ds.Tables[0];
gvLongCodeSMS.DataBind();
}
}
catch (Exception ex)
{
}
}
