Monday, July 30, 2018

how to create Employee management system asp & sql server | sradha webcreations


Employee management system asp & sql server





using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class OR_remunaretion : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    double dBasic;
    double dWash;
    double dMedical;
    double dOther;

    double dPBasic;
    double dPWash;
    double dPMedical;
    double dPOther;

       
    string sDay;
    double dPtotal;
    protected void DropDownListMONTH_SelectedIndexChanged(object sender, EventArgs e)
    {
        //string sMonth;
        string sDay;
        if (DropDownListMONTH.SelectedIndex == 2)
        {
            sDay = "28";
        }
        else if (DropDownListMONTH.SelectedIndex == 4 || DropDownListMONTH.SelectedIndex == 6 || DropDownListMONTH.SelectedIndex == 9 || DropDownListMONTH.SelectedIndex == 11)
        {
            sDay = "30";
        }
        else
        {
            sDay ="31";
        }
        TextBoxDAY.Text = Convert.ToString(sDay);
    }
 protected void TextBoxPIADdUTY_TextChanged(object sender, EventArgs e)
    {
     
        double dPaidDuibty;
     int  iDay = Convert.ToInt32(TextBoxDAY.Text);
        dPaidDuibty = Convert.ToDouble(TextBoxPIADdUTY.Text);
        dBasic = Convert.ToDouble(TextBoxBASIC.Text);
        dPBasic = dPaidDuibty * dBasic / iDay;
        TextBoxPBASIC.Text = Convert.ToString(dPBasic);
        dWash = Convert.ToDouble(TextBoxWASH.Text);
        dPWash = dPaidDuibty * dWash / iDay;
        TextBoxPWASH.Text = Convert.ToString(dPWash);
        dMedical = Convert.ToDouble(TextBoxMEDICAL.Text);
        dPMedical = dPaidDuibty * dMedical / iDay;
        TextBoxPMEDICAL.Text = Convert.ToString(dPMedical);
        dOther = Convert.ToDouble(TextBoxOTHER.Text);
        dPOther = dPaidDuibty * dOther / iDay;
        TextBoxPOTHER.Text = Convert.ToString(dPOther);   
        double dPtotal;
        dPtotal = dPBasic + dPWash + dPWash + dPMedical + dPOther;
        TextBoxPAYBLETOTAL.Text = Convert.ToString(dPtotal);
    }
    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {
        double dRemunaretion;
        dRemunaretion = Convert.ToDouble(TextBoxREMUNARETION.Text);
        double dTotal;
        dBasic = (dRemunaretion * 80 / 100);
        TextBoxBASIC.Text = Convert.ToString(dBasic);
        dWash = (dRemunaretion * 5 / 100);
        TextBoxWASH.Text = Convert.ToString(dWash);
        dMedical = (dRemunaretion * 5 / 100);
        TextBoxMEDICAL.Text = Convert.ToString(dMedical);
        dOther = (dRemunaretion * 10 / 100);
        TextBoxOTHER.Text = Convert.ToString(dOther);
        dTotal = dBasic + dWash + dMedical + dOther;
        TextBoxTOTAL.Text = Convert.ToString(dTotal);
    }

    protected void TextBoxTDS_TextChanged(object sender, EventArgs e)
    {
       
        double dPtotal=Convert.ToDouble(TextBoxPAYBLETOTAL.Text);
        double dTDS=Convert.ToDouble(TextBoxTDS.Text);
        double WF = 100;
        double dGrandTotal;
        dGrandTotal = dPtotal + WF + dTDS;
        TextBoxGRANDTOTAL.Text = Convert.ToString(dGrandTotal);
        TextBoxWF.Text = Convert.ToString(WF);
    }



}










Sunday, July 29, 2018

how to create hospital management system | sradha webcreations


hospital management system 


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;

public partial class IF_ELSE_AND_OR_HospitalChargesForEmployee : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void TextBoxEMPHospitalLeaveDate_TextChanged(object sender, EventArgs e)
    {
        string sEmployeeName = TextBoxEMPNAME.Text;
        string sEmployeeDesignation = TextBoxEMPDESIGNATION.Text;
        double dBasicSalary = Convert.ToDouble(TextBoxEMPSALARY.Text);

        string sEntryDate = TextBoxEMPHospitalEntryDate.Text;
        DateTime DE = Convert.ToDateTime(sEntryDate);

        string sLeaveDate = TextBoxEMPHospitalLeaveDate.Text;
        DateTime DL = Convert.ToDateTime(sLeaveDate);

        int iTotalDyInHospital;
        iTotalDyInHospital=((TimeSpan)(DL-DE)).Days;
        TextBoxDayInHospital.Text = Convert.ToString(iTotalDyInHospital);

        double dTotalCharge;

        string sAttandandt = DropDownListATTENDANDT.Text;

        if (dBasicSalary > 4000 && dBasicSalary < 2000)
        {
            if (sAttandandt == "YES")
            {
  dTotalCharge= (iTotalDyInHospital * 50) + (iTotalDyInHospital * 30);
            }
            else
            {
                dTotalCharge= (iTotalDyInHospital * 50);
            }
     TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);
        }

else if(dBasicSalary>4000 && dBasicSalary<6000)
{
    if(sAttandandt=="YES")
    {
    dTotalCharge=(iTotalDyInHospital*100)+(iTotalDyInHospital*30);
    }
    else
    {
        dTotalCharge=(iTotalDyInHospital*100);
    }
    TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);

}
        else if(dBasicSalary>6000 && dBasicSalary<8000)
        {
            if(sAttandandt=="YES")
            {
                dTotalCharge=(iTotalDyInHospital*150)+(iTotalDyInHospital*30);
            }
            else
            {
                dTotalCharge=(iTotalDyInHospital*150);
            }
    TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);
        }

        else if(dBasicSalary>8000 && dBasicSalary<10000)
        {
            if(sAttandandt=="YES")
            {
                dTotalCharge=(iTotalDyInHospital*200)+(iTotalDyInHospital*30);
            }
            else
            {
                dTotalCharge=(iTotalDyInHospital*200);
            }
    TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);
        }
           
        else if(dBasicSalary>1000)
        {
            if(sAttandandt=="YES")
            {
                dTotalCharge=(iTotalDyInHospital*250)+(iTotalDyInHospital*30);
            }
            else
            {
                dTotalCharge=iTotalDyInHospital*250;
            }

   TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);
        }
        //TextBoxHOSPITALCHARGE.Text = Convert.ToString(dTotalCharge);
    }


Saturday, July 28, 2018

how to create Phone call Database management system | sradha webcreations

Phone call Database management system in asp.net  Sql Server


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Security;

public partial class IF_ELSE_AND_OR_PhoneCallCalculation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void TextBox3_TextChanged(object sender, EventArgs e)
    {
        string sCustomerName = TextBoxCUSTOMERNAME.Text;
        string sPhoneNumber = TextBoxPHONENUMBER.Text;
        int iTotalCall =Convert.ToInt32( TextBoxTOTALCALL.Text);
       
        int iExtraCall;
        iExtraCall = iTotalCall - 200;

        int iExtraCall400;
        iExtraCall400=iTotalCall-400;

        int iExtraCall600;
        iExtraCall600=iTotalCall-600;

        double dCallCharge;
      
        if (iTotalCall <= 200)
        {
            dCallCharge = 200;
        }
        else if (iTotalCall > 200 && iTotalCall <= 400)
        {
            dCallCharge=200+(iExtraCall*1.50);
        }
        else if (iTotalCall > 400 && iTotalCall <= 600)
        {
            dCallCharge = 200 + (200 * 1.50) + (iExtraCall400 * 2.50);
        }
        else
        {
            dCallCharge=200+(200*1.50)+(200*2.50)+(iExtraCall600*3.50);

        }
        TextBoxCALLCHARGE.Text = Convert.ToString(dCallCharge);
    }
    }