Insert Function in ASP.NET

Question

Sir, I am getting an error in the Save function in asp.net:-

The code is being shown below. I put BreakPoint in customer Sp class and btnSave_click event.

None of the control holds NULL value during this function.


This is my form Page:-


There are two error getting.

1)




2)


here the Codes:-



1) SQL SP:-

ALTER PROCEDURE  CustomerAdd
@customerCode numeric(18,0),
 @firstName varchar(20),
  @lastName varchar(20),
  @Gender varchar(20),
  @Address varchar(20),
  @City varchar(20),
  @State varchar(20),
  @County varchar(20),
   @pinCode varchar(20),
    @mobileNo varchar(20) ,
    @Email varchar(20),
    @joinDate datetime,
    @userName varchar(20),
     @Password varchar(20)

AS
   
   
INSERT INTO tbl_Customer
  (customerCode, firstName, lastName, Gender, Address, City, State, County, pinCode, mobileNo, Email, joinDate, userName, Password)
VALUES  (@customerCode, @firstName, @lastName, @Gender, @Address, @City, @State, @County, @pinCode, @mobileNo, @Email, @joinDate, @userName, @Password)


2) Customer Info class:-


pPublic class CInfo
  {
  public decimal customerId
  {
  get;
  set;
  }
  public string customerCode
  {
  get;
  set;
  }
  public string firstName
  {
  get;
  set;
  }
  public string lastName
  {
  get;
  set;
  }
  public string Gender
  {
  get;
  set;
  }
  public string Address
  {
  get;
  set;
  }
  public string City
  {
  get;
  set;
  }
  public string State
  {
  get;
  set;
  }
  public string County
  {
  get;
  set;
  }
  public string pinCode
  {
  get;
  set;
  }
  public string mobileNo
  {
  get;
  set;
  }
  public string Email
  {
  get;
  set;
  }
  public DateTime joinDate
  {
  get;
  set;
  }
  public string userName
  {
  get;
  set;
  }
  public string Password
  {
  get;
  set;
  }
}


3) Customer SP class:-

public void CustomerAdd (CInfo InfoCustomer)
  {
  try
  {
  if (sqlCon.State == ConnectionState.Closed)
  {
  sqlCon.Open();
  }
  SqlCommand c = new SqlCommand("CustomerAdd", sqlCon);
  c.CommandType = CommandType.StoredProcedure;
  c.Parameters.Add("customerCode", SqlDbType.Decimal).Value = InfoCustomer.customerCode;
  c.Parameters.Add("firstName", SqlDbType.VarChar).Value = InfoCustomer.firstName;
  c.Parameters.Add("lastName", SqlDbType.VarChar).Value = InfoCustomer.lastName;
  c.Parameters.Add("Gender", SqlDbType.VarChar).Value = InfoCustomer.Gender;
  c.Parameters.Add("Address", SqlDbType.VarChar).Value = InfoCustomer.Address;
  c.Parameters.Add("City", SqlDbType.VarChar).Value = InfoCustomer.City;
  c.Parameters.Add("State", SqlDbType.VarChar).Value = InfoCustomer.State;
  c.Parameters.Add("Country", SqlDbType.VarChar).Value = InfoCustomer.County;
  c.Parameters.Add("pinCode", SqlDbType.VarChar).Value = InfoCustomer.pinCode;
  c.Parameters.Add("mobileNo", SqlDbType.VarChar).Value = InfoCustomer.mobileNo;
  c.Parameters.Add("Email", SqlDbType.VarChar).Value = InfoCustomer.Email;
  c.Parameters.Add("joinDate", SqlDbType.DateTime).Value = InfoCustomer.joinDate;
  c.Parameters.Add("userName", SqlDbType.VarChar).Value = InfoCustomer.userName;
  c.Parameters.Add("Password", SqlDbType.VarChar).Value = InfoCustomer.Password;
  int inCount = c.ExecuteNonQuery();
  if (inCount > 0)
  {
  MessageBox.Show("Saved Successfully");
  }
  }
  catch (Exception)
  {
  throw;
  }
  finally
  {
  sqlCon.Close();
  }
  }


4) And Finally, btnSave_Click Event:-


protected void btnSave_Click ( object sender , EventArgs e )
  {
  CSP sp = new CSP ( );
  CInfo Info = new CInfo ( );
  Info . customerCode = txtCustomerCode . Text;
  Info . firstName = txtFirstName . Text;
  Info . lastName = txtLastName . Text;
  Info . Gender = ddlGender . SelectedValue . ToString ( );
  Info . Address = txtAddress . Text;
  Info . City = txtCity . Text;
  Info . State = txtState . Text;
  Info . County = txtCountry . Text;
  Info . pinCode = txtPinCode . Text;
  Info . mobileNo = txtMobile . Text;
  Info . Email = txtEmail . Text;
  Info . joinDate = DateTime . Parse ( txtJoinDate . Text );
  Info . Password = txtPassword1 . Text;
  Info . userName = txtUserName1 . Text;
  sp . CustomerAdd ( Info );
  mvCustomer . ActiveViewIndex = 0;
  GridFill ( );
 
  }