private void LoadCustomerProfile(String customerrsn)
{
try
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsCCustStatus = new DataSet();
dsCCustStatus = sqlobj.SQLExecuteDataset("proc_GetStaffDetails",
new SqlParameter()
{
ParameterName = "@StaffName", SqlDbType = SqlDbType.VarChar, Value = customerrsn.ToString()
});
if (dsCCustStatus.Tables[0].Rows.Count > 0)
{
lblName.Text = dsCCustStatus.Tables[0].Rows[0]["StaffName"].ToString();
//lblscpstatus.Text = dsCCustStatus.Tables[0].Rows[0]["Status"].ToString();
lblAddr1.Text = dsCCustStatus.Tables[0].Rows[0]["AddrLine1"].ToString();
lblAddr2.Text = dsCCustStatus.Tables[0].Rows[0]["AddrLine2"].ToString();
lblCity.Text = dsCCustStatus.Tables[0].Rows[0]["City"].ToString();
lblState.Text = dsCCustStatus.Tables[0].Rows[0]["State"].ToString();
lblPostCode.Text = dsCCustStatus.Tables[0].Rows[0]["PostCode"].ToString();
lblDesig.Text = dsCCustStatus.Tables[0].Rows[0]["Designation"].ToString();
lblEmail.Text = dsCCustStatus.Tables[0].Rows[0]["StaffEmail"].ToString();
lblPhone.Text = dsCCustStatus.Tables[0].Rows[0]["StaffPhone"].ToString();
rwCustomerProfile.Visible = true;
}
dsCCustStatus.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadProspectDiary(string prospectrsn)
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsProspectDiary = new DataSet();
dsProspectDiary = sqlobj.SQLExecuteDataset("SP_GetProspectDiary", new SqlParameter()
{
ParameterName = "@ProspectRSN", SqlDbType = SqlDbType.NVarChar, Value = prospectrsn.ToString()
});
if (dsProspectDiary.Tables[0].Rows.Count > 0)
{
lbldiaryheadName.Text = dsProspectDiary.Tables[0].Rows[0]["name"].ToString();
string DiaryFrom = "CustomerGrid";
if (DiaryFrom == Session["DiaryFrom"].ToString())
{
lbldiarycount.Visible = true;
lbldiarycount.Text = "Count :" + dsProspectDiary.Tables[1].Rows[0]["count"].ToString();
}
else
{
lbldiarycount.Visible = false;
}
gvDiary.DataSource = dsProspectDiary;
gvDiary.DataBind();
}
else
{
gvDiary.DataSource = null;
gvDiary.DataBind();
rwDiary.Visible = false;
WebMsgBox.Show("Sorry, there are no activity entries present.");
}
}
protected void LoadMoreInfo()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsMoreInfo = sqlobj.SQLExecuteDataset("SP_Loadmoreinfo",
new SqlParameter()
{
ParameterName = "@TaskID", SqlDbType = SqlDbType.BigInt, Value = Session["TaskRSN"].ToString()
});
if (dsMoreInfo.Tables[0].Rows.Count > 0)
{
gvMoreinfo.DataSource = dsMoreInfo;
gvMoreinfo.DataBind();
dvAP.Visible = true;
}
else
{
gvMoreinfo.DataSource = null;
gvMoreinfo.DataBind();
dvAP.Visible = false;
}
dsMoreInfo.Dispose();
}
protected void gvMReference_Sorting(object sender, GridViewSortEventArgs e)
{
try
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsTrackon = new DataSet();
dsTrackon = sqlobj.SQLExecuteDataset("sp_trackonlkup");
if (dsTrackon.Tables[0].Rows.Count != 0)
{
DataTable dtreference = new DataTable();
dtreference = dsTrackon.Tables[0];
dtreference.DefaultView.Sort = e.SortExpression;
gvMReference.DataSource = dtreference;
gvMReference.AllowPaging = true;
gvMReference.DataBind();
}
rwReference.Visible = true;
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
private void CLoadLeadSourceSummary()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsLeadSourceSummary = new DataSet();
DataSet dsLeadSourceSummaryTotal = new DataSet();
DataSet dsLeadSourceSummaryGraph = new DataSet();
dsLeadSourceSummary = sqlobj.SQLExecuteDataset("SP_CLeadSummary");
dsLeadSourceSummaryTotal = sqlobj.SQLExecuteDataset("SP_CLeadSummaryTotal");
dsLeadSourceSummaryGraph = sqlobj.SQLExecuteDataset("sp_Customerleadsummarygraph");
if (dsLeadSourceSummary.Tables[0].Rows.Count != 0)
{
gvCLeadSourceSummary.DataSource = dsLeadSourceSummary;
gvCLeadSourceSummary.DataBind();
gvCLeadSourceSummaryTotal.DataSource = dsLeadSourceSummaryTotal;
gvCLeadSourceSummaryTotal.DataBind();
chartcustomerleadsummary.DataSource = dsLeadSourceSummaryGraph;
chartcustomerleadsummary.DataBind();
HighlightColor(gvCLeadSourceSummary, 2);
}
else
{
gvCLeadSourceSummary.DataSource = null;
gvCLeadSourceSummary.DataBind();
}
dsLeadSourceSummary.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
DataSet dsProcess = new DataSet();
SQLProcs proc = new SQLProcs();
DataSet dsDT = null;
rwDownloadMail.VisibleOnPageLoad = true;
rwDownloadMail.Visible = false;
RadWindow1.Visible = false;
if (!IsPostBack)
{
LoadMsg();
LoadCampaignMsg();
txtPlainPassword.Attributes.Add("onkeydown", "return (event.keyCode!=13);");
}
}
catch (Exception ex)
{
//ShowMsgBox(ex.Message, "Exception");
}
}
private bool IsProspectExisting(string prospectname, string mobile)
{
bool IsExisting;
SQLProcs sqlobj = new SQLProcs();
DataSet dspe = new DataSet();
dspe = sqlobj.SQLExecuteDataset("SP_CheckExistingProspect",
new SqlParameter()
{
ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Value = prospectname
},
new SqlParameter()
{
ParameterName = "@Mobile", SqlDbType = SqlDbType.NVarChar, Value = mobile
});
if (dspe.Tables[0].Rows.Count > 0)
{
IsExisting = true;
}
else
{
IsExisting = false;
}
return(IsExisting);
}
protected void LoadCampaignMsg()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsFetchCampaignMsg = new DataSet();
string strShowCampaign = "";
//dsFetchMsg = sqlobj.SQLExecuteDataset("SP_FetchMsg");
dsFetchCampaignMsg = sqlobj.SQLExecuteDataset("SP_ShowCampaign");
if (dsFetchCampaignMsg.Tables[0].Rows.Count != 0)
{
for (int i = 0; i < dsFetchCampaignMsg.Tables[0].Rows.Count; i++)
{
DateTime cstartdate = Convert.ToDateTime(dsFetchCampaignMsg.Tables[0].Rows[i]["StartDate"].ToString());
DateTime cenddate = Convert.ToDateTime(dsFetchCampaignMsg.Tables[0].Rows[i]["EndDate"].ToString());
if (strShowCampaign == "")
{
strShowCampaign = dsFetchCampaignMsg.Tables[0].Rows[i]["Campaignvalue"].ToString() + " From :" + cstartdate.ToString("dd/MM/yyyy") + " To :" + cenddate.ToString("dd/MM/yyyy");
}
else
{
strShowCampaign = strShowCampaign + " , " + dsFetchCampaignMsg.Tables[0].Rows[i]["Campaignvalue"].ToString() + " From :" + cstartdate.ToString("dd/MM/yyyy") + " To :" + cenddate.ToString("dd/MM/yyyy");
}
}
lblcampaignmsg.Text = strShowCampaign;
}
}
protected void LoadTrackOn()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsTrackon = new DataSet();
dsTrackon = sqlobj.SQLExecuteDataset("sp_trackonlkup");
if (dsTrackon.Tables[0].Rows.Count != 0)
{
gvMReference.DataSource = dsTrackon.Tables[0];
gvMReference.AllowPaging = true;
gvMReference.DataBind();
ViewState["myDatatable"] = dsTrackon.Tables[0];
//gvSearchReference.DataSource = dsTrackon.Tables[0];
// gvSearchReference.DataBind();
}
else
{
ViewState["myDatatable"] = dsTrackon.Tables[0];
gvMReference.DataSource = null;
gvMReference.DataBind();
}
dsTrackon.Dispose();
}
protected void LoadProspectDiary(string prospectrsn, string taskid)
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsProspectDiary = new DataSet();
dsProspectDiary = sqlobj.SQLExecuteDataset("SP_GetTaskIDProspectDiary",
new SqlParameter()
{
ParameterName = "@ProspectRSN", SqlDbType = SqlDbType.NVarChar, Value = prospectrsn.ToString()
},
new SqlParameter()
{
ParameterName = "@TaskID", SqlDbType = SqlDbType.BigInt, Value = taskid.ToString()
}
);
if (dsProspectDiary.Tables[0].Rows.Count > 0)
{
lbldiaryheadName.Text = dsProspectDiary.Tables[0].Rows[0]["name"].ToString();
lbldiarycount.Visible = false;
gvDiary.DataSource = dsProspectDiary;
gvDiary.DataBind();
}
else
{
gvDiary.DataSource = null;
gvDiary.DataBind();
rwDiary.Visible = false;
WebMsgBox.Show("Sorry, there are no activity entries present.");
}
}
protected void ChkLeaveSystem()
{
try
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsMasters = sqlobj.SQLExecuteDataset("SP_chkleavesystem");
if (dsMasters.Tables[0].Rows.Count > 0)
{
string strleavesystem = dsMasters.Tables[0].Rows[0]["isleavesystem"].ToString();
string strAssessPerf = dsMasters.Tables[0].Rows[0]["ISAssessPerf"].ToString();
if (strAssessPerf == "1")
{
btnAssessPerf.Visible = true;
}
else
{
btnAssessPerf.Visible = false;
}
if (strleavesystem == "True")
{
btnApplyLeave.Visible = true;
}
else
{
btnApplyLeave.Visible = false;
}
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void LoadProspectDiary(string prospectrsn)
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsProspectDiary = new DataSet();
dsProspectDiary = sqlobj.SQLExecuteDataset("SP_GetProspectDiary", new SqlParameter()
{
ParameterName = "@ProspectRSN", SqlDbType = SqlDbType.NVarChar, Value = prospectrsn.ToString()
});
if (dsProspectDiary.Tables[0].Rows.Count > 0)
{
lbldiaryheadName.Text = dsProspectDiary.Tables[0].Rows[0]["name"].ToString();
lbldiaryheadStatus.Text = " Status:" + dsProspectDiary.Tables[0].Rows[0]["Status"].ToString();
lbldiaryheadType.Text = " Type:" + dsProspectDiary.Tables[0].Rows[0]["Type"].ToString();
gvDiary.DataSource = dsProspectDiary;
gvDiary.DataBind();
MergeGrid();
}
}
public static string AddSaveTime(string Savetime)
{
string flag = "";
try
{
if (Savetime == "")
{
flag = "false";
return(flag);
}
SQLProcs sqlobj = new SQLProcs();
sqlobj.ExecuteSQLNonQuery("SP_InsertSaveTimeEntry",
new SqlParameter()
{
ParameterName = "@SaveTimeEntry", SqlDbType = SqlDbType.NVarChar, Value = Savetime
},
new SqlParameter()
{
ParameterName = "@Remarks", SqlDbType = SqlDbType.NVarChar, Value = null
}
);
flag = "true";
}
catch (Exception ex)
{
flag = "false";
}
return(flag);
}
protected void LoadCheckDate()
{
SQLProcs proc = new SQLProcs();
DataSet dsDT = null;
dsDT = proc.SQLExecuteDataset("GetServerDateTime");
Session["CheckDemoDate"] = Convert.ToDateTime(dsDT.Tables[0].Rows[0][0].ToString()).ToString("yyyy-MM-dd");
}
protected void LoadServerTime()
{
DataSet dsProcess = new DataSet();
SQLProcs proc = new SQLProcs();
DataSet dsDT = null;
dsDT = proc.SQLExecuteDataset("GetServerDateTime");
//lblDate.Text = Convert.ToDateTime(dsDT.Tables[0].Rows[0][0].ToString()).ToString("dddd") + " , " + Convert.ToDateTime(dsDT.Tables[0].Rows[0][0].ToString()).ToString("dd MMM yyyy | hh : mm tt");
}
protected void btnROLUpdate_Click(object sender, EventArgs e)
{
try
{
string strUserLevel = Session["UserLevel"].ToString();
if (strUserLevel == "1Manager" || strUserLevel == "2CoOrdinator")
{
SQLProcs sqlobj = new SQLProcs();
sqlobj.ExecuteSQLNonQuery("SP_UpdatetblROL",
new SqlParameter()
{
ParameterName = "@StaffID", SqlDbType = SqlDbType.NChar, Value = ddlStaffID.SelectedValue
},
new SqlParameter()
{
ParameterName = "@ROLTYPE", SqlDbType = SqlDbType.NChar, Value = ddlROLTYPE.SelectedValue
},
new SqlParameter()
{
ParameterName = "@ROLMessage", SqlDbType = SqlDbType.NChar, Value = ROLMessage.Text
},
new SqlParameter()
{
ParameterName = "@ModifiedBy", SqlDbType = SqlDbType.NChar, Value = Session["UserID"].ToString()
},
new SqlParameter()
{
ParameterName = "@RSN", SqlDbType = SqlDbType.BigInt, Value = Session["ROLRSN"].ToString()
}
);
ddlROLTYPE.SelectedIndex = 0;
ddlStaffID.SelectedIndex = 0;
ROLMessage.Text = "";
btnROLUpdate.Visible = false;
btnROLSave.Visible = true;
LoadROL();
WebMsgBox.Show("Thank you for your feedback. It shall be conveyed to the concerned via Email.");
dvRadWindow.Visible = true;
rwROL.Visible = true;
}
else
{
WebMsgBox.Show("Access denied");
dvRadWindow.Visible = true;
rwROL.Visible = true;
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
dvRadWindow.Visible = true;
rwROL.Visible = true;
}
}
protected void LoadMsg()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsFetchMsg = new DataSet();
//dsFetchMsg = sqlobj.SQLExecuteDataset("SP_FetchMsg");
dsFetchMsg = sqlobj.SQLExecuteDataset("SP_BCMsg");
if (dsFetchMsg.Tables[0].Rows.Count != 0)
{
lblmsg.Text = dsFetchMsg.Tables[0].Rows[0]["BroadcastMessage"].ToString();
}
}
private void LoadLeadCategorySummary()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsLeadCategorySummary = new DataSet();
DataSet dsLeadCategorySummaryTotal = new DataSet();
DataSet dsLeadCategorySummaryGraph = new DataSet();
dsLeadCategorySummary = sqlobj.SQLExecuteDataset("SP_GetCategoryMain");
// dsLeadCategorySummaryTotal = sqlobj.SQLExecuteDataset("SP_GetCategoryTotal");
dsLeadCategorySummaryGraph = sqlobj.SQLExecuteDataset("SP_CategoryGraph");
if (dsLeadCategorySummary.Tables[0].Rows.Count != 0)
{
gvLeadCategorySummary.DataSource = dsLeadCategorySummary;
gvLeadCategorySummary.DataBind();
gvLeadCategorySummary.ShowFooter = true;
gvLeadCategorySummary.FooterRow.Cells[0].Text = "Total";
gvLeadCategorySummary.FooterRow.Cells[0].HorizontalAlign = HorizontalAlign.Left;
gvLeadCategorySummary.FooterRow.Cells[1].Text = dsLeadCategorySummary.Tables[0].Compute("sum(HotLeads)", "").ToString();
gvLeadCategorySummary.FooterRow.Cells[2].Text = dsLeadCategorySummary.Tables[0].Compute("sum(Customers)", "").ToString();
gvLeadCategorySummary.FooterRow.Cells[3].Text = dsLeadCategorySummary.Tables[0].Compute("sum(Vendors)", "").ToString();
gvLeadCategorySummary.FooterRow.Cells[4].Text = dsLeadCategorySummary.Tables[0].Compute("sum(Others)", "").ToString();
gvLeadCategorySummary.FooterRow.HorizontalAlign = HorizontalAlign.Center;
//gvLeadCategorySummary.FooterRow.Cells[1].Text = dsLeadCategorySummary.Tables[0].Compute("sum(Indians)", "").ToString();
//gvLeadCategorySummary.FooterRow.Cells[2].Text = dsLeadCategorySummary.Tables[0].Compute("sum(Others)", "").ToString();
//string[] colNames={"Indians","Others"};
//DataView dvleadcategory = new DataView(dsLeadCategorySummary.Tables[0]);
//DataTable dtLeadSummaryGraph = dvleadcategory.ToTable(true, colNames);
//Comment by Prakash.M
//gvCategorySummaryTotal.DataSource = dsLeadCategorySummaryTotal;
//gvCategorySummaryTotal.DataBind();
chartleadcategorysummary.DataSource = dsLeadCategorySummaryGraph;
chartleadcategorysummary.DataBind();
// HighlightColor(gvLeadStatusSummary, 1);
}
else
{
gvLeadCategorySummary.DataSource = null;
gvLeadCategorySummary.DataBind();
}
dsLeadCategorySummary.Dispose();
}
protected void LoadTotalROL()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsTotalROL = new DataSet();
dsTotalROL = sqlobj.SQLExecuteDataset("SP_getTodayROL");
if (dsTotalROL.Tables[0].Rows.Count > 0)
{
lbltotalRecognition.Text = "Recognitions recorded today : " + dsTotalROL.Tables[0].Rows[0]["Count"].ToString();
}
dsTotalROL.Dispose();
}
protected void LoadROL()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsROL = new DataSet();
dsROL = sqlobj.SQLExecuteDataset("SP_LoadROL");
if (dsROL.Tables[0].Rows.Count > 0)
{
gvROL.DataSource = dsROL;
gvROL.DataBind();
}
dsROL.Dispose();
}
protected void LoadProspectTypes()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsCCustStatus = new DataSet();
ddlCCustStatus.Items.Clear();
if (ddlType.SelectedItem.Text == "PROSPECT")
{
dsCCustStatus = sqlobj.SQLExecuteDataset("SP_FetchDropDown",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 16
});
}
else if (ddlType.SelectedItem.Text == "VENDOR")
{
dsCCustStatus = sqlobj.SQLExecuteDataset("SP_FetchDropDown",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 25
});
}
else if (ddlType.SelectedItem.Text == "OTHER")
{
dsCCustStatus = sqlobj.SQLExecuteDataset("SP_FetchDropDown",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 23
});
}
else if (ddlType.SelectedItem.Text == "CUSTOMER")
{
dsCCustStatus = sqlobj.SQLExecuteDataset("SP_FetchDropDown",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 24
});
}
ddlCCustStatus.DataSource = dsCCustStatus.Tables[0];
ddlCCustStatus.DataValueField = "StatusCode";
ddlCCustStatus.DataTextField = "StatusDesc";
ddlCCustStatus.DataBind();
ddlCCustStatus.Dispose();
ddlCCustStatus.Items.Insert(0, "Please Select");
}
protected void LoadStatus()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsStaus = new DataSet();
dsStaus = sqlobj.SQLExecuteDataset("SP_FetchDropDown",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = 4
});
ddlbulkstatus.DataSource = dsStaus.Tables[0];
ddlbulkstatus.DataValueField = "StatusCode";
ddlbulkstatus.DataTextField = "StatusName";
ddlbulkstatus.DataBind();
dsStaus.Dispose();
}
protected void LoadTrackOn()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsTrackon = new DataSet();
dsTrackon = sqlobj.SQLExecuteDataset("sp_trackonlkup_new");
if (dsTrackon.Tables[0].Rows.Count != 0)
{
ddlMyTasksReference.DataSource = dsTrackon.Tables[0];
ddlMyTasksReference.DataValueField = "TrackonDesc";
ddlMyTasksReference.DataTextField = "TrackonDesc";
ddlMyTasksReference.DataBind();
ddlMyTasksReference.Items.Insert(0, "All");
}
dsTrackon.Dispose();
}
protected void LoadTaskDetDir1(string StaffID)
{
RdGrd_TaskDetDir1.DataSource = null;
RdGrd_TaskDetDir1.DataBind();
SQLProcs sqlobj = new SQLProcs();
DataSet dsTargetDet = null;
dsTargetDet = sqlobj.SQLExecuteDataset("SP_FetchTaskDetDir3",
new SqlParameter()
{
ParameterName = "@iMode", SqlDbType = SqlDbType.Int, Value = ddlTaskList1.SelectedValue
},
new SqlParameter()
{
ParameterName = "@StaffID", SqlDbType = SqlDbType.NVarChar, Value = StaffID
},
new SqlParameter()
{
ParameterName = "@TDate", SqlDbType = SqlDbType.DateTime, Value = dtpTaskDate1.SelectedDate
},
new SqlParameter()
{
ParameterName = "@FilterReference", SqlDbType = SqlDbType.NVarChar, Value = ddlMyTasksReference.SelectedValue == "All" ? null : ddlMyTasksReference.SelectedValue
}
);
if (dsTargetDet.Tables[0].Rows.Count > 0)
{
dtTemp.Dispose();
RdGrd_TaskDetDir1.DataSource = dsTargetDet.Tables[0];
int TypeRCount = dsTargetDet.Tables[0].Rows.Count;
lblmytaskscount.Text = " Count:" + TypeRCount;
RdGrd_TaskDetDir1.DataBind();
ViewState["MyTasks"] = dsTargetDet.Tables[0];
dsTargetDet.Dispose();
}
else
{
RdGrd_TaskDetDir1.DataSource = null;
RdGrd_TaskDetDir1.DataBind();
//RdGrd_TaskDetDir1.Visible = false;
lblmytaskscount.Text = " Count:0";
ViewState["MyTasks"] = null;
}
RdGrd_TaskDetDir1.Visible = true;
}
protected void btnMyTasks_Click(object sender, EventArgs e)
{
try
{
HDUserID.Value = QSUserName;
SQLProcs sqlobj = new SQLProcs();
try
{
if (ddlTaskList1.SelectedItem.Text != "Please Select")
{
string StaffID = QSUserName;
Session["StaffID"] = QSUserName;
string StaffName = QSUserName;
RdGrd_TaskDetDir1.Visible = true;
btnTaskDetDir1.Visible = true;
if (ddlTaskList1.SelectedIndex == 2 || ddlTaskList1.SelectedIndex == 3)
{
btnNewPing1.Visible = true;
}
else if (ddlTaskList1.SelectedIndex == 1 || ddlTaskList1.SelectedIndex == 7)
{
btnNewPing1.Visible = true;
dtpTaskDate1.Visible = false;
}
LoadTaskDetDir1(StaffID);
lblHelp11.Visible = true;
}
else
{
WebMsgBox.Show("Please select the task status");
}
}
catch (Exception qr)
{
WebMsgBox.Show("Please select an option from the drop down list");
return;
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message.ToString());
return;
}
}
protected void LoadCompanyDetails()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsCompanyDetails = new DataSet();
dsCompanyDetails = sqlobj.SQLExecuteDataset("SP_GetCompanyDetails");
if (dsCompanyDetails.Tables[0].Rows.Count != 0)
{
Session["ProductName"] = dsCompanyDetails.Tables[0].Rows[0]["productname"].ToString();
Session["ProductByLine"] = dsCompanyDetails.Tables[0].Rows[0]["productbyline"].ToString();
Session["Version"] = dsCompanyDetails.Tables[0].Rows[0]["versionnumber"].ToString();
Session["CompanyName"] = dsCompanyDetails.Tables[0].Rows[0]["companyname"].ToString();
Label1.Text = Session["ProductName"].ToString();
Label4.Text = Session["ProductByLine"].ToString();
if (CurrentPage != "login.aspx")
{
DataSet dsUserDetails = sqlobj.SQLExecuteDataset("SP_GetUserDetails", new SqlParameter {
ParameterName = "@UserID", SqlDbType = SqlDbType.NVarChar, Value = Session["UserID"].ToString()
});
if (dsUserDetails.Tables[0].Rows.Count > 0)
{
lbMore.Text = "Signed in as " + " " + Session["UserID"].ToString() + " " + " JobType:" + " " + dsUserDetails.Tables[0].Rows[0]["Designation"].ToString();
lbllastlogin.Text = "Your Sign-In was on " + dsUserDetails.Tables[0].Rows[0]["lastloggedin"].ToString();
//Add by Prakash.M
//DateTime dt = Convert.ToDateTime(dsUserDetails.Tables[0].Rows[0]["lastloggedin"].ToString()); // get current date time
//lbllastlogin.Text = "You last logged in on " + dt.ToString("ddd") + " " + string.Format("{0:dd-MMM-yyyy HH:mm 'Hrs'}", dt);
}
//Convert.ToDateTime().ToString("dd MMM yyyy | hh : mm tt")
dsUserDetails.Dispose();
}
Label2.Text = Session["CompanyName"].ToString();
Label3.Text = Session["Version"].ToString();
}
dsCompanyDetails.Dispose();
}
protected void LoadCompanyDetails()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsCompanyDetails = new DataSet();
dsCompanyDetails = sqlobj.SQLExecuteDataset("SP_GetCompanyDetails");
if (dsCompanyDetails.Tables[0].Rows.Count != 0)
{
Session["ProductName"] = dsCompanyDetails.Tables[0].Rows[0]["productname"].ToString();
Session["ProductByLine"] = dsCompanyDetails.Tables[0].Rows[0]["productbyline"].ToString();
Session["Version"] = dsCompanyDetails.Tables[0].Rows[0]["versionnumber"].ToString();
Session["CompanyName"] = dsCompanyDetails.Tables[0].Rows[0]["companyname"].ToString();
//lblCustDet.Text = Session["ProductName"].ToString();
//lblproductbyline.Text = Session["ProductByLine"].ToString();
// lblcompanyName.Text = Session["CompanyName"].ToString();
// lblVersion.Text = Session["Version"].ToString() ;
}
}
private void LoadDashBoard()
{
try
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsHomeDashboard = sqlobj.SQLExecuteDataset("Get_NewHomeDashboard");
DataSet dsDashboard = sqlobj.SQLExecuteDataset("SP_HomeDashboard",
new SqlParameter()
{
ParameterName = "@StaffID", SqlDbType = SqlDbType.NVarChar, Value = Session["UserID"].ToString()
});
if (dsHomeDashboard != null)
{
//lblMyTasks.Text = "MyTasks(" + dsHomeDashboard.Tables[0].Rows[0]["MyTasks"].ToString() + ")";
lblMyTasks.Text = "Sales Pipeline(" + dsHomeDashboard.Tables[0].Rows[0]["SalesPipeline"].ToString() + ")";
//lbltilemytaskscount.Text = "Complaints(" + dsHomeDashboard.Tables[1].Rows[0]["Complaint"].ToString() + ")";
lblByMe.Text = "Complaints(" + dsHomeDashboard.Tables[1].Rows[0]["Complaint"].ToString() + ")";
//lbltilebymecount.Text = "(" + dsHomeDashboard.Tables[1].Rows[0]["ByMe"].ToString() + ")";
//lblhipriority.Text = "HiPriority(" + dsHomeDashboard.Tables[2].Rows[0]["HiPriority"].ToString() + ")";
lbltodyasfollowups.Text = "Today's Followups(" + dsHomeDashboard.Tables[2].Rows[0]["TodaysFollowups"].ToString() + ")";
lbloverduefollowups.Text = "Overdue Followups(" + dsHomeDashboard.Tables[3].Rows[0]["OverdueFollowups"].ToString() + ")";
lbloncomingFollowups.Text = "OnComing Followups(" + dsHomeDashboard.Tables[4].Rows[0]["OncomingFollowups"].ToString() + ")";
}
if (dsDashboard != null)
{
lbltilemytaskscount.Text = "(" + dsDashboard.Tables[0].Rows[0]["MyTasks"].ToString() + ")";
lbltilebymecount.Text = "(" + dsDashboard.Tables[1].Rows[0]["ByMe"].ToString() + ")";
}
dsDashboard.Dispose();
dsHomeDashboard.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
protected void gvDiary_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Select")
{
int index = Convert.ToInt32(e.CommandArgument);
//LinkButton lb = (LinkButton)e.CommandSource;
//GridViewRow myrow = (GridViewRow)lb.Parent.Parent;
//GridView mygrid = (GridView)sender;
SQLProcs sqlobj = new SQLProcs();
DataSet dsCompanyInformation = new DataSet();
dsCompanyInformation = sqlobj.SQLExecuteDataset("sp_LoadCompanyInformation");
if (dsCompanyInformation.Tables[0].Rows.Count > 0)
{
string strISCM = dsCompanyInformation.Tables[0].Rows[0]["ISCM"].ToString();
if (strISCM == "True")
{
string strtaskRSN = gvDiary.DataKeys[index].Value.ToString();
Session["TaskRSN"] = strtaskRSN.ToString();
lblapmsg.Text = "#" + " " + strtaskRSN.ToString() + " " + "Additional Particulars";
// LoadWorkDetails
LoadMoreInfo();
}
}
dsCompanyInformation.Dispose();
}
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
private void LoadLeadSourceSummary()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsLeadSourceSummary = new DataSet();
DataSet dsLeadSourceSummaryTotal = new DataSet();
DataSet dsLeadSourceSummaryGraph = new DataSet();
dsLeadSourceSummary = sqlobj.SQLExecuteDataset("SP_LeadSummary");
//dsLeadSourceSummaryTotal = sqlobj.SQLExecuteDataset("SP_LeadSummaryTotal");
dsLeadSourceSummaryGraph = sqlobj.SQLExecuteDataset("sp_leadsummarygraph");
if (dsLeadSourceSummary.Tables[0].Rows.Count != 0)
{
gvLeadSourceSummary.DataSource = dsLeadSourceSummary;
gvLeadSourceSummary.DataBind();
gvLeadSourceSummary.ShowFooter = true;
gvLeadSourceSummary.FooterRow.Cells[0].Text = "Total";
gvLeadSourceSummary.FooterRow.Cells[0].HorizontalAlign = HorizontalAlign.Left;
gvLeadSourceSummary.FooterRow.Cells[1].Text = dsLeadSourceSummary.Tables[0].Compute("sum(LeadCount)", "").ToString();
gvLeadSourceSummary.FooterRow.Cells[3].Text = dsLeadSourceSummary.Tables[0].Compute("sum(InLast7Days)", "").ToString();
gvLeadSourceSummary.FooterRow.Cells[4].Text = dsLeadSourceSummary.Tables[0].Compute("sum(QLD)", "").ToString();
chartLeadSummary.DataSource = dsLeadSourceSummaryGraph;
chartLeadSummary.DataBind();
//gvLeadSourceSummaryTotal.DataSource = dsLeadSourceSummaryTotal;
//gvLeadSourceSummaryTotal.DataBind();
// HighlightColor(gvLeadSourceSummary, 2);
}
else
{
gvLeadSourceSummary.DataSource = null;
gvLeadSourceSummary.DataBind();
}
dsLeadSourceSummary.Dispose();
}
