예제 #1
0
        private int SaveLeave()
        {
            int             result    = 0;
            string          conStr    = ConfigurationManager.ConnectionStrings["EmployeeConnection"].ConnectionString;
            tblLeaveDetails tblLeaveD = new tblLeaveDetails();

            tblLeaveD.fldLeaveID   = EmployeeMGRConfig.ConvertDigits(ddlLeaveType.SelectedValue);
            tblLeaveD.fldDaysTaken = EmployeeMGRConfig.ConvertDigits(txtDaysTaken.Text);
            tblLeaveD.fldTakenDate = Convert.ToDateTime(txtDaysTaken.Text);
            tblLeaveD.fldNote      = txtNote.Text;
            using (SqlConnection con = new SqlConnection(conStr))
            {
                con.Open();
                string     SQL = "sp_Insert_LeaveDetails";
                SqlCommand CMD = new SqlCommand(SQL, con);
                CMD.CommandType = CommandType.StoredProcedure;

                CMD.Parameters.AddWithValue("@EmployerID", 1);
                CMD.Parameters.AddWithValue("@fldLeaveID", tblLeaveD.fldLeaveID);
                CMD.Parameters.AddWithValue("@fldDaysTaken", tblLeaveD.fldDaysTaken);
                CMD.Parameters.AddWithValue("@fldTakenDate", tblLeaveD.fldTakenDate);
                CMD.Parameters.AddWithValue("@fldNote", tblLeaveD.fldNote);


                result = CMD.ExecuteNonQuery();
                CMD.Connection.Close();
                CMD = null;
            }
            return(result);
        }
예제 #2
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            tblEmployee emp = new tblEmployee();

            emp.fldFirstName                = txtFirstName.Text.Trim();
            emp.fldMiddleName               = txtMiddleName.Text.Trim();
            emp.fldLastName                 = txtLastNameNepali.Text.Trim();
            emp.fldGender                   = GetSelectedRadioButton(rbnMale, rbnFemale, rbnOther).Text.Trim();
            emp.fldDob                      = Convert.ToDateTime(txtBirthDate.Text.Trim());
            emp.fldPhoneNo                  = txtPhone.Text.Trim();
            emp.fldMobileNo                 = txtMobile.Text.Trim();
            emp.fldFaxNo                    = txtFax.Text.Trim();
            emp.fldPersonalEmail            = txtPersonalEmail.Text.Trim();
            emp.fldOfficialEmail            = txtOfficialEmail.Text.Trim();
            emp.fldAddress                  = txtAddress.Text.Trim();
            emp.fldDistrict                 = txtAddress.Text.Trim();
            emp.fldCitizenshipNo            = txtCitizenshipNo.Text.Trim();
            emp.fldCitizenshipIssuedDate    = Convert.ToDateTime(txtCitizenshipIssuedDate.Text.Trim());
            emp.fldCitzenshipIssuedDistrict = txtCitizenshipIssuedDistrict.Text.Trim();
            emp.fldDateofJoin               = Convert.ToDateTime(txtJoinDate.Text.Trim());
            emp.fldDateofPermanent          = Convert.ToDateTime(txtPermanentDate.Text.Trim());
            emp.fldDateofRetirement         = Convert.ToDateTime(txtRetirementDate.Text.Trim());
            emp.fldMaritalStatus            = GetSelectedRadioButton(rbnMarried, rbnUnMarred).Text.Trim();
            emp.fldChildBoy                 = EmployeeMGRConfig.ConvertDigits(txtChildBoy.Text.Trim());
            emp.fldChildGirl                = EmployeeMGRConfig.ConvertDigits(txtChildGirl.Text.Trim());
            emp.fldPpPhoto                  = "Test";
            emp.fldCitizenshipCopy          = "Citizenship_Copy";
            emp.fldLeaveHome                = float.Parse(txtLeaveHome.Text.Trim());
            emp.fldLeaveSick                = float.Parse(txtSickLeave.Text.Trim());
            emp.fldIsActive                 = true;
            emp.fldCreatedBy                = txtCreatedBy.Text.Trim();
            emp.fldCreatedDate              = Convert.ToDateTime(txtCreatedDate.Text.Trim());
            emp.fldUpdatedBy                = txtUpdatedBy.Text.Trim();
            emp.fldUpdatedDate              = Convert.ToDateTime(txtUpdatedDate.Text.Trim());
            emp.fldDocument                 = txtDocument.Text.Trim();
            emp.fldNote                     = txtNote.Text.Trim();
            Console.WriteLine("Class Created Successfully");
        }