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(); }