Пример #1
0
        private void CalculateGrossTotals()
        {
            Int32 SalBasic, SalHra, SalCca, SalConv, SalLta, SalSpec, SalUnif, SalVeh, SalChild, SalBnp, SalMed, SalPet, SalGross;

            SalBasic = SalHra = SalCca = SalConv = SalLta = SalSpec = SalUnif = SalVeh = SalChild = SalBnp = SalMed = SalPet = SalGross = 0;
            if (txtSalBasic.Text.Length > 0)
            {
                SalBasic = Convert.ToInt32(txtSalBasic.Text);
            }
            if (txtHRA.Text.Length > 0)
            {
                SalHra = Convert.ToInt32(txtHRA.Text);
            }
            if (txtCCA.Text.Length > 0)
            {
                SalCca = Convert.ToInt32(txtCCA.Text);
            }
            if (txtConve.Text.Length > 0)
            {
                SalConv = Convert.ToInt32(txtConve.Text);
            }
            if (txtLTA.Text.Length > 0)
            {
                SalLta = Convert.ToInt32(txtLTA.Text);
            }
            if (txtSpecial.Text.Length > 0)
            {
                SalSpec = Convert.ToInt32(txtSpecial.Text);
            }
            if (txtUniform.Text.Length > 0)
            {
                SalUnif = Convert.ToInt32(txtUniform.Text);
            }
            if (txtVehicle.Text.Length > 0)
            {
                SalVeh = Convert.ToInt32(txtVehicle.Text);
            }
            if (txtChild.Text.Length > 0)
            {
                SalChild = Convert.ToInt32(txtChild.Text);
            }
            if (txtBNP.Text.Length > 0)
            {
                SalBnp = Convert.ToInt32(txtBNP.Text);
            }
            if (txtMED.Text.Length > 0)
            {
                SalMed = Convert.ToInt32(txtMED.Text);
            }
            if (txtPET.Text.Length > 0)
            {
                SalPet = Convert.ToInt32(txtPET.Text);
            }
            SalGross        = Convert.ToInt32(SalBasic + SalHra + SalCca + SalConv + SalLta + SalSpec + SalUnif + SalVeh + SalChild + SalBnp + SalMed + SalPet);
            txtGrosSal.Text = SalGross.ToString("0");
        }
Пример #2
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            int ival = 0;

            objDb = new SQLDB();
            string strCommand = "";

            if (CheckData())
            {
                Int32 SalBasic, SalHra, SalCca, SalConv, SalLta, SalSpec, SalUnif, SalVeh, SalChild, SalBnp, SalMed, SalPet, SalGross;
                SalBasic = SalHra = SalCca = SalConv = SalLta = SalSpec = SalUnif = SalVeh = SalChild = SalBnp = SalMed = SalPet = SalGross = 0;
                if (txtSalBasic.Text.Length > 0)
                {
                    SalBasic = Convert.ToInt32(txtSalBasic.Text);
                }
                if (txtHRA.Text.Length > 0)
                {
                    SalHra = Convert.ToInt32(txtHRA.Text);
                }
                if (txtCCA.Text.Length > 0)
                {
                    SalCca = Convert.ToInt32(txtCCA.Text);
                }
                if (txtConve.Text.Length > 0)
                {
                    SalConv = Convert.ToInt32(txtConve.Text);
                }
                if (txtLTA.Text.Length > 0)
                {
                    SalLta = Convert.ToInt32(txtLTA.Text);
                }
                if (txtSpecial.Text.Length > 0)
                {
                    SalSpec = Convert.ToInt32(txtSpecial.Text);
                }
                if (txtUniform.Text.Length > 0)
                {
                    SalUnif = Convert.ToInt32(txtUniform.Text);
                }
                if (txtVehicle.Text.Length > 0)
                {
                    SalVeh = Convert.ToInt32(txtVehicle.Text);
                }
                if (txtChild.Text.Length > 0)
                {
                    SalChild = Convert.ToInt32(txtChild.Text);
                }
                if (txtBNP.Text.Length > 0)
                {
                    SalBnp = Convert.ToInt32(txtBNP.Text);
                }
                if (txtMED.Text.Length > 0)
                {
                    SalMed = Convert.ToInt32(txtMED.Text);
                }
                if (txtPET.Text.Length > 0)
                {
                    SalPet = Convert.ToInt32(txtPET.Text);
                }
                SalGross        = Convert.ToInt32(SalBasic + SalHra + SalCca + SalConv + SalLta + SalSpec + SalUnif + SalVeh + SalChild + SalBnp + SalMed + SalPet);
                txtGrosSal.Text = SalGross.ToString("0");

                if (txtGrosSal.Text != "0")
                {
                    try
                    {
                        if (flage == true)
                        {
                            strCommand = "UPDATE HR_SAL_STRU_MASTER SET HSSM_SALSTRU_TYPE='" + cbSalStructType.Tag.ToString() +
                                         "',HSSM_SALSTRU_CODE='" + txtSalStructCode.Text +
                                         "',HSSM_EFFECTED_FROM ='" + Convert.ToDateTime(dtpSalStructFrom.Value).ToString("dd/MMM/yyyy") +
                                         //"',HSSM_EFFECTED_TO='" + Convert.ToDateTime(dtpSalStructTo.Value).ToString("dd/MMM/yyyy") +
                                         "',HSSM_SALSTRU_STATUS='y',HSSM_BASIC=" + SalBasic +
                                         ",HSSM_HRA=" + SalHra +
                                         ",HSSM_CCA=" + SalCca +
                                         ",HSSM_CONV_ALW=" + SalConv +
                                         ",HSSM_LTA_ALW=" + SalLta +
                                         ",HSSM_SPL_ALW=" + SalSpec +
                                         ",HSSM_UNF_ALW=" + SalUnif +
                                         ",HSSM_VEH_ALW=" + SalVeh +
                                         ",HSSM_CH_ED_ALW=" + SalChild +
                                         ",HSSM_BNP_ALW=" + SalBnp +
                                         ",HSSM_MED_REIMB=" + SalMed +
                                         ",HSSM_PET_ALW=" + SalPet +
                                         ",HSSM_GROSS=" + Convert.ToInt32(txtGrosSal.Text) +
                                         ",HSSM_MODIFIED_BY='" + CommonData.LogUserId +
                                         "',HSSM_MODIFIED_DATE=getdate()" +
                                         " WHERE HSSM_SALSTRU_CODE='" + txtSalStructCode.Text + "'";

                            if (cbSalStructType.SelectedIndex == 2)
                            {
                                strCommand += "UPDATE HR_SAL_STRU_MASTER SET HSSM_DESG_CODE=" + Convert.ToInt32(CbDesig.SelectedValue) +
                                              " WHERE HSSM_SALSTRU_CODE='" + txtSalStructCode.Text + "'";
                            }
                        }
                        else if (flage == false)
                        {
                            strCommand = "INSERT INTO HR_SAL_STRU_MASTER(HSSM_SALSTRU_TYPE" +
                                         ",HSSM_SALSTRU_CODE" +
                                         ",HSSM_EFFECTED_FROM" +
                                         ",HSSM_SALSTRU_STATUS" +
                                         ",HSSM_BASIC" +
                                         ",HSSM_HRA" +
                                         ",HSSM_CCA" +
                                         ",HSSM_CONV_ALW" +
                                         ",HSSM_LTA_ALW" +
                                         ",HSSM_SPL_ALW" +
                                         ",HSSM_UNF_ALW" +
                                         ",HSSM_VEH_ALW" +
                                         ",HSSM_CH_ED_ALW" +
                                         ",HSSM_BNP_ALW" +
                                         ",HSSM_MED_REIMB" +
                                         ",HSSM_PET_ALW" +
                                         ",HSSM_GROSS ";
                            if (cbSalStructType.Text.Equals("DESIGNATION"))
                            {
                                strCommand += ",HSSM_DESG_CODE";
                            }

                            strCommand += ",HSSM_CREATED_BY,HSSM_CREATED_DATE)VALUES('" + cbSalStructType.Tag.ToString() +
                                          "','" + txtSalStructCode.Text +
                                          "','" + Convert.ToDateTime(dtpSalStructFrom.Value).ToString("dd/MMM/yyyy") +
                                          "','Y'," + SalBasic +
                                          "," + SalHra +
                                          "," + SalCca +
                                          "," + SalConv +
                                          "," + SalLta +
                                          "," + SalSpec +
                                          "," + SalUnif +
                                          "," + SalVeh +
                                          "," + SalChild +
                                          "," + SalBnp +
                                          "," + SalMed +
                                          "," + SalPet +
                                          "," + Convert.ToInt32(txtGrosSal.Text) + " ";
                            if (cbSalStructType.Text.Equals("DESIGNATION"))
                            {
                                strCommand += "," + Convert.ToInt32(CbDesig.SelectedValue) + " ";
                            }
                            strCommand += ",'" + CommonData.LogUserId + "',getdate())";
                        }

                        if (strCommand.Length > 10)
                        {
                            ival = objDb.ExecuteSaveData(strCommand);
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.ToString());
                    }

                    if (ival > 0)
                    {
                        MessageBox.Show("Data Saved Successfully", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Information);

                        btnClear_Click(null, null);
                        flage = false;
                    }
                    else
                    {
                        MessageBox.Show("Data Not Saved ", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
            }
        }