public List <int> GetAge(string FromDate, string sp) { List <int> list = new List <int>(); SqlCommand cmd = new SqlCommand(sp, BD.ConStr); cmd.CommandType = CommandType.StoredProcedure; //Add Output parameters cmd.Parameters.AddWithValue("@FromDate", DateTime.Parse(FromDate)); SqlParameter AgeYears = new SqlParameter("@AgeYears", SqlDbType.Int); AgeYears.Direction = ParameterDirection.Output; cmd.Parameters.Add(AgeYears); SqlParameter AgeMonths = new SqlParameter("@AgeMonths", SqlDbType.Int); AgeMonths.Direction = ParameterDirection.Output; cmd.Parameters.Add(AgeMonths); SqlParameter AgeDays = new SqlParameter("@AgeDays", SqlDbType.Int); AgeDays.Direction = ParameterDirection.Output; cmd.Parameters.Add(AgeDays); BD.UpdateParameters(cmd); list.Add((int)cmd.Parameters["@AgeYears"].Value); list.Add((int)cmd.Parameters["@AgeMonths"].Value); list.Add((int)cmd.Parameters["@AgeDays"].Value); return(list); }
//Inserts a new course for selected PlacementID protected void CreateNewDrive(object sender, EventArgs e) { SqlCommand ObjCmd = new SqlCommand("spAddDrive", BD.ConStr); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Parameters.AddWithValue("@DriveTitle", txtBoxDriveTitle.Text); ObjCmd.Parameters.AddWithValue("@EmployerID", Convert.ToInt32(ddlEmployerID.SelectedValue.ToString())); ObjCmd.Parameters.AddWithValue("@JobDescription", txtBoxJobDescription.Text); ObjCmd.Parameters.AddWithValue("@DriveDate", DateTime.Parse(txtBoxDriveDate.Text)); ObjCmd.Parameters.AddWithValue("@CoordinatorID", Convert.ToInt32(ddlCoordinatorID.SelectedValue.ToString())); BD.UpdateParameters(ObjCmd); BD.DataBindToGridView(gvPlacementDrives, "SELECT * FROM EduSphere.PlacementDrives d JOIN EduSphere.Organizations o ON d.EmployerID=o.OrgnizationID JOIN EduSphere.Staff s ON d.CoordinatorID=s.EmployeeID", "NA"); txtBoxDriveTitle.Text = ""; txtBoxJobDescription.Text = ""; }
//Add New Organization protected void AddNewOrganization(object sender, CommandEventArgs e) { SqlCommand ObjCmd = new SqlCommand("spInsertOrganization", BD.ConStr); ObjCmd.CommandType = CommandType.StoredProcedure; string strNotify = "NO"; //if (chkBoxNotify.Checked) // strNotify = "YES"; ObjCmd.Parameters.AddWithValue("@OrganizationName", txtBoxOrganizationName.Text); ObjCmd.Parameters.AddWithValue("@OrganizationType", ddlOrganizationType.SelectedValue.ToString()); ObjCmd.Parameters.AddWithValue("@ManagerName", txtBoxManagerName.Text); ObjCmd.Parameters.AddWithValue("@ManagerEmail", txtBoxManagerEmail.Text); ObjCmd.Parameters.AddWithValue("@ManagerPhone", "+91" + txtBoxManagerPhone.Text); ObjCmd.Parameters.AddWithValue("@ContactPerson", txtBoxContactPerson.Text); ObjCmd.Parameters.AddWithValue("@PhoneOne", "+91" + txtBoxPhoneTwo.Text); ObjCmd.Parameters.AddWithValue("@PhoneTwo", "+91" + txtBoxPhoneTwo.Text); ObjCmd.Parameters.AddWithValue("@Email", txtBoxEmail.Text); ObjCmd.Parameters.AddWithValue("@OfficeAddress", txtBoxOfficeAddress.Text); ObjCmd.Parameters.AddWithValue("@EnrolmentDate", DateTime.Parse(txtBoxEnrolmentDate.Text));//The first servie ID in services ObjCmd.Parameters.AddWithValue("@MemberPhoto", ""); ObjCmd.Parameters.AddWithValue("@Remarks", txtBoxRemarks.Text); ObjCmd.Parameters.AddWithValue("@Notify", strNotify); ObjCmd.Parameters.AddWithValue("@street_number", street_number.Text); ObjCmd.Parameters.AddWithValue("@route", route.Text); ObjCmd.Parameters.AddWithValue("@locality", locality.Text); ObjCmd.Parameters.AddWithValue("@administrative_area_level_1", administrative_area_level_1.Text); ObjCmd.Parameters.AddWithValue("@postal_code", postal_code.Text); ObjCmd.Parameters.AddWithValue("@country", country.Text); BD.UpdateParameters(ObjCmd); //Response.Write("<script>alert('Member enrolled successfully')</script>"); ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Organization Added !!!')", true); //Refresh View Organization List to display newly added customer. Response.Redirect("Organizations.aspx"); //Display customer count //send Welcome Message to Organization //if (strNotify == "YES") //{ // Connect EC = new Connect(); // string strSMSmessage = string.Format("Dear '{0}, Thanks for visiting Purple Salon N Academy !!!", strFirstName); // EC.SendSMS(strPhoneOne, strSMSmessage); // SentMsgLogger("SMS", strSMSmessage, strPhoneOne, strFirstName); //} }
//Indicators public List <int> ShowIndicatorsDashboard(DateTime IndicatorDate, int intOrganizationID) { List <int> list = new List <int>();//list to contain all output parametrs returned values SqlCommand ObjCmd = new SqlCommand("spIndicators", BD.ConStr); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Parameters.AddWithValue("@IndicatorDate", IndicatorDate); ObjCmd.Parameters.AddWithValue("@OrganizationID", intOrganizationID); SqlParameter TodaysServiceBills = new SqlParameter("@TodaysServiceBills", SqlDbType.Int); TodaysServiceBills.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(TodaysServiceBills); SqlParameter TodaysExpenseBills = new SqlParameter("@TodaysExpenseBills", SqlDbType.Int); TodaysExpenseBills.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(TodaysExpenseBills); SqlParameter TodaysServiceReceipts = new SqlParameter("@TodaysServiceReceipts", SqlDbType.Int); TodaysServiceReceipts.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(TodaysServiceReceipts); SqlParameter MonthlyServiceBills = new SqlParameter("@MonthlyServiceBills", SqlDbType.Int); MonthlyServiceBills.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(MonthlyServiceBills); SqlParameter MonthlyExpenseBills = new SqlParameter("@MonthlyExpenseBills", SqlDbType.Int); MonthlyExpenseBills.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(MonthlyExpenseBills); SqlParameter MonthlyServiceReceipts = new SqlParameter("@MonthlyServiceReceipts", SqlDbType.Int); MonthlyServiceReceipts.Direction = ParameterDirection.Output; ObjCmd.Parameters.Add(MonthlyServiceReceipts); BD.UpdateParameters(ObjCmd); list.Add((int)ObjCmd.Parameters["@TodaysServiceBills"].Value); list.Add((int)ObjCmd.Parameters["@TodaysExpenseBills"].Value); list.Add((int)ObjCmd.Parameters["@TodaysServiceReceipts"].Value); list.Add((int)ObjCmd.Parameters["@MonthlyServiceBills"].Value); list.Add((int)ObjCmd.Parameters["@MonthlyExpenseBills"].Value); list.Add((int)ObjCmd.Parameters["@MonthlyServiceReceipts"].Value); return(list); }
//Add New RoleRequests protected void AddNewRoleRequests(object sender, CommandEventArgs e) { SqlCommand ObjCmd = new SqlCommand("spInsertRoleRequests", BD.ConStr); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Parameters.AddWithValue("@ProgramId", Convert.ToInt32(ddlProgramId.SelectedValue.ToString())); ObjCmd.Parameters.AddWithValue("@FranchiseeID", Convert.ToInt32(ddlFranchiseeID.SelectedValue.ToString())); ObjCmd.Parameters.AddWithValue("@RequesterFullName", txtBoxStudentName.Text); ObjCmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedValue.ToString()); ObjCmd.Parameters.AddWithValue("@Education", txtBoxEducation.Text); ObjCmd.Parameters.AddWithValue("@Institute", txtBoxInstitute.Text); ObjCmd.Parameters.AddWithValue("@Stream", txtBoxStream.Text); ObjCmd.Parameters.AddWithValue("@RequesterEmail", txtBoxEmail.Text); ObjCmd.Parameters.AddWithValue("@RequesterPhone", txtBoxPhone.Text); ObjCmd.Parameters.AddWithValue("@RequesterState", txtBoxCity.Text); ObjCmd.Parameters.AddWithValue("@RequesterAddress", txtBoxState.Text); ObjCmd.Parameters.AddWithValue("@PinCode", txtBoxPinCode.Text); ObjCmd.Parameters.AddWithValue("@RoleRequestsMessage", txtBoxRoleRequestsMessage.Text); ObjCmd.Parameters.AddWithValue("@RaisedById", lblRaisedById.Text); ObjCmd.Parameters.AddWithValue("@RoleRequestsSource", txtBoxSource.Text); BD.UpdateParameters(ObjCmd); //SP.Speak("Request Registered Successfully"); //Response.Write("<script>alert('Request Registered Successfully')</script>"); //Alert Sound ScriptManager.RegisterStartupScript(this, GetType(), "makeAlertSound", "playSound()", true); //Refresh View RoleRequests List to display newly added RoleRequests. //Response.Redirect("Requests.aspx"); txtBoxStudentName.Text = ""; txtBoxEmail.Text = ""; txtBoxCity.Text = ""; //Display RoleRequests count //send Welcome Message to RoleRequests //if (strNotify == "YES") //{ // Connect EC = new Connect(); // string strSMSmessage = string.Format("Dear '{0}, Thanks for visiting Purple Salon N Academy !!!", strFirstName); // EC.SendSMS(strPhoneOne, strSMSmessage); // SentMsgLogger("SMS", strSMSmessage, strPhoneOne, strFirstName); //} }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lblStaffAction.Text = "Mark your Attendance for the Day"; pnlViewStaff.Visible = true; pnlViewStaffProfile.Visible = false; //Create attendatce for the day if didn't exist. SqlCommand cmd = new SqlCommand("spCreateAttendanceDay", BD.ConStr); cmd.CommandType = CommandType.StoredProcedure; BD.UpdateParameters(cmd); //Display Today Attendace Register DateTime AttendanceDate = DateTime.Now; string strAttendanceDate = AttendanceDate.ToString("yyyy-MM-dd"); string strCmd = ""; if (User.IsInRole("Admin")) { strCmd = string.Format("SELECT *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId WHERE AttendanceDate='{0}' ORDER BY s.FullName ASC", strAttendanceDate); } if (User.IsInRole("Manager")) { strCmd = string.Format(@"SELECT *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId WHERE AttendanceDate='{0}' AND OrganizationID=(SELECT OrganizationId FROM EduSphere.Staff WHERE Email='{1}' ) ORDER BY s.FullName ASC", strAttendanceDate, User.Identity.Name.ToString()); } if (User.IsInRole("Employee")) { strCmd = string.Format(@"SELECT *,a.EmployeeId,s.FullName,s.PhoneOne,s.Email FROM EduSphere.StaffAttendance a JOIN EduSphere.Staff s ON a.EmployeeId=s.EmployeeId WHERE AttendanceDate='{0}' AND Email='{1}'", strAttendanceDate, User.Identity.Name.ToString()); } BD.DataBindToDataList(dlStaff, strCmd); } }
protected void Page_Load(object sender, EventArgs e) { //http://saketsoftail.com/new.aspx?ProgramId=%100&FranchiseeID=%100&StudentName=%Reena&Key=%SJA@123 //string dispnumber = Request.QueryString["dispnumber"]; //string caller_id = Request.QueryString["caller_id"]; string ProgramId = Request.Form["ProgramId"]; string FranchiseeID = Request.Form["FranchiseeID"]; string StudentName = Request.Form["StudentName"]; string Gender = Request.Form["Gender"]; string Education = Request.Form["Education"]; string Institute = Request.Form["Institute"]; string Stream = Request.Form["Stream"]; string Phone = Request.Form["Phone"]; string Email = Request.Form["Email"]; string City = Request.Form["City"]; string State = Request.Form["State"]; string PinCode = Request.Form["PinCode"]; string EnquiryMessage = Request.Form["EnquiryMessage"]; string EnquirySource = Request.Form["EnquirySource"]; string RaisedById = Request.Form["RaisedById"]; string Key = Request.Form["Key"]; if (Key == "SJA@123") { SqlCommand ObjCmd = new SqlCommand("spInsertEnquiry", BD.ConStr); ObjCmd.CommandType = System.Data.CommandType.StoredProcedure; ObjCmd.Parameters.AddWithValue("@ProgramId", Convert.ToInt32(ProgramId)); ObjCmd.Parameters.AddWithValue("@FranchiseeID", Convert.ToInt32(FranchiseeID)); ObjCmd.Parameters.AddWithValue("@StudentName", StudentName); ObjCmd.Parameters.AddWithValue("@Gender", Gender); ObjCmd.Parameters.AddWithValue("@Education", Education); ObjCmd.Parameters.AddWithValue("@Institute", Institute); ObjCmd.Parameters.AddWithValue("@Stream", Stream); ObjCmd.Parameters.AddWithValue("@Email", Phone); ObjCmd.Parameters.AddWithValue("@Phone", Email); ObjCmd.Parameters.AddWithValue("@City", City); ObjCmd.Parameters.AddWithValue("@State", State); ObjCmd.Parameters.AddWithValue("@PinCode", PinCode); ObjCmd.Parameters.AddWithValue("@EnquiryMessage", EnquiryMessage); ObjCmd.Parameters.AddWithValue("@RaisedById", RaisedById); ObjCmd.Parameters.AddWithValue("@EnquirySource", EnquirySource); BD.UpdateParameters(ObjCmd); } }
//Add New Staff protected void AddNewStaff(object sender, CommandEventArgs e) { SqlCommand ObjCmd = new SqlCommand("spInsertStaff", BD.ConStr); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Parameters.AddWithValue("@OrganizationID", ddlOrgId.SelectedValue.ToString()); ObjCmd.Parameters.AddWithValue("@EmpPhotoPath", "~/Artifacts/Emp/Photo/Photo.jpg"); ObjCmd.Parameters.AddWithValue("@FullName", txtBoxFullName.Text); ObjCmd.Parameters.AddWithValue("@Gender", ddlGender.SelectedValue.ToString()); ObjCmd.Parameters.AddWithValue("@PhoneOne", "+91" + txtBoxPhoneOne.Text); ObjCmd.Parameters.AddWithValue("@PhoneTwo", "+91" + txtBoxPhoneTwo.Text); ObjCmd.Parameters.AddWithValue("@Email", txtBoxEmail.Text); ObjCmd.Parameters.AddWithValue("@ContactAddress", txtBoxContactAddress.Text); ObjCmd.Parameters.AddWithValue("@City", txtBoxCity.Text); ObjCmd.Parameters.AddWithValue("@District", txtBoxDistrict.Text);//The first servie ID in services ObjCmd.Parameters.AddWithValue("@PinCode", txtBoxPinCode.Text); ObjCmd.Parameters.AddWithValue("@State", txtBoxState.Text); ObjCmd.Parameters.AddWithValue("@Country", txtBoxCountry.Text); ObjCmd.Parameters.AddWithValue("@Designation", txtBoxDesignation.Text); ObjCmd.Parameters.AddWithValue("@DateOfBirth", DateTime.Parse(txtBoxDateOfBirth.Text)); int intManagerId = 99; string strManagerId = ddlManagerId.SelectedValue.ToString(); if (strManagerId != "Select") { ObjCmd.Parameters.AddWithValue("@ManagerId", Convert.ToInt32(strManagerId)); } else { ObjCmd.Parameters.AddWithValue("@ManagerId", intManagerId); } ObjCmd.Parameters.AddWithValue("@DateOfJoining", DateTime.Parse(txtBoxDateOfJoining.Text)); ObjCmd.Parameters.AddWithValue("@EmploymentType", ddlEmploymentType.SelectedValue.ToString()); ObjCmd.Parameters.AddWithValue("@FathersName", txtBoxFathersName.Text); ObjCmd.Parameters.AddWithValue("@MothersName", txtBoxMothersName.Text); ObjCmd.Parameters.AddWithValue("@PanNumber", txtBoxPan.Text); ObjCmd.Parameters.AddWithValue("@AadhaarNumber", txtBoxAadhaar.Text); ObjCmd.Parameters.AddWithValue("@BankName", txtBoxBankName.Text); ObjCmd.Parameters.AddWithValue("@BankAccountNumber", txtBoxBankAccount.Text); ObjCmd.Parameters.AddWithValue("@BankIFSC", txtBoxBankIFSC.Text); ObjCmd.Parameters.AddWithValue("@EmploymentStatus", ddlEmploymentStatus.SelectedValue.ToString());//The first servie ID in services if (ddlEmploymentStatus.SelectedValue.ToString() == "ACTIVE") { txtBoxDateOfLeaving.Text = "01/01/3000"; } ObjCmd.Parameters.AddWithValue("@DateOfLeaving", DateTime.Parse(txtBoxDateOfLeaving.Text)); BD.UpdateParameters(ObjCmd); Response.Write("<script>alert('Member enrolled successfully')</script>"); //Refresh View Staff List to display newly added Staff. Response.Redirect("Staff.aspx"); //Display Staff count //send Welcome Message to Staff //if (strNotify == "YES") //{ // Connect EC = new Connect(); // string strSMSmessage = string.Format("Dear '{0}, Thanks for visiting Purple Salon N Academy !!!", strFirstName); // EC.SendSMS(strPhoneOne, strSMSmessage); // SentMsgLogger("SMS", strSMSmessage, strPhoneOne, strFirstName); //} }