public string FetchDocumentName(string PPRId)
{
string DocName = string.Empty;
try
{
PPRDataBL obj = new PPRDataBL();
DocName = obj.getDocNameBL(PPRId);
}
catch (Exception ex)
{
LogError(ex);
}
return(DocName);
}
protected string GetCountPPRApprovalNotification()
{
string ret = string.Empty;
try
{
PPRDataBL obj = new PPRDataBL();
ret = obj.GetCountPPRApprovalNotificationBL(Session["UserId"].ToString());
}
catch (Exception ex)
{
}
return(ret);
}
protected string getLoggedInfo()
{
string ret = string.Empty;
if (Session["LoginId"] != null)
{
PPRDataBL obj = new PPRDataBL();
return(obj.getLoggedInfoBL(Session["LoginId"].ToString()));
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Your session has been expired');window.location ='https://eapdea.gov.in/ppr/Login.aspx';", true);
}
return(ret);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
int success = obj.sendAgencyDetailBL(HttpUtility.HtmlEncode(txtAgencyName.Text), HttpUtility.HtmlEncode(txtAgencyAbbreviation.Text), HttpUtility.HtmlEncode(txtPostalCode.Text), HttpUtility.HtmlEncode(txtMobileNumber.Text), HttpUtility.HtmlEncode(txtTelephone.Text), HttpUtility.HtmlEncode(txtAddress.Text), HttpUtility.HtmlEncode(txtRemarks.Text));
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record saved successfully!');window.location ='Agency.aspx';", true);
ClearBox();
}
}
catch (Exception ex)
{ }
}
public void getMDBIdata()
{
try
{
PPRDataBL obj = new PPRDataBL();
ddlMDB.DataSource = obj.getMDBIdataBL();
ddlMDB.DataTextField = "MDBName";
ddlMDB.DataValueField = "MDB_Id";
ddlMDB.DataBind();
ddlMDB.Items.Insert(0, new ListItem("select ----", ""));
}
catch (Exception ex)
{
LogError(ex);
}
}
// Display Over All report
#region DisplayMisReportData
public bool DisplayMisReportData(string FilteId = "0", string Type = "M")
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = GetData(FilteId, Type);
GrdReport.DataSource = dt;
GrdReport.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
int success = obj.sendupdateProfileBL(HttpUtility.HtmlEncode(lblULoginId.Text), HttpUtility.HtmlEncode(txt_NName.Text), HttpUtility.HtmlEncode(txt_NTelephone.Text), HttpUtility.HtmlEncode(txt_NMobile.Text), HttpUtility.HtmlEncode(txt_NAddress1.Text), HttpUtility.HtmlEncode(txt_NAddress2.Text), HttpUtility.HtmlEncode(txt_NAddress3.Text));
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Profile update successfully');window.location ='UserProfile.aspx';", true);
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public bool DisplayAuditLogdetails()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetAuditLogDetaisBL(Session["LoginId"].ToString());
GrdAuditLogDetails.DataSource = dt;
GrdAuditLogDetails.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
public void getPPR(string minid, string roleid, string userid)
{
DataTable dt = new DataTable();
obj = new PPRDataBL();
dt = obj.getPPRBL(minid, roleid, userid);
if (dt.Rows.Count > 0)
{
ddlPPR.DataSource = dt;
ddlPPR.DataValueField = "PPRId";
ddlPPR.DataTextField = "ProjectName";
ddlPPR.DataBind();
ddlPPR.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select PPR----", ""));
}
ViewState["PPRDetails"] = dt;
}
public bool CountMinistryWisePpr()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.getCountMinistryWisePprBL();
StringBuilder s = new StringBuilder();
if (dt.Rows.Count > 0)
{
s.Append("<table class='table table-striped table-hover'>");
s.Append("<tr>");
s.Append("<th>Ministry Name</th>");
s.Append("<th style='text-align: center;'>No of PPR</th>");
s.Append("</tr>");
s.Append("</table>");
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Append("<a href='#'>");
s.Append("<table class='table table-striped table-hover'>");
s.Append("<tr>");
s.Append("<td>" + dt.Rows[i]["MinName"].ToString() + "</td>");
s.Append("<td style='width:25%;'>" + dt.Rows[i]["NoOfPpr"].ToString() + "</td>");
s.Append("</tr>");
s.Append("</table>");
s.Append("</a>");
}
//lblCountPprMinistryWise.Text = s.ToString();
}
else
{
s.Append("<a href='#'>");
s.Append("<table class='table table-bordered table-hover'>");
s.Append("<tr>");
s.Append("<td style='text-align: center;color: red;'>Currently There is no PPR available</td>");
s.Append("</tr>");
s.Append("</table>");
s.Append("</a>");
//lblCountPprMinistryWise.Text = s.ToString();
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void PPRDetailsGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeletePpr")
{
//Determine the RowIndex of the Row whose Button was clicked.
int rowIndex = Convert.ToInt32(e.CommandArgument);
//Reference the GridView Row.
GridViewRow row = PPRDetailsGridView.Rows[rowIndex];
//Fetch value of Name.
string PPRId = (row.FindControl("lblPPRId") as Label).Text;
try
{
MailUtility objm = new MailUtility();
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
string SendTo = string.Empty;
int success;
obj = new PPRDataBL();
success = obj.DeletePPrdraftDataBL(PPRId, Session["UserId"] != null ? Session["UserId"].ToString():"0");
DisplayPPRDetails();
if (success > 0)
{
//DashBoardDataBL obje = null;
//obje = new DashBoardDataBL();
//dt = obje.GetWithdrawPprUserEmailBL(PPRId);
//if(dt.Rows.Count>0)
//{
// for (int i=0; i < dt.Rows.Count; i++)
// {
// SendTo = dt.Rows[i]["N_Email"].ToString();
// SendTo = SendTo + ";" + dt.Rows[i]["N_Email"].ToString();
// }
// // objm.SendMailForPPRWithdraw(SendTo, PPRId);
//}
Alert.show("PPR has been Withdraw successfully!");
}
DisplayPPRDetails();
}
catch (Exception ex)
{
LogError(ex);
}
}
}
public bool CountMinistryWisePpr()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.getCountMinistryWisePprBL();
StringBuilder s = new StringBuilder();
if (dt.Rows.Count > 0)
{
s.Append("<div class='table table-responsive'><table class='table table-striped table-hover scrollbar-warning'>");
s.Append("<tr style='background-color:#85B0F5; '>");
s.Append("<th style=''>Ministry Name</th>");
s.Append("<th style='text-align: center;'>No of PPR</th>");
s.Append("</tr>");
s.Append("</table></div>");
for (int i = 0; i < dt.Rows.Count; i++)
{
s.Append("<a href='../Admin/PPRMisReport.aspx?qw2e=p3D0HoLEioKXfH02ulNOb7CvewV7i1HnqiUKXfH02u7i1HnqiUKXfH02ulNObARge6VvewARge6V7i1HnqiUKXfV7i1HnqiUKXfH02u7i1HnqiUKXfH02ulNObH02u7i1HnqiUKXfH02ulNOb7CvewAR&MinCount=MinWiseReport&gVrTqMinID=" + dt.Rows[i]["minid"].ToString() + "'>");
s.Append("<div class='table table-responsive'><table class='table table-striped table-hover'>");
s.Append("<tr>");
s.Append("<td style='height:30px' >" + dt.Rows[i]["MinName"].ToString() + "</td>");
s.Append("<td style='width:25%;height:30px'>" + dt.Rows[i]["NoOfPpr"].ToString() + "</td>");
s.Append("</tr>");
s.Append("</table></div>");
s.Append("</a>");
}
lblCountPprMinistryWise.Text = s.ToString();
}
else
{
s.Append("<a href='#'>");
s.Append("<table class='table table-bordered table-hover'>");
s.Append("<tr>");
s.Append("<td style='text-align: center;color: red;'>Currently There is no PPR available</td>");
s.Append("</tr>");
s.Append("</table>");
s.Append("</a>");
lblCountPprMinistryWise.Text = s.ToString();
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
public bool BindNotificationMessage()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
if (Session["LoginId"] != null)
{
dt = obj.BindNotificationMessageBL(Session["LoginId"].ToString(), "MasterPageNotification");
}
if (dt.Rows.Count > 0)
{
StringBuilder s = new StringBuilder();
s.Append("<div style='max-height:10px; !important'>");
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["HasRead"].Equals("N"))
{
s.Append("<div class='alert alert-danger clearfix' style='max-height:100px;'>");
s.Append("<span class='alert-icon'><i class='fa fa-bell fa-2x'></i></span>");
s.Append("<div class='noti-info'>");
s.Append("<a href='#'>");
s.Append(dt.Rows[i]["Notifications"].ToString() + "</a>");
s.Append("</div>");
s.Append("</div>");
}
if (dt.Rows[i]["HasRead"].Equals("Y"))
{
s.Append("<div class='alert alert-success clearfix' style='max-height:100px;'>");
s.Append("<span class='alert-icon'><i class='fa fa-bell fa-2x'></i></span>");
s.Append("<div class='noti-info'>");
s.Append("<a href='#'>");
s.Append(dt.Rows[i]["Notifications"].ToString() + "</a>");
s.Append("</div>");
s.Append("</div>");
}
}
s.Append("</div>");
//lblNotificationMessage.Text = s.ToString();
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try {
int success;
PPRDataBL obj = new PPRDataBL();
success = obj.deleteDesignationDataBL(lbldesignId.Text, txtremark.Text);
Display_data();
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Deleted successfully');window.location ='Designationmaster.aspx';", true);
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
int success = obj.sendFunctionModuleDataBL(ddlModule.SelectedValue, HttpUtility.HtmlEncode(txtFunctionName.Text), HttpUtility.HtmlEncode(txtFunctionAddress.Text), HttpUtility.HtmlEncode(txtRemarks.Text));
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Data Saved successfully');window.location ='FunctionMaster.aspx';", true);
ClearBox();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
int success = obj.SendRoleMappingDataBL(HttpUtility.HtmlEncode(ddluserdetails.SelectedValue), HttpUtility.HtmlEncode(ddlRole.SelectedValue));
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Data Saved successfully');window.location ='UserRolMap.aspx';", true);
ClearBox();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void getMeetingNotice()
{
DataTable dt = new DataTable();
PPRDataBL obj = new PPRDataBL();
dt = obj.getUserMeetingNoticeBL(Session["UserId"].ToString());
if (dt.Rows.Count > 0)
{
grdMeetingNotice.DataSource = dt;
grdMeetingNotice.DataBind();
}
else
{
grdMeetingNotice.DataSource = null;
grdMeetingNotice.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
int success = obj.sendMenuMappingDataBL(ddlRole.SelectedValue, ddlModule.SelectedValue, ddlFunction.SelectedValue, ddlDisplaySeqNo.SelectedValue, HttpUtility.HtmlEncode(txtRemarks.Text));
if (success > 0)
{
Alert.show("Menu Map successfully");
ClearBox();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public bool GetUserDetails()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.getUserProfileBL(Session["LoginId"].ToString());
if (dt.Rows.Count > 0)
{
txtAuthority.Text = dt.Rows[0]["N_Name"].ToString() + " ( " + dt.Rows[0]["DesignationName"].ToString() + " )";
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
public bool DisplayLastLoginDetails()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetLastLoginDetailsBL(Session["UserId"].ToString());
if (dt.Rows.Count > 0)
{
//lblLastLogin.Text = dt.Rows[0]["Date_last_login"].ToString();
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
private void SearchMinistry()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetSearchUserMinistryDataBL(HttpUtility.HtmlEncode(txtSearch.Text));
if (dt.Rows.Count > 0)
{
MinistryGridView.DataSource = dt;
MinistryGridView.DataBind();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public bool DisplayLastIpDetails()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetLastIPDetailsBL(Session["LoginId"].ToString());
if (dt.Rows.Count > 0)
{
// lblIpDetails.Text = dt.Rows[0]["FromIP"].ToString(); ;
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Displaydata();
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.getDuplicateMinistryBL(txtministrycode.Text);
if (dt.Rows.Count > 0)
{
lblmesg.Text = "";
lblmesg.Text = "This Ministry Code : already exists ";
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('This Ministry Code : already exists');window.location ='MinistryMaster.aspx';", true);
rfvremarks.Visible = false;
return;
}
if (Validation() == true)
{
if (ValidateNamechar(txtministry.Text) && ValidateMinCode(txtministrycode.Text) && ValidateFlag("Y") || ValidateFlag("N") == true)
{
int success = obj.insertMinistryDataBL(txtministry.Text, txtministrycode.Text, ddlMintype.SelectedValue.ToString());
if (success > 0)
{
int tmpRowCount;
string tmpControlName;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Saved Successfully');window.location ='MinistryMaster.aspx';", true);
// Alert.show("Record Saved Successfully");
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Saved Successfully');window.location ='MinistryMaster.aspx';", true);
}
}
}
}
catch (Exception ex)
{
LogError(ex);
}
//Response.Redirect("MinistryMaster.aspx");
if (MinistryGridView.Rows.Count > 1)
{
lblPageInfo.Text = String.Format("Viewing Page {0} of {1}", MinistryGridView.PageIndex + 1, MinistryGridView.PageCount);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
obj = new PPRDataBL();
string success = obj.SendSectoralAreaDataBL(HttpUtility.HtmlEncode(txtSectoralAbbrivation.Text), HttpUtility.HtmlEncode(txtSectoralName.Text), HttpUtility.HtmlEncode(txtRemarks.Text));
if (success == "True")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Save successfully');window.location ='SectoralArea.aspx';", true);
ClearBox();
}
else
{
Alert.show(success);
}
}
catch (Exception ex)
{ }
}
protected void UserRoleGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
string temp = e.CommandArgument.ToString();
string[] tokens = temp.Split('_');
lblRecordId.Text = HttpUtility.HtmlEncode(tokens[0]);
btnSubmit.Visible = false;
btnUpdate.Visible = true;
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetUserRoleMappingBoxDataBL(lblRecordId.Text);
if (dt.Rows.Count > 0)
{
ddluserdetails.SelectedValue = dt.Rows[0]["UserId"].ToString();
ddlRole.SelectedValue = dt.Rows[0]["Role"].ToString();
}
}
}
protected void btnSubmitActionRemarks_Click(object sender, EventArgs e)
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
int success;
obj = new PPRDataBL();
success = obj.DeletePPrMarkMinistryBL(ViewState["MinId"].ToString(), ViewState["Pprid"].ToString());
if (success > 0)
{
Alert.show("PPR marked to the Ministry/Department has been pulled back successfully");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
int success;
PPRDataBL obj = new PPRDataBL();
success = DepartmentDelete(lblMinId.Text);
Displaydata();
if (success > 0)
{
// ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Deleted Successfully');window.location ='MinistryMaster.aspx';", true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Deleted Successfully');window.location ='DepartmentAddEdit.aspx';", true);
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void BindBarGraph()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.getCountMinistryWisePprBL();
//Chart1.DataSource = dt;
//Chart1.Series[0].ChartType = (SeriesChartType)int.Parse("10");
//Chart1.Legends[0].Enabled = true;
//Chart1.Series[0].XValueMember = "MinName";
//Chart1.Series[0].YValueMembers = "NoOfPpr";
//Chart1.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
}
//#region BindNotificationForMark
//public bool BindNotificationForMark()
//{
// try
// {
// PPRDataBL obj = new PPRDataBL();
// DataTable dt = new DataTable();
// if (Session["LoginId"] != null)
// dt = obj.BindNotificationForMarkBL(Session["LoginId"].ToString());
// if (dt.Rows.Count > 0)
// {
// StringBuilder s = new StringBuilder();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// s.Append("<a href='RaiseQuery.aspx'>");
// s.Append("<div class='task-info clearfix'>");
// s.Append("<div class='desc pull-left'>");
// s.Append("<p style='width: 120%;color: green;'>" + dt.Rows[i]["SenderName"].ToString() + " is marked " + "PPR ID :- " + dt.Rows[i]["PPRId"].ToString() + " for your Comment last date of comment is " + dt.Rows[i]["LastDateOfComment"].ToString() + "</p>");
// s.Append("</div>");
// s.Append("</div>");
// s.Append("</a>");
// }
// lblPPRApprovalRequest.Text = s.ToString();
// }
// }
// catch (Exception ex)
// {
// LogError(ex);
// }
// return false;
//}
//#endregion
//===============================================================================================================
#region GetNotificationCount
protected string GetNotificationCount()
{
string ret = string.Empty;
try
{
if (Session["UserId"] != null)
{
PPRDataBL obj = new PPRDataBL();
ret = obj.GetNotificationCountBL(Session["UserId"].ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Your session has been expired');window.location ='https://eapdea.gov.in/ppr/Login.aspx';", true);
}
}
catch (Exception ex)
{ }
return(ret);
}
private void SearchUser()
{
try
{
PPRDataBL obj = new PPRDataBL();
DataTable dt = new DataTable();
dt = obj.GetSearchUserRoleMappingDataBL(HttpUtility.HtmlEncode(txtSearch.Text));
if (dt.Rows.Count > 0)
{
UserRoleGridView.DataSource = dt;
UserRoleGridView.DataBind();
}
// Panelmodule.Visible = true;
}
catch (Exception ex)
{
LogError(ex);
}
}
