con = new SqlConnection(ConfigurationManager.ConnectionStrings["amms"].ConnectionString);
cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "AddTempMember";
cmd.Parameters.AddWithValue("@ParentId", txtPlaceUnderID.Text.Trim());
cmd.Parameters.AddWithValue("@ThroughOverId", (txtSponsorID.Text.Trim() == "" ? null : txtSponsorID.Text.Trim()));
cmd.Parameters.AddWithValue("@Leg", rdolstNode.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue("@Title", ddlTitle.SelectedItem.Text.Trim());
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text.Trim());
cmd.Parameters.AddWithValue("@LastName", txtLastName.Text.Trim());
cmd.Parameters.AddWithValue("@Type", ddlFathersHusband.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue("@FathersName", txtFathersName.Text.Trim());
cmd.Parameters.AddWithValue("@MothersName", null);
cmd.Parameters.AddWithValue("@MaritalStatus", ddlMaritalStatus.SelectedItem.Text.Trim());
cmd.Parameters.AddWithValue("@Address", txtAddress.Text.Trim());
cmd.Parameters.AddWithValue("@City", txtCity.Text.Trim());
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Text.Trim());
cmd.Parameters.AddWithValue("@Country", txtCountry.Text.Trim());
cmd.Parameters.AddWithValue("@Pin", txtPinCode.Text.Trim());
cmd.Parameters.AddWithValue("@Std", txtStdCode.Text.Trim());
cmd.Parameters.AddWithValue("@Phone", txtPhone.Text.Trim());
cmd.Parameters.AddWithValue("@Mobile", txtMobile.Text.Trim());
cmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@LoginId", null);
cmd.Parameters.AddWithValue("@Password", null);
cmd.Parameters.AddWithValue("@DOB", (txtDOB.Text.Trim() == "" ? null : Convert.ToDateTime(txtDOB.Text.Trim()).ToString("MM/dd/yyyy")));
cmd.Parameters.AddWithValue("@Age", lblAge.Text.Trim());
cmd.Parameters.AddWithValue("@Sex", ddlGender.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue("@PAN", txtPanCardNo.Text.Trim());
cmd.Parameters.AddWithValue("@PinNo", null);
cmd.Parameters.AddWithValue("@NomineeName", txtNomineeName.Text.Trim());
cmd.Parameters.AddWithValue("@NomineeRelation", txtNomineeRelation.Text.Trim());
cmd.Parameters.AddWithValue("@NomineeDOB", (txtNomineeDOB.Text.Trim() == "" ? null : Convert.ToDateTime(txtNomineeDOB.Text.Trim()).ToString("MM/dd/yyyy")));
cmd.Parameters.AddWithValue("@ProductCode", ddlProduct.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue("@PaymentOption", null);
cmd.Parameters.AddWithValue("@PaymentMode", ddlPaymentMode.SelectedItem.Value.Trim());
cmd.Parameters.AddWithValue("@Amount", txtAmount.Text.Trim());
cmd.Parameters.AddWithValue("@AmountBalance", txtBalanceAmount.Text.Trim());
cmd.Parameters.AddWithValue("@BankName", txtBankName.Text.Trim());
cmd.Parameters.AddWithValue("@DDChequeNo", txtChequeDDNo.Text.Trim());
cmd.Parameters.AddWithValue("@DDChequeDate", (txtChequeDDDate.Text.Trim() == "" ? null : Convert.ToDateTime(txtChequeDDDate.Text.Trim()).ToString("MM/dd/yyyy")));
cmd.Parameters.AddWithValue("@Payable", txtPayble.Text.Trim());
cmd.Parameters.AddWithValue("@MemberAccNo", txtCBSacNo.Text.Trim());
cmd.Parameters.AddWithValue("@MemberBankName", txtMemberBankName.Text.Trim());
cmd.Parameters.AddWithValue("@MemberBranch", txtBankBranch.Text.Trim());
cmd.Parameters.AddWithValue("@DepotCode", (txtBranchCode.Text.Trim() == "" ? null : txtBranchCode.Text.Trim()));
cmd.Parameters.AddWithValue("@ReceiptNo", null);
cmd.Parameters.AddWithValue("@JoiningDate", (txtJoiningDate.Text.Trim() == "" ? null : Convert.ToDateTime(txtJoiningDate.Text.Trim()).ToString("MM/dd/yyyy")));
cmd.Parameters.AddWithValue("@CreatedBy", Convert.ToString(Session["UserId"]));
cmd.Parameters.AddWithValue("@MemId", 0).Direction = ParameterDirection.InputOutput;
cmd.Parameters.AddWithValue("@msg", 0).Direction = ParameterDirection.InputOutput;
cmd.ExecuteNonQuery();
con.Close();
And the Procedure is:
ALTER PROCEDURE [dbo].[AddTempMember](@ParentId int,@ThroughOverId int, @Leg VARCHAR(50),@Title varchar(50),@FirstName varchar(50),@LastName varchar(50), @Type varchar(50),@FathersName varchar(50),@MothersName varchar(50), @MaritalStatus varchar(50), @Address varchar(50), @City varchar(50), @State varchar(50),@Country varchar(50),@Pin varchar(50),@Std varchar(50),@Phone varchar(50),@Mobile varchar(50),@Email varchar(50),@LoginId varchar(50),@Password varchar(50),@DOB date,@Age VARCHAR(50),@Sex varchar(50),@PAN varchar(50),@NomineeName varchar(50),@NomineeRelation varchar(50),@NomineeDOB varchar(50),@ProductCode varchar(50),@PaymentOption varchar(50),@PaymentMode varchar(50),@Amount money,@AmountBalance money,@BankName varchar(50),@DDChequeNo varchar(50),@DDChequeDate date,@Payable varchar(50),@MemberAccNo varchar(50),@MemberBankName varchar(50),@MemberBranch varchar(50),@DepotCode varchar(50),@ReceiptNo varchar(50),@JoiningDate varchar(50),@CreatedBy varchar(50),@MemId int,@msg varchar(50))
AS BEGIN
INSERT INTO Members(ParentId, ThroughOverId,Leg,Title,FirstName,LastName,Type,FathersName,MothersName,MaritalStatus,Address ,City,State,Country,Pin,Std,Phone,Mobile,Email,LoginId,Password,DOB,Age,Sex,PAN,NomineeName,NomineeRelation,NomineeDOB,ProductCode,PaymentOption,PaymentMode,Amount,AmountBalance,BankName,DDChequeNo,DDChequeDate,Payable,MemberAccNo,MemberBankName,MemberBranch,DepotCode,ReceiptNo,JoiningDate,CreatedBy,MemId,msg)
values (@ParentId,@ThroughOverId,@Leg,@Title,@FirstName,@LastName,@Type,@FathersName,@MothersName,@MaritalStatus,@Address ,@City,@State ,@Country,@Pin,@Std,@Phone,@Mobile,@Email,@LoginId,@Password,@DOB,@Age,@Sex,@PAN,@NomineeName,@NomineeRelation,@NomineeDOB,@ProductCode,@PaymentOption,@PaymentMode,@Amount,@AmountBalance,@BankName,@DDChequeNo,@DDChequeDate,@Payable,@MemberAccNo,@MemberBankName,@MemberBranch,@DepotCode,@ReceiptNo,@JoiningDate,@CreatedBy,@MemId,@msg)
END