protected void btnupdate_Click(object sender, EventArgs e) //update button { try { User_Mangement bl = new User_Mangement(); Business B = new Business(); b.User_Id = txtuserid.Text.Trim(); b.Name = TextBoxName.Text.Trim(); b.Department_Id = DDLdeptname.SelectedValue; b.EmailId = txtemailid.Text.Trim(); b.InstituteId = DDLinstitutename.SelectedValue; if (txtDOB.Text != "01/01/0001" && txtDOB.Text != null && txtDOB.Text != "") { b.StudentDOB = Convert.ToDateTime(txtDOB.Text.Trim()); } if (txtMobileNo.Text != "") { b.MobileNo = txtMobileNo.Text; } b.Sex = DropDownListsex.SelectedValue; //b.BankAccountNumber = txtaccno.Text; b.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd"); b.UpdatedBy = Session["UserId"].ToString(); string OldmailID = Session["OldmailID"].ToString(); int isupdatemailid = 0; if (OldmailID != "") { if (OldmailID != b.emailId) { isupdatemailid = 1; } } //if (b.Role_Id == 1) //{ // b.pubinchargedept = RadioButtonListDeparmentPubincharge.SelectedValue; //} // int retemail = bl.Updatestudentmailid(txtemailid.Text, b, isupdatemailid, OldmailID); // b.Role_Name = DDLrolename.SelectedValue; int retVal = bl.UpdateStudentdetails(b); //Business layer ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('User detail update successfully')</script>"); //btninsert.Enabled = false; txtemailid.Enabled = false; popupPanelBaCode.Visible = false; GridViewUser.DataBind(); GridViewUser.Visible = false; } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } }
protected void btn_insert(object sender, EventArgs e) //insert button { if (!Page.IsValid) { return; } try { b.User_Id = txtuserid.Text.Trim(); // b.Name = txtname.Text; b.UserNamePrefix = DropDownListPrefix.SelectedValue; b.UserFirstName = TextBoxFname.Text.Trim(); b.UserMiddleName = TextBoxMname.Text.Trim(); b.UserLastName = TextBoxLName.Text.Trim(); b.Department_Id = DDLdeptname.SelectedValue; b.EmailId = txtemailid.Text.Trim(); b.InstituteId = DDLinstitutename.SelectedValue; b.AutoApproved = "Y"; b.Role_Id = Convert.ToInt32(DDLrolename.SelectedValue); b.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd"); b.CreatedBy = Session["UserId"].ToString(); if (b.Role_Id == 1) { b.pubinchargedept = RadioButtonListDeparmentPubincharge.SelectedValue; } int retVal = bl.SaveDepartmentDetails(b); //lblStatus.Text = ""; lblStatus.ForeColor = System.Drawing.Color.Green; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('User detail saved successfully');window.location='" + Request.ApplicationPath + "/UserManagement/User_manager.aspx';</script>"); GridViewUser.Visible = false; btninsert.Enabled = false; btninsert.Enabled = true; popupPanelBaCode.Visible = false; b = null; bl = null; } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } }
protected void btn_insert(object sender, EventArgs e) //insert button { if (!Page.IsValid) { return; } try { b.User_Id = txtuserid.Text.Trim(); b.Name = TextBoxName.Text.Trim(); b.Department_Id = DDLdeptname.SelectedValue; b.EmailId = txtemailid.Text.Trim(); b.InstituteId = DDLinstitutename.SelectedValue; //b.BankAccountNumber = txtaccno.Text; if (txtDOB.Text != "01/01/0001" && txtDOB.Text != null && txtDOB.Text != "") { b.StudentDOB = Convert.ToDateTime(txtDOB.Text.Trim()); } if (txtMobileNo.Text != "") { b.MobileNo = txtMobileNo.Text; } b.Sex = DropDownListsex.SelectedValue; b.CreatedDate = DateTime.Now.ToString("yyyy-MM-dd"); b.CreatedBy = Session["UserId"].ToString(); int retVal = bl.SaveStudentDetails(b); lblStatus.ForeColor = System.Drawing.Color.Green; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Student details saved successfully');window.location='" + Request.ApplicationPath + "/UserManagement/ManageStudent.aspx';</script>"); GridViewUser.Visible = false; btninsert.Enabled = false; btninsert.Enabled = true; popupPanelBaCode.Visible = false; b = null; bl = null; } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } }
protected void btn_insert(object sender, EventArgs e) //insert button { User b = new User(); User_Mangement bl = new User_Mangement(); if (!Page.IsValid) { return; } try { b.Department_Id = DDLdeptname.SelectedValue; b.InstituteId = DDLinstitutename.SelectedValue; b.AutoApproved = DropDownListAutoApprovee.SelectedValue; b.Remarks = TextBoxRemarks.Text.Trim(); b.UpdatedBy = Session["UserId"].ToString(); int retVal = bl.InsertDepartmentInstituteAutoAppove(b); if (retVal == 1) { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Data saved successfully');window.location='" + Request.ApplicationPath + "/UserManagement/InstDeptAutoApprove.aspx';</script>"); btninsert.Enabled = false; btninsert.Enabled = true; b = null; bl = null; } else { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } }
protected void DeptcodeTextChanged(object sender, EventArgs e) { try { User_Mangement v = new User_Mangement(); User b = new User(); User b1 = new User(); //b.UserId = null; //b.UserId = txtuserid.Text; b.User_Id = null; // b.User_Id = txtuserid.Text; b = v.selectExistingStudentDetails(txtuserid.Text.Trim()); if (b.User_Id != null) { txtuserid.Text = b.User_Id; //TextBoxName.Enabled = false; TextBoxName.Text = b.Name; DDLinstitutename.SelectedValue = b.Institute_name.Trim(); //DDLinstitutename.Enabled = false; DDLdeptname.Items.Clear(); // DDLdeptname.Items.Add(new ListItem("--Select--", "", true)); SqlDataSource1.SelectCommand = "select ClassCode,ClassName from SISClass"; SqlDataSource1.DataBind(); DDLdeptname.DataBind(); DDLdeptname.SelectedValue = b.Department.Trim(); DDLdeptname.DataBind(); //DDLdeptname.Enabled = false; txtemailid.Text = b.emailId; Session["OldmailID"] = txtemailid.Text; DropDownListsex.SelectedValue = b.Sex; //txtaccno.Text = b.BankAccountNumber; if (b.StudentDOB.ToShortDateString() != "01/01/0001") { txtDOB.Text = b.StudentDOB.ToShortDateString(); } if (b.MobileNo != "") { txtMobileNo.Text = b.MobileNo; } if (txtemailid.Text == "" || txtemailid.Text == null) { txtemailid.Enabled = true; } else { txtemailid.Enabled = true; } txtuserid.Enabled = false; btninsert.Enabled = false; btnupdate.Enabled = true; popupPanelBaCode.Visible = false; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert(' User exixts!')</script>"); } else { //lblActive.Visible = false; //DropDownListactive.Visible = false; btninsert.Enabled = true; btnupdate.Enabled = false; txtuserid.Enabled = false; popupPanelBaCode.Visible = false; txtemailid.Text = " "; //txtPassword.Text = " "; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert(' New User!')</script>"); } } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); if (ex.Message.Contains("DDLdeptname' has a SelectedValue which is invalid because it does not exist in the list of")) { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!Institue_Department Map error!!!')</script>"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } } }
protected void bindGridview(object sender, EventArgs e) { log.Debug("Inside bindGridview function"); User_Mangement b = new User_Mangement(); DataSet ds = b.GetHREmpData(); if (ds.Tables[0].Rows.Count == 0) { log.Debug("No records to update or insert"); ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('No HR record exists to update or add')</script>"); return; } else { string connectionString = ""; string isfilegenerate = ConfigurationManager.AppSettings["UserExcelFileGenerate"].ToString(); if (isfilegenerate == "Y") { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Workbook xlWorkbook = xlApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Sheets xlSheets = null; Worksheet xlWorksheet = null; object misValue = System.Reflection.Missing.Value; System.Data.DataTable dataTable = ds.Tables[0]; int rowNo = dataTable.Rows.Count; int columnNo = dataTable.Columns.Count; int colIndex = 0; //Create Excel Sheets xlSheets = xlWorkbook.Sheets; xlWorksheet = (Worksheet)xlSheets.Add(xlSheets[1], Type.Missing, Type.Missing, Type.Missing); //xlWorksheet.Name = dataSet.DataSetName; //Generate Field Names foreach (DataColumn dataColumn in dataTable.Columns) { colIndex++; xlApp.Cells[1, colIndex] = dataColumn.ColumnName; } object[,] objData = new object[rowNo, columnNo]; //Convert DataSet to Cell Data for (int row = 0; row < rowNo; row++) { for (int col = 0; col < columnNo; col++) { objData[row, col] = dataTable.Rows[row][col]; } } //Add the Data Range range = xlWorksheet.Range[xlApp.Cells[2, 1], xlApp.Cells[rowNo + 1, columnNo]]; range.Value2 = objData; //Remove the Default Worksheet ((Worksheet)xlApp.ActiveWorkbook.Sheets[xlApp.ActiveWorkbook.Sheets.Count]).Delete(); string servername = ConfigurationManager.AppSettings["ServerName"].ToString(); string domainame = ConfigurationManager.AppSettings["DomainName"].ToString(); string username = ConfigurationManager.AppSettings["UserName"].ToString(); string password = ConfigurationManager.AppSettings["Password"].ToString(); string mainpath = ConfigurationManager.AppSettings["UploadUserPath"].ToString(); string timestamp = DateTime.Now.ToString("yyyy-MM-dd-hh_mm_ss"); string ExcelFileVersion = ConfigurationManager.AppSettings["ExcelFileVersion"].ToString(); string FileName = "HRUserData" + timestamp + ExcelFileVersion; using (NetworkShareAccesser.Access(servername, domainame, username, password)) { if (Directory.Exists(mainpath)) { path = Path.Combine(mainpath, FileName); // xlWorkbook.SaveAs(FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkbook.SaveAs(path, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, XlSaveAsAccessMode.xlNoChange, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value); xlWorkbook.Close(); xlApp.Quit(); } else { Directory.CreateDirectory(mainpath); path = Path.Combine(mainpath, FileName); // xlWorkbook.SaveAs(FileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkbook.SaveAs(path, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, XlSaveAsAccessMode.xlNoChange, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value); xlWorkbook.Close(); xlApp.Quit(); } } } //string query = "SELECT * FROM [Sheet2$]"; //connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\""; //OleDbConnection conn = new OleDbConnection(connectionString); //if (conn.State == ConnectionState.Closed) // conn.Open(); //OleDbCommand cmd = new OleDbCommand(query, conn); //OleDbDataAdapter da = new OleDbDataAdapter(cmd); //DataSet ds1 = new DataSet(); //da.Fill(ds1); GridExcelData.DataSource = ds.Tables[0]; GridExcelData.DataBind(); //da.Dispose(); //conn.Close(); //conn.Dispose(); } }
protected void DeptcodeTextChanged(object sender, EventArgs e) { try { User_Mangement v = new User_Mangement(); User b = new User(); User b1 = new User(); //b.UserId = null; //b.UserId = txtuserid.Text; b.User_Id = null; // b.User_Id = txtuserid.Text; b = v.selectExistingUser(txtuserid.Text.Trim()); if (b.User_Id != null) { lblActive.Visible = true; DropDownListactive.Visible = true; txtuserid.Text = b.User_Id; DropDownListPrefix.SelectedValue = b.UserNamePrefix; DropDownListPrefix.Enabled = false; TextBoxFname.Text = b.UserFirstName; TextBoxFname.Enabled = false; TextBoxMname.Text = b.UserMiddleName; TextBoxMname.Enabled = false; TextBoxLName.Text = b.UserLastName; TextBoxLName.Enabled = false; DDLinstitutename.SelectedValue = b.Institute_name; DDLinstitutename.Enabled = false; DropDownListactive.SelectedValue = b.Active; DropDownListactive.Enabled = false; DDLdeptname.Items.Clear(); SqlDataSource1.SelectParameters.Clear(); SqlDataSource1.SelectParameters.Add("Institute_Id", DDLinstitutename.SelectedValue); // DDLdeptname.Items.Add(new ListItem("--Select--", "", true)); SqlDataSource1.SelectCommand = "SELECT DISTINCT [DeptName], [DeptId] FROM [Dept_M] where Institute_Id =@Institute_Id"; SqlDataSource1.DataBind(); DDLdeptname.DataBind(); DDLdeptname.SelectedValue = b.Department; DDLdeptname.DataBind(); DDLdeptname.Enabled = false; txtemailid.Text = b.EmailId; Session["OldmailID"] = txtemailid.Text; if (txtemailid.Text == "" || txtemailid.Text == null) { txtemailid.Enabled = true; } else { txtemailid.Enabled = true; } //RBLautoapproval.Text = b.AutoApproved; //RBLautoapproval.Enabled = false; // SqlDataSource3.SelectCommand = ""; if (b.Role_Id == 5) {//librarian SqlDataSource3.SelectCommand = "SELECT DISTINCT [Role_Name], [Role_Id] FROM [Role_M] "; SqlDataSource3.DataBind(); DDLrolename.DataBind(); } else { // SqlDataSource3.SelectCommand = "SELECT DISTINCT [Role_Name], [Role_Id] FROM [Role_M] where Role_Id!=5"; // SqlDataSource3.DataBind(); //DDLrolename.DataBind(); } DDLrolename.SelectedValue = Convert.ToString(b.Role_Id); if (b.Role_Id == 1) { DDLrolename.Enabled = true; btnupdate.Enabled = true; RadioButtonListDeparmentPubincharge.Items.Clear(); string deptname = DDLdeptname.SelectedItem.ToString(); string deptvalue = DDLdeptname.SelectedValue; PubDept.Visible = true; RadioButtonListDeparmentPubincharge.Visible = true; RadioButtonListDeparmentPubincharge.Items.Add(new ListItem(deptname, deptvalue, true)); RadioButtonListDeparmentPubincharge.Items.Add(new ListItem("All Departments of Institute", "", true)); b1 = v.selectPubInchargeUM(txtuserid.Text.Trim()); RadioButtonListDeparmentPubincharge.SelectedValue = b1.Department_Id; RadioButtonListDeparmentPubincharge.DataBind(); } else if (b.Role_Id == 5) { //librarian DDLrolename.Enabled = false; btnupdate.Enabled = false; } else { DDLrolename.Enabled = true; btnupdate.Enabled = true; PubDept.Visible = false; RadioButtonListDeparmentPubincharge.Visible = false; RadioButtonListDeparmentPubincharge.Items.Clear(); } txtuserid.Enabled = false; btninsert.Enabled = false; // btnupdate.Enabled = true; popupPanelBaCode.Visible = false; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert(' User exixts!')</script>"); } else { lblActive.Visible = false; DropDownListactive.Visible = false; btninsert.Enabled = true; btnupdate.Enabled = false; txtuserid.Enabled = false; popupPanelBaCode.Visible = false; ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert(' New User!')</script>"); } } catch (Exception ex) { log.Error(ex.StackTrace); log.Error(ex.Message); log.Error("Error!!!!!!!!!!!!!!!! "); if (ex.Message.Contains("DDLdeptname' has a SelectedValue which is invalid because it does not exist in the list of")) { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!Institue_Department Map error!!!')</script>"); } else { ClientScript.RegisterStartupScript(Page.GetType(), "validation1", "<script language='javascript'>alert('Error!!!!!!!!!!')</script>"); } } }