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
{
}
}
