private void InsertKeyword() { try { string userid = Session["MarketingUser"].ToString(); string sql = "select IMEINO,Sim_no from LongCodeRegistration where UsrUserid='" + userid + "'"; DataSet ds = cc.ExecuteDataset(sql); keywordBLLObj.IMEINO = Convert.ToString(ds.Tables[0].Rows[0]["IMEINO"]); keywordBLLObj.Simno = Convert.ToString(ds.Tables[0].Rows[0]["Sim_no"]); string date = DateTime.Today.ToShortDateString(); date = cc.DTInsert_Local(date); keywordBLLObj.keywordCreationDate = date; keywordBLLObj.keywordName = Convert.ToString(txtKeywordName.Text.ToUpperInvariant()); keywordBLLObj.keywordDescription = Convert.ToString(txtKeywordDescription.Text); keywordBLLObj.responseMsg = Convert.ToString(txtResponseMessage.Text); keywordBLLObj.Email = Convert.ToString(txtEmail.Text); keywordBLLObj.keyEmailSub = Convert.ToString(txtEmailSub.Text.Trim()); keywordBLLObj.Fwdmobileno = Convert.ToString(txtFwdMobileno.Text); keywordBLLObj.Keywordfor = Convert.ToString(ddlkeyword.SelectedItem.Value); string keywordstatus = "Active"; keywordBLLObj.Keywordstatus = keywordstatus; status = keywordBLLObj.BLLMiscalKeywordIsExist(keywordBLLObj); if (status > 0) { status = keywordBLLObj.BLLMiscalKeywordInsert(keywordBLLObj); if (status > 0) { ////////Comment for sumtime becz it is in progress if (ddlkeyword.SelectedItem.Value == "2") { listitem(); sql = "select Id from PersonalLongCodekeywords where keywordName='" + keywordBLLObj.keywordName + "' and IMEINO='" + keywordBLLObj.IMEINO + "' and simno='" + keywordBLLObj.Simno + "'"; string id = cc.ExecuteScalar(sql); sql = "insert into RegistrationKeyword(Pid,RegNo)values('" + id + "','" + choice + "')"; int a = cc.ExecuteNonQuery(sql); } //////////////////////////////////////// LoadKeyword(); clearItems(); Response.Write("<script>alert('Keyword Added successfully')</script>"); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Keyword Added successfully')", true); } } else { Response.Write("<script>alert('Keyword Added successfully')</script>"); ScriptManager.RegisterStartupScript(this, typeof(Page), "msg", "alert('Keyword Name Already Exist ')", true); clearItems(); } } catch (Exception ex) { string msg = ex.Message; } }
private void gvdisplayshow() { // DateTime date = DateTime.Now; //string todaysDate = date.ToShortDateString(); string date = System.DateTime.Now.ToString(); //string todaysDate = date.ToShortDateString(); string todaysDate = cc.DTInsert_Local(date); string UserName = Convert.ToString(Session["MarketingUser"]); sql = "select roleid from AdminSubMarketingSubUser where friendid='" + UserName + "'"; roleid = cc.ExecuteScalar(sql); if (roleid == "2") { sql = "select top 1 p3,p5,p7,send_date from CELevel1 where sender_mobileno='" + UserName + "' and send_date='" + todaysDate + "' "; DataSet ds = cc.ExecuteDataset(sql); gvdisplay.DataSource = ds.Tables[0]; gvdisplay.DataBind(); foreach (GridViewRow row in gvdisplay.Rows) { string Data = row.Cells[3].Text.ToString(); Data = cc.DTGet_Local(Data); row.Cells[3].Text = Data; } } else if (roleid == "3") { sql = "select top 1 p3,p5,p7,send_date from SELevel2 where sender_mobileno='" + UserName + "' and send_date='" + todaysDate + "' "; DataSet ds = cc.ExecuteDataset(sql); gvdisplay.DataSource = ds.Tables[0]; gvdisplay.DataBind(); foreach (GridViewRow row in gvdisplay.Rows) { string Data = row.Cells[3].Text.ToString(); Data = cc.DTGet_Local(Data); row.Cells[3].Text = Data; } } else if (roleid == "4") { sql = "select top 1 p3,p5,p7,send_date from EELevel3 where sender_mobileno='" + UserName + "' and send_date='" + todaysDate + "' "; DataSet ds = cc.ExecuteDataset(sql); gvdisplay.DataSource = ds.Tables[0]; gvdisplay.DataBind(); foreach (GridViewRow row in gvdisplay.Rows) { string Data = row.Cells[3].Text.ToString(); Data = cc.DTGet_Local(Data); row.Cells[3].Text = Data; } } else if (roleid == "5") { sql = "select top 1 p3,p5,p7,send_date from DataCollection where ref_id='" + UserName + "' and send_date='" + todaysDate + "' "; DataSet ds = cc.ExecuteDataset(sql); gvdisplay.DataSource = ds.Tables[0]; gvdisplay.DataBind(); foreach (GridViewRow row in gvdisplay.Rows) { string Data = row.Cells[3].Text.ToString(); Data = cc.DTGet_Local(Data); row.Cells[3].Text = Data; } } else { } }