Showing posts with label phone number database management system. Show all posts
Showing posts with label phone number database management system. Show all posts

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);
    }
    }