private void CLoadCampaignSummary()
{
SQLProcs sqlobj = new SQLProcs();
DataSet dsCampaignSummary = new DataSet();
DataSet dsCampaignSummaryTotal = new DataSet();
DataSet dsCampaignSummaryGraph = new DataSet();
dsCampaignSummary = sqlobj.SQLExecuteDataset("SP_CCampaignSummary");
dsCampaignSummaryTotal = sqlobj.SQLExecuteDataset("SP_CCampaignSummaryTotal");
dsCampaignSummaryGraph = sqlobj.SQLExecuteDataset("sp_customercampaignsummarygraph");
if (dsCampaignSummary.Tables[0].Rows.Count != 0)
{
gvCCampaignSummary.DataSource = dsCampaignSummary;
gvCCampaignSummary.DataBind();
gvCCampaignSummaryTotal.DataSource = dsCampaignSummaryTotal;
gvCCampaignSummaryTotal.DataBind();
chartcustomercampaignsummary.DataSource = dsCampaignSummaryGraph;
chartcustomercampaignsummary.DataBind();
HighlightColor(gvCCampaignSummary, 2);
}
else
{
gvCCampaignSummary.DataSource = null;
gvCCampaignSummary.DataBind();
}
dsCampaignSummary.Dispose();
}
protected void LoadLeave(string staffid)
{
try
{
DataSet ds = new DataSet();
ds = proc.SQLExecuteDataset("SP_LeaveAllow",
new SqlParameter()
{
ParameterName = "@IMode", SqlDbType = SqlDbType.Int, Value = 1
},
new SqlParameter()
{
ParameterName = "@StaffId", SqlDbType = SqlDbType.Int, Value = Convert.ToInt64(staffid)
}
);
if (ds.Tables[0].Rows.Count > 0)
{
LblStaffname.Text = ds.Tables[0].Rows[0]["StaffName"].ToString();
LblCasualLeave.Text = ds.Tables[0].Rows[0]["Casual"].ToString();
LblEarnLeave.Text = ds.Tables[0].Rows[0]["Earn"].ToString();
LblSickLeave.Text = ds.Tables[0].Rows[0]["Sick"].ToString();
}
else
{
LblStaffname.Text = staffid;
LblCasualLeave.Text = "0";
LblEarnLeave.Text = "0";
LblSickLeave.Text = "0";
}
}
catch (Exception ex)
{
WebMsgBox.Show("Error on Load Leaves!");
}
}
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();
}
private void LoadComplaintsDetails()
{
DataSet dsComplaints = new DataSet();
dsComplaints = sqlobj.SQLExecuteDataset("Proc_GetComplaints_Home");
if (dsComplaints.Tables[0].Rows.Count > 0)
{
lblCompBT.Text = dsComplaints.Tables[0].Rows[0]["BookedToday"].ToString();
lblCompCT.Text = dsComplaints.Tables[0].Rows[0]["CompletedToday"].ToString();
lblCompPG.Text = dsComplaints.Tables[0].Rows[0]["Waiting"].ToString();
}
dsComplaints.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 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);
}
}
private void LoadRechargeHistory()
{
try
{
DataSet dsDT = proc.SQLExecuteDataset("SP_RechargeHistory");
if (dsDT.Tables[0].Rows.Count > 0)
{
rdgTxns.DataSource = dsDT;
rdgTxns.DataBind();
}
else
{
rdgTxns.DataSource = string.Empty;
rdgTxns.DataBind();
}
dsDT.Dispose();
}
catch (Exception ex)
{
WebMsgBox.Show(ex.Message);
}
}
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)
{
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();
}
}
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 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 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 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);
}
}
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.");
}
}
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);
}
}
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 LoadBtn()
{
try
{
if (Session["UserLevel"].ToString() == "4User")
{
BtnAppliedByMe.Visible = true;
}
else if (Session["UserLevel"].ToString() == "1Manager")
{
BtnAppliedByMe.Visible = true;
BtnViewAll.Visible = true;
}
else if (Session["UserLevel"].ToString() == "2CoOrdinator")
{
DataSet ds = new DataSet();
ds = proc.SQLExecuteDataset("SP_ChkNormal",
new SqlParameter()
{
ParameterName = "@staffid", SqlDbType = SqlDbType.BigInt, Value = Session["StaffId"].ToString()
}
);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["IsNormal"].ToString() == "True")
{
BtnAppliedByMe.Visible = true;
}
else
{
BtnAppliedByMe.Visible = true;
BtnViewAll.Visible = true;
DataSet dsaccounts = proc.SQLExecuteDataset("sp_chkaccounts",
new SqlParameter()
{
ParameterName = "@staffid", SqlDbType = SqlDbType.BigInt, Value = Session["StaffId"].ToString()
}
);
if (dsaccounts.Tables[0].Rows.Count > 0)
{
if (dsaccounts.Tables[0].Rows[0]["IsAccounts"].ToString() == "True")
{
BtnHolidays.Visible = true;
BtnLvCredit.Visible = true;
}
}
}
}
}
}
catch (Exception ex)
{
}
}
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 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 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");
}
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 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 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();
}
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();
}
public void LoginDetails()
{
DataSet dsUserDetails = proc.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();
staffemail = dsUserDetails.Tables[0].Rows[0]["StaffEmail"].ToString();
staffdesign = dsUserDetails.Tables[0].Rows[0]["Designation"].ToString();
}
dsUserDetails.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 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 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() ;
}
}