public bool DisplayRecivedPPRDetails()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetReceivedtBL(Session["ministry"].ToString());
if (dt.Rows.Count > 0)
{
GrdReceivedPpr.DataSource = dt;
GrdReceivedPpr.DataBind();
if (Session["Rolls"] != null)
{
if (Session["Rolls"].ToString() == "3")
{
GrdReceivedPpr.Columns[GrdReceivedPpr.Columns.Count - 1].Visible = false;
}
}
}
else
{
GrdReceivedPpr.DataSource = null;
GrdReceivedPpr.DataBind();
}
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void PPRDetailsGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string UserId = PPRDetailsGridView.DataKeys[e.Row.RowIndex].Value.ToString();
GridView GridNodalOfficerDetails = e.Row.FindControl("GridNodalOfficerDetails") as GridView;
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetNodalOfficerNameBL("NodalOfficerName", UserId);
if (dt.Rows.Count > 0)
{
GridNodalOfficerDetails.DataSource = dt;
GridNodalOfficerDetails.DataBind();
}
else
{
GridNodalOfficerDetails.DataSource = dt;
GridNodalOfficerDetails.DataBind();
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void GrdUserResetAccount_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "ResetAccount")
{
string temp = e.CommandArgument.ToString();
string[] tokens = temp.Split('+');
string UserId = HttpUtility.HtmlEncode(tokens[0]);
string EmailId = HttpUtility.HtmlEncode(tokens[1]);
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
int success = obje.ResetUserAccountBL("ResetAccount", UserId);
if (success > 0)
{
MailUtility objm = new MailUtility();
objm.SendUserAccountResetDetailsMail(EmailId);
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('User account has been successfully reset');window.location ='resetuseraccount.aspx';", true);
}
else
{
Alert.show("Due to server problem user account can not be reset");
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSubmitActionRemarks_Click(object sender, EventArgs e)
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
string SendTo = string.Empty;
int success = obje.ClosedPPRBL("ClosedPPR", txtClosingRemarks.Text, ViewState["PprId"].ToString(), Session["UserId"].ToString());
if (success > 0)
{
MailUtility objm = new MailUtility();
obje = new DashBoardDataBL();
DataTable dt = obje.GetClosedUserEmailBL("ClosedUserEmail", ViewState["PprId"].ToString());
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SendTo = SendTo + dt.Rows[i]["N_Email"].ToString() + ",";
}
}
objm.SendToClosedUserEmail(SendTo, ViewState["PprId"].ToString(), txtClosingRemarks.Text);
ViewState["PprId"] = null;
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('PPR has been successfully closed');window.location ='Default.aspx';", true);
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void grdMdbMapping_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string UserId = grdMdbMapping.DataKeys[e.Row.RowIndex].Value.ToString();
GridView GridMinistryMarks = e.Row.FindControl("GridMdbName") as GridView;
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetMDBNameBL(UserId);
if (dt.Rows.Count > 0)
{
GridMinistryMarks.DataSource = dt;
GridMinistryMarks.DataBind();
}
else
{
GridMinistryMarks.DataSource = dt;
GridMinistryMarks.DataBind();
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void CheckUserMdbmapping()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.CheckMdbRolMappingDetailsBL(ddlUser.SelectedValue, ddlMdbName.SelectedValue);
if (dt.Rows.Count != 0)
{
lblmsg.Visible = true;;
lblmsg.Text = "This User Id is already mapped with ( " + ddlMdbName.SelectedItem.Text + " )";
lblmsg.ForeColor = System.Drawing.Color.Red;
ddlMdbName.SelectedValue = "";
ddlMdbName.Focus();
System.Web.UI.ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "Script", "HideLabel();", true);
}
else
{
lblmsg.Text = "";
lblmsg.Visible = false;
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void GridNodalOfficerDetails_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "NodalOfficerDetails")
{
//Determine the RowIndex of the Row whose Button was clicked.
string loginId = e.CommandArgument.ToString();
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetNodalOfficerNameBL("NodalOfficerDetails", loginId);
lblName.Text = dt.Rows[0]["N_Name"].ToString();
lblMinistry.Text = dt.Rows[0]["MinName"].ToString();
lblDesignation.Text = dt.Rows[0]["DesignationName"].ToString();
lblMobile.Text = dt.Rows[0]["N_Mobile"].ToString();
lblEmail.Text = dt.Rows[0]["N_Email"].ToString();
lbltelephone.Text = dt.Rows[0]["N_Telephone"].ToString();
lbladdress.Text = dt.Rows[0]["N_Address1"].ToString() + " " + dt.Rows[0]["N_Address2"].ToString() + " " + dt.Rows[0]["N_Address3"].ToString();
ModalPopupExtender3.Show();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void grdDEAMeetingNotice_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string iUploadid = grdDEAMeetingNotice.DataKeys[e.Row.RowIndex].Value.ToString();
GridView GridMinistryMarks = e.Row.FindControl("GridMinistryMarks") as GridView;
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetMarkMinistryBL(iUploadid);
if (dt.Rows.Count > 0)
{
GridMinistryMarks.DataSource = dt;
GridMinistryMarks.DataBind();
}
else
{
GridMinistryMarks.DataSource = dt;
GridMinistryMarks.DataBind();
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public bool GetUserResetAccount()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetUserAccountResetBL("UserAccountDetails");
GrdUserResetAccount.DataSource = dt;
GrdUserResetAccount.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void btnImport_Click(object sender, EventArgs e)
{
try
{
btnImport.Visible = false;
btnReset.Visible = false;
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
int success = obje.ImportPprDataBL(ddlReferencePpr.SelectedValue, Session["UserId"].ToString());
hdnPPRId.Value = success.ToString();
GetInterMediateData();
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void PPRDetailsGridView_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
var linkButton = e.Row.FindControl("lnkEditppr") as LinkButton;
var Date = (e.Row.FindControl("HiddenField1") as HiddenField).Value;
if (Date != null && Date != "NA")
{
DateTime dateTime = DateTime.Now;
TableCell ShowEditButton = e.Row.Cells[9];
DateTime LastDate = Convert.ToDateTime(Date);
if (dateTime < LastDate)
{
//linkButton.Visible = true;
}
}
}
//****************new code ***************************
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string UserId = PPRDetailsGridView.DataKeys[e.Row.RowIndex].Value.ToString();
GridView GridNodalOfficerDetails = e.Row.FindControl("GridNodalOfficerDetails") as GridView;
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetNodalOfficerNameBL("NodalOfficerName", UserId);
if (dt.Rows.Count > 0)
{
GridNodalOfficerDetails.DataSource = dt;
GridNodalOfficerDetails.DataBind();
}
else
{
GridNodalOfficerDetails.DataSource = dt;
GridNodalOfficerDetails.DataBind();
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
// Display Over All report
#region DisplayMisReportData
public bool DisplayMisReportData()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetMdbMisReportDataBL(Session["UserId"].ToString());
//PPRDataBL obj = new PPRDataBL();
//DataTable dt = new DataTable();
//dt = obj.GetMisReportDataBL("", Session["UserId"].ToString(), Session["ministry"].ToString(), Session["Rolls"].ToString());
GrdReport.DataSource = dt;
GrdReport.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
protected void btnRegOtp_Click(object sender, EventArgs e)
{
try
{
MailUtility objm = new MailUtility();
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
string OTP = GetUniqueKey();
int success = obje.UserEmailVerificationBL(txt_NEmail.Text, lblloginId.Text, OTP);
if (success > 0)
{
objm.SendAccountVerificationEmail(txt_NEmail.Text, OTP);
Alert.show("One Time Password (OTP) has been Sent to Email Address");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void GridMdbName_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "UnMappedMDBUser")
{
string MDBID = e.CommandArgument.ToString();
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
int success = obje.DeleteMDBUSerBL(MDBID);
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('User MDB Remove Successfully');window.location ='MDBMapping.aspx';", true);
}
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
int success = obje.SendMdbMappingBL(ddlUser.SelectedValue, ddlMdbName.SelectedValue);
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('MDB Mapped Successfully');window.location ='MDBMapping.aspx';", true);
}
else
{
Alert.show("MDB Not Mapped Successfully !");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void GetMdbRolMappingDetails()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetMdbRolMappingDetailsBL();
if (dt.Rows.Count > 0)
{
grdMdbMapping.DataSource = dt;
grdMdbMapping.DataBind();
}
else
{
grdMdbMapping.DataSource = dt;
grdMdbMapping.DataBind();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
private void BindClosedPPR()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetClosedPPRBL("ClosedPPRDetails");
if (dt.Rows.Count > 0)
{
GrdClosedPpr.DataSource = dt;
GrdClosedPpr.DataBind();
}
else
{
GrdClosedPpr.DataSource = null;
GrdClosedPpr.DataBind();
}
}
catch (Exception ex)
{
LogError(ex);
}
}
// Display Over All report
#region DisplayMisReportData
public bool DisplayMisReportData(string QueryInfo, string PPRID, string ProjectName, string MinistryName, string AgencyName, string MDBName, string Status, string FromDate, string ToDate, string UserId, string MinistryID, string Roll, string sortExpression = null, string reportype = "Mis")
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetFilterReportDataBL(QueryInfo, PPRID, ProjectName, MinistryName, AgencyName, MDBName, Status, FromDate, ToDate, UserId, MinistryID, Roll, reportype);
if (sortExpression != null)
{
DataView dv = dt.AsDataView();
this.SortDirection = this.SortDirection == "ASC" ? "DESC" : "ASC";
dv.Sort = sortExpression + " " + this.SortDirection;
GrdReport.DataSource = dv;
}
else
{
GrdReport.DataSource = dt;
}
GrdReport.DataBind();
if (GrdReport.Rows.Count > 0)
{
btnExportExcel.Visible = true;
}
else
{
btnExportExcel.Visible = false;
}
// GrdReport.DataSource = dt;
// GrdReport.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
return(false);
}
public void DisplayNodalNotAvailable()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.DisplayNodalNotAvailableBL();
if (dt.Rows.Count > 0)
{
lblmsg.Visible = false;
LinkButton1.Visible = true;
}
else
{
LinkButton1.Visible = false;
}
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
}
public void Displaydata(string MinistryId)
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt = obje.GetUserRoleMapDetailBL(MinistryId);
if (dt.Rows.Count > 0)
{
lblmsg.Visible = false;
btnExportExcel.Visible = true;
}
else
{
btnExportExcel.Visible = false;
}
UserRoleGridView.DataSource = dt;
UserRoleGridView.DataBind();
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
PPRDataBL obj;
MailUtility objm;
int success = 0;
int counter = 0;
int none = 0;
foreach (System.Web.UI.WebControls.ListItem chkitem in chkMinistries.Items)
{
if (chkitem.Selected == true && chkitem.Enabled == true)
{
counter++;
}
}
if (counter == 0)
{
pnlMin.Visible = true;
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.BackColor = System.Drawing.Color.LightGoldenrodYellow;
lblmsg.Text = "Select atleast one Ministry to assign proposal";
Alert.show("Select atleast one Ministry to assign proposal");
return;
}
foreach (System.Web.UI.WebControls.ListItem chkitem in chkMinistries.Items)
{
if (chkitem.Value == "999" && counter > 1 && chkitem.Selected == true && Session["Rolls"].ToString() != "2")
{
lblmsg.Text = HttpUtility.HtmlDecode("You can't select other Ministry/Department if <b>Not required to Mark any Line Ministry/Department only send to DEA</b> selected by you.");
Alert.show("You can't select other Ministry/Department if Not required to Mark any Line Ministry/Department only send to DEA selected by you.");
return;
}
if (chkitem.Value == "999" && counter == 1)
{
none = 1;
}
}
foreach (System.Web.UI.WebControls.ListItem chkitem in chkMinistries.Items)
{
string LastCommentdate = DateTime.Now.AddDays(15).ToString();//CommonUtility.getmmddyyyy(txtlastCommentDate.Text).ToString();
if (chkitem.Selected == true && chkitem.Enabled == true)
{
obj = new PPRDataBL();
try
{
#region MarkPPRToDEA
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataTable dt1 = obje.GetDetailsofMarkPprOfDeaBL(ddlPPR.SelectedValue, "2");
if (dt1.Rows.Count <= 0)
{
success = obj.sendCommentDataBL("2", ddlPPR.SelectedValue, Session["UserId"].ToString(), chkPhysicallySent.Checked ? "Y" : "N", HttpUtility.HtmlEncode(txtComments.Text), LastCommentdate, Session["ministry"].ToString());
ViewState["DEAMAIL"] = "true";
}
#endregion
if (chkitem.Value != "999")
{
success = obj.sendCommentDataBL(chkitem.Value, ddlPPR.SelectedValue, Session["UserId"].ToString(), chkPhysicallySent.Checked ? "Y" : "N", HttpUtility.HtmlEncode(txtComments.Text), LastCommentdate, Session["ministry"].ToString());
}
DataTable dt = new DataTable();
obj = new PPRDataBL();
// dt = obj.GetDetailsForNotificationBL(chkitem.Value, ddlPPR.SelectedValue);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// success = obj.InsertNotificationBL(Session["LoginId"].ToString(), dt.Rows[i]["userid"].ToString(), ddlPPR.SelectedValue, "MarkPpr");
//}
}
catch (Exception ex)
{
LogError(ex);
}
if (success > 0)
{
if (chkitem.Value == "999")
{
lblmsg.BackColor = System.Drawing.Color.LightGoldenrodYellow;
lblmsg.ForeColor = System.Drawing.Color.Green;
lblmsg.Text = "This PPR has been successfully send to DEA.";
pnlMin.Visible = false;
proposalHeadings.BackColor = System.Drawing.Color.LightGoldenrodYellow;
ViewState["MTrue"] = "1";
}
else
{
lblmsg.BackColor = System.Drawing.Color.LightGoldenrodYellow;
lblmsg.ForeColor = System.Drawing.Color.Green;
lblmsg.Text = "PPR is successfully assigned to selected ministries and mail also sent to them.";
pnlMin.Visible = false;
proposalHeadings.BackColor = System.Drawing.Color.LightGoldenrodYellow;
}
//proposalHeadings.Text = "Your recent search results";
//proposalsList.Attributes.Add("style", "display:table");
#region sendmail
DataTable dt = new DataTable();
obj = new PPRDataBL();
dt = obj.getUserMailBL(Session["LoginId"].ToString(), chkitem.Value, ddlPPR.SelectedValue.ToString());
if (dt.Rows.Count > 0)
{
ViewState["MTrue"] = "1";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!DBNull.Value.Equals(dt.Rows[i][0].ToString()))
{
objm = new MailUtility();
//if(chkitem.Value=="2")
// objm.SendDEAReceivedMail(dt.Rows[i][0].ToString(), ddlPPR.SelectedValue.ToString(), ddlPPR.SelectedValue, dt.Rows[i][1].ToString(), DateTime.Now.AddDays(15).ToString("dd-MMM-yyyy"));
//else
SaveNotification(Session["LoginId"] != null ? Session["LoginId"].ToString() : "0", HttpUtility.HtmlDecode(ddlPPR.SelectedItem.ToString()) + " has been marked for your comments,", dt.Rows[i]["UserId"].ToString(), HttpUtility.HtmlDecode(ddlPPR.SelectedValue), "2", "~/Authenticate/LinMin/RaiseQuery.aspx", "~/Authenticate/LinMin/QMS.aspx", "0");
objm.SendCommentMail(dt.Rows[i][0].ToString(), (dt.Rows[i][1].ToString() + " has been marked PPR -" + HttpUtility.HtmlDecode(ddlPPR.SelectedItem.ToString())), ddlPPR.SelectedValue, dt.Rows[i][1].ToString(), DateTime.Now.AddDays(15).ToString("dd-MMM-yyyy"));
}
}
}
#endregion
}
else
{
if (none == 1)
{
lblmsg.BackColor = System.Drawing.Color.LightGoldenrodYellow;
lblmsg.ForeColor = System.Drawing.Color.Green;
lblmsg.Text = "This PPR has been successfully send to DEA.";
pnlMin.Visible = false;
proposalHeadings.BackColor = System.Drawing.Color.LightGoldenrodYellow;
}
else
{
lblmsg.BackColor = System.Drawing.Color.LightGoldenrodYellow;
lblmsg.ForeColor = System.Drawing.Color.Red;
lblmsg.Text = "Some error occured during the process.";
}
}
}
}
#region SendToDEAMailCode
DataTable dtDEA = new DataTable();
obj = new PPRDataBL();
if (ViewState["MTrue"] != null)
{
dtDEA = obj.getUserMailBL(Session["LoginId"].ToString(), "2", ddlPPR.SelectedValue.ToString(), ViewState["DEAMAIL"] != null? ViewState["DEAMAIL"].ToString():"false");
if (dtDEA.Rows.Count > 0)
{
for (int i = 0; i < dtDEA.Rows.Count; i++)
{
if (!DBNull.Value.Equals(dtDEA.Rows[i][0].ToString()))
{
objm = new MailUtility();
SaveNotification(Session["LoginId"] != null ? Session["LoginId"].ToString() : "0", ddlPPR.SelectedItem.ToString() + " is received", dtDEA.Rows[i]["UserId"].ToString(), ddlPPR.SelectedValue, "2", "~/Authenticate/DEAAdmin/Default.aspx", "~/Authenticate/LinMin/QMS.aspx", "0");
objm.SendDEAReceivedMail(dtDEA.Rows[i][0].ToString(), HttpUtility.HtmlDecode(ddlPPR.SelectedItem.ToString()), ddlPPR.SelectedValue, dtDEA.Rows[i][1].ToString(), DateTime.Now.AddDays(15).ToString("dd-MMM-yyyy"));
}
}
}
ViewState["MTrue"] = null;
ViewState["DEAMAIL"] = null;
}
#endregion
ddlPPR_SelectedIndexChanged(this, new EventArgs());
}
protected void txt_NEmail_TextChanged(object sender, EventArgs e)
{
try
{
if (ValidateEmail())
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
string OneTimePassword = GetUniqueKey();
MailUtility objm = new MailUtility();
String[] parts = txt_NEmail.Text.Split(new[] { '@' });
lblloginId.Text = parts[0];
SqlConnection con = DataAccess.GetConnction();
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("Usp_CheckEmailAndloginIdUser", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@UserEmail", DbType = DbType.String, Value = txt_NEmail.Text
});
cmd.Parameters.Add(new SqlParameter {
ParameterName = "@LoginId", DbType = DbType.String, Value = lblloginId.Text
});
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
if (ds.Tables[0].Rows.Count > 0)
{
txt_NEmail.Text = "";
txt_NEmail.Focus();
lblloginId.Text = "";
Alert.show("Email Id is Already Exist");
// UserRegistrationPanel.Style.Add("display", "block");
}
else if (ds.Tables[1].Rows.Count > 0)
{
String[] LoginID = txt_NEmail.Text.Split(new[] { '@' });
lblloginId.Text = LoginID[0] + LoginID[1].Substring(0, 1);
int success = obje.UserEmailVerificationBL(txt_NEmail.Text, lblloginId.Text, OneTimePassword);
if (success > 0)
{
// objm.SendAccountVerificationEmail(txt_NEmail.Text, OneTimePassword);
lblVerificationMsg.Text = "One Time Password (OTP) has been Sent to Email Address.";
lblVerificationMsg.ForeColor = System.Drawing.Color.Green;
txt_NEmail.Enabled = false;
OtpDetail.Visible = true;
lblRegOtpMsg.Visible = true;
btnRegisteration.Enabled = true;
// UserRegistrationPanel.Style.Add("display", "block");
}
}
else
{
int success = obje.UserEmailVerificationBL(txt_NEmail.Text, lblloginId.Text, OneTimePassword);
if (success > 0)
{
//objm.SendAccountVerificationEmail(txt_NEmail.Text, OneTimePassword);
lblVerificationMsg.Text = "One Time Password (OTP) has been Sent to Email Address.";
lblVerificationMsg.ForeColor = System.Drawing.Color.Green;
txt_NEmail.Enabled = false;
OtpDetail.Visible = true;
lblRegOtpMsg.Visible = true;
btnRegisteration.Enabled = true;
// UserRegistrationPanel.Style.Add("display", "block");
}
}
}
else
{
//UserRegistrationPanel.Style.Add("display", "block");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void GetDashBoardData()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataSet ds = obje.GetDashBoardDataBL(Session["UserId"].ToString(), Session["ministry"].ToString(), Session["Rolls"].ToString());
lblTotalPPR.Text = ds.Tables[0].Rows[0]["TotalPpr"].ToString();
//lblFinalPprSubmitted.Text = ds.Tables[1].Rows[0]["FinalPprSubmitte"].ToString();
lblMeetingSchedule.Text = ds.Tables[2].Rows[0]["MeetingSchedule"].ToString();
lblMom.Text = ds.Tables[3].Rows[0]["MOM"].ToString();
//lblCreatedPprMoreThanOneMonth.Text = ds.Tables[4].Rows[0]["CreatedPprMoreThanOneMonth"].ToString();
//lblSubmittedPprMoreThanOneMonth.Text = ds.Tables[5].Rows[0]["SubmittedPprMoreThanOneMonth"].ToString();
//lblDeferredppr.Text = ds.Tables[6].Rows[0]["DeferredPPR"].ToString();
// lblRejectPpr.Text = ds.Tables[7].Rows[0]["RejectedPPR"].ToString();
lblMarKPpr.Text = ds.Tables[8].Rows[0]["MarkPpr"].ToString();
//spss.InnerText= ds.Tables[0].Rows[0]["TotalPpr"].ToString();
//************** New code for mom pose pending
lblPendingPPR.Text = ds.Tables[10].Rows[0]["PPRPendingList"].ToString();
lblMoMnotIssued.Text = ds.Tables[9].Rows[0]["PendingMOm"].ToString();
lblPosedToBank.Text = ds.Tables[11].Rows[0]["PosedPPR"].ToString();
lblPendingtoPosed.Text = ds.Tables[12].Rows[0]["PendingtoPosed"].ToString();
if (lblTotalPPR.Text == "0" || lblTotalPPR.Text == "1")
{
RemoveCSS.RemoveCssClass(lblTotalPPR, "sps");
RemoveCSS.AddCssClass(lblTotalPPR, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblTotalPPR, "hom_but_a");
RemoveCSS.AddCssClass(lblTotalPPR, "sps");
}
if (lblMarKPpr.Text == "0" || lblMarKPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "sps");
RemoveCSS.AddCssClass(lblMarKPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblMarKPpr, "sps");
}
if (lblMeetingSchedule.Text == "0" || lblMeetingSchedule.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "sps");
RemoveCSS.AddCssClass(lblMeetingSchedule, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "hom_but_a");
RemoveCSS.AddCssClass(lblMeetingSchedule, "sps");
}
if (lblMom.Text == "0" || lblMom.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMom, "sps");
RemoveCSS.AddCssClass(lblMom, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMom, "hom_but_a");
RemoveCSS.AddCssClass(lblMom, "sps");
}
//**************** other code
if (lblMoMnotIssued.Text == "0" || lblMoMnotIssued.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "sps");
RemoveCSS.AddCssClass(lblMoMnotIssued, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "hom_but_a");
RemoveCSS.AddCssClass(lblMoMnotIssued, "sps");
}
if (lblPendingPPR.Text == "0" || lblPendingPPR.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingPPR, "sps");
RemoveCSS.AddCssClass(lblPendingPPR, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingPPR, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingPPR, "sps");
}
if (lblPosedToBank.Text == "0" || lblPosedToBank.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "sps");
RemoveCSS.AddCssClass(lblPosedToBank, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "hom_but_a");
RemoveCSS.AddCssClass(lblPosedToBank, "sps");
}
if (lblPendingtoPosed.Text == "0" || lblPendingtoPosed.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "sps");
RemoveCSS.AddCssClass(lblPendingtoPosed, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingtoPosed, "sps");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
string MomDocument = string.Empty;
string SendTo = string.Empty;
string folderPath = Server.MapPath("~/writedata/DeaMomUpload/");
int counter = 0;
SqlConnection con = DataAccess.GetConnction();
//if (!Directory.Exists(folderPath))
// {
// //If Directory (Folder) does not exists Create it.
// Directory.CreateDirectory(folderPath);
// }
MailUtility objmuser = new MailUtility();
foreach (System.Web.UI.WebControls.ListItem chkitem in chkMinistries.Items)
{
obje = new DashBoardDataBL();
if (chkitem.Selected == true)
{
counter++;
}
}
if (counter == 0)
{
Alert.show("Please Select at least one Ministry/Department");
return;
}
if (Utilities.ValidatePDF(FileUploadMomNotice) == "true")
{
MomDocument = "DeaMomDocument" + "_" + Session["LoginId"].ToString() + "_" + CommonUtility.GetDate(DateTime.Now);
FileInfo Fi = new FileInfo(FileUploadMomNotice.FileName);
MomDocumentBinary = FileUploadMomNotice.FileBytes;
}
FileUploadMomNotice.SaveAs(folderPath + "\\" + MomDocument + ".pdf");
//objmuser.SendDeaMomUploadMail(SendTo, txtMeetingDate.Text, folderPath + "\\" + MomDocument + ".pdf", txtRemarks.Text);
int success = obje.SendDecisionDataBL(Session["UserId"].ToString(), txtMeetingDate.Text, MomDocument, txtRemarks.Text, MomDocumentBinary);
foreach (System.Web.UI.WebControls.ListItem chkitem in chkMinistries.Items)
{
obje = new DashBoardDataBL();
if (chkitem.Selected == true)
{
DataTable dt = obje.GetMinistryUserEmailBL(chkitem.Value);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
SendTo = dt.Rows[0]["N_Email"].ToString() + "," + SendTo;
SqlCommand cmd = new SqlCommand("usp_InsertDEAMOMNodalMinDtls", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@userid", dt.Rows[i]["Userid"].ToString());
cmd.Parameters.AddWithValue("@MinistryId", dt.Rows[i]["MinistryId"].ToString());
cmd.Parameters.AddWithValue("@uploadid", success);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
objmuser.SendDeaMomUploadMail(SendTo, txtMeetingDate.Text, folderPath + "\\" + MomDocument + ".pdf", txtRemarks.Text);
if (success > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('MoM Uploaded Successfully and Mail Send To related ministry users');window.location ='DeaMomUpload.aspx';", true);
txtMeetingDate.Text = "";
txtRemarks.Text = "";
}
else
{
Alert.show("Due to Some Error Mom has not been uploaded");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
public void GetDashBoardData()
{
try
{
DashBoardDataBL obje = null;
obje = new DashBoardDataBL();
DataSet ds = obje.GetDashBoardDataBL(Session["UserId"].ToString(), Session["ministry"].ToString(), Session["Rolls"].ToString());
lblTotalPpr.Text = ds.Tables[0].Rows[0]["TotalPpr"].ToString();
lblApprovePpr.Text = ds.Tables[1].Rows[0]["ApprovePpr"].ToString();
lblMarKPpr.Text = ds.Tables[2].Rows[0]["MarkPpr"].ToString();
lblSendToDea.Text = ds.Tables[3].Rows[0]["SendToDea"].ToString();
lblMeetingSchedule.Text = ds.Tables[4].Rows[0]["MeetingSchedule"].ToString();
lblMoM.Text = ds.Tables[5].Rows[0]["Mom"].ToString();
lblPendingPpr.Text = ds.Tables[6].Rows[0]["PendingPpr"].ToString();
lblRejectPpr.Text = ds.Tables[7].Rows[0]["RejectPpr"].ToString();
lblMoMnotIssued.Text = ds.Tables[8].Rows[0]["PendingMOM"].ToString();
lblPosedToBank.Text = ds.Tables[9].Rows[0]["Pose"].ToString();
lblPendingtoPosed.Text = ds.Tables[10].Rows[0]["PendingtoPosed"].ToString();
if (lblTotalPpr.Text == "0" || lblTotalPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblTotalPpr, "sps");
RemoveCSS.AddCssClass(lblTotalPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblTotalPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblTotalPpr, "sps");
}
if (lblApprovePpr.Text == "0" || lblApprovePpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblApprovePpr, "sps");
RemoveCSS.AddCssClass(lblApprovePpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblApprovePpr, "hom_but_a");
RemoveCSS.AddCssClass(lblApprovePpr, "sps");
}
if (lblMarKPpr.Text == "0" || lblMarKPpr.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "sps");
RemoveCSS.AddCssClass(lblMarKPpr, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMarKPpr, "hom_but_a");
RemoveCSS.AddCssClass(lblMarKPpr, "sps");
}
if (lblMeetingSchedule.Text == "0" || lblMeetingSchedule.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "sps");
RemoveCSS.AddCssClass(lblMeetingSchedule, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMeetingSchedule, "hom_but_a");
RemoveCSS.AddCssClass(lblMeetingSchedule, "sps");
}
if (lblMoM.Text == "0" || lblMoM.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoM, "sps");
RemoveCSS.AddCssClass(lblMoM, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoM, "hom_but_a");
RemoveCSS.AddCssClass(lblMoM, "sps");
}
//**************** other code
if (lblMoMnotIssued.Text == "0" || lblMoMnotIssued.Text == "1")
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "sps");
RemoveCSS.AddCssClass(lblMoMnotIssued, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblMoMnotIssued, "hom_but_a");
RemoveCSS.AddCssClass(lblMoMnotIssued, "sps");
}
if (lblPosedToBank.Text == "0" || lblPosedToBank.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "sps");
RemoveCSS.AddCssClass(lblPosedToBank, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPosedToBank, "hom_but_a");
RemoveCSS.AddCssClass(lblPosedToBank, "sps");
}
if (lblPendingtoPosed.Text == "0" || lblPendingtoPosed.Text == "1")
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "sps");
RemoveCSS.AddCssClass(lblPendingtoPosed, "hom_but_a");
}
else
{
RemoveCSS.RemoveCssClass(lblPendingtoPosed, "hom_but_a");
RemoveCSS.AddCssClass(lblPendingtoPosed, "sps");
}
}
catch (Exception ex)
{
LogError(ex);
}
}
