textbox item not inserted in db

codebehind :

-----------------------------------------------------------------------

public void LoadSave()

{

string Filename = hdnImage.Value;

Employees obj = new Employees();

obj.EmployeeCode = txtCode.Text;

obj.EmployeeName = txtEmployeeName.Text;

obj.ShortName = txtShortName.Text;

obj.Address1 = txtAddress1.Text;

obj.Address2 = txtAddress2.Text;

obj.Address3 = txtAddress3.Text;

obj.StateName = txtStateName.Text;

obj.PIN = txtPIN.Text;

obj.Phone = txtPhone.Text;

obj.Mobile = txtMobile.Text;

obj.Email = txtEmail.Text;

obj.DesignationID = Convert.ToInt64(ddlDesignations.GetId);

obj.AccLedgerID = 1; //Convert.ToInt64(ddlAccLedger.GetID);

obj.Nationality = txtNationality.Text;

obj.Gender = ddlGender.SelectedValue;

obj.BloodGroup = txtBloodGroup.Text;

obj.PassportNo = txtPassportNo.Text;

obj.VisaDetails = txtVisa.Text;

try

{

obj.PassportExpDate = Convert.ToDateTime(txtPassportExpDate.Text, System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

obj.VisaExpDate = Convert.ToDateTime(txtVisaExpiryDate.Text, System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

obj.DOB = Convert.ToDateTime(txtDateOfBirth.Text, System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

obj.DOJ = Convert.ToDateTime(txtDateOfJoining.Text, System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

obj.ResignDate = Convert.ToDateTime(txtResignDate.Text, System.Globalization.CultureInfo.GetCultureInfo("en-US").DateTimeFormat);

}

catch (Exception ex)

{

}

obj.IsResign = ((chkIsResign.Checked) ? true : false);

obj.Qualification = txtQualification.Text;

obj.Notes = txtNotes.Text;

obj.Remarks = txtRemarks.Text;

//obj.EmpImage = Filename;

obj.IsActive = true;

obj.Probotion_Period1 = txtProbotionPeriod.Text;

obj.Temporary1 = Convert.ToBoolean(chkTemprory.Checked ? true : false);

obj.WageType = "Monthly";

int InsId = obj.Save();

}

-------------class files---------------------------

public int Save()

{

// Code Part 1:

//'***** Author: Shamsheer

//'***** Date : 10/08/2013

//'***** This function used to Save Record to table

try

{

object[,] ParmArray;

ParmArray = new object[,]

{

{"@BranchID",General.BRANCHID },

{"@EmployeeCode",EmployeeCode },

{"@EmployeeName",EmployeeName },

{"@ShortName" ,ShortName},

{"@Address1" ,Address1},

{"@Address2",Address2 },

{"@Address3", Address3},

{"@StateName",StateName },

{"@PIN",PIN },

{"@Phone",Phone },

{"@Mobile",Mobile},

{"@Email",Email },

{"@DesignationID",DesignationID} ,

{"@AccLedgerID",AccLedgerID},

{"@Nationality",Nationality},

{"@Gender",Gender},

{"@BloodGroup",BloodGroup},

{"@PassportNo",PassportNo},

{"@PassportExpDate",PassportExpDate},

{"@VisaDetails",VisaDetails},

{"@VisaExpDate", VisaExpDate},

{"@DOB",DOB},

{"@DOJ",DOJ},

{"@IsResign",IsResign},

{"@ResignDate",ResignDate},

{"@Qualification",Qualification},

{"@Notes",Notes},

{"@Remarks",Remarks},

{"@EmpImage",EmpImage},

{"@WindowsEmpImage",WindowsEmpImage},

{"@CreatedUserID",General.USERID},

{"@IsActive",IsActive},

{"@Probotion_Period",Probotion_Period1},

{"@Temporary",Temporary1},

{"@IsPurchaser",IsPurchaser},

{"@IsSalesMan",IsSalesMan},

{"@IsReciept",IsReceipt},

{"@WageType",WageType},

{"@WageAmt",WageAmt}

};

return Convert.ToInt32(DB.ExecuteScalar_SP("InsertEmployees", ParmArray));

}

catch (Exception ex)

{

return 0;

}

------------------------------storeprocedur-------------------------------------------

USE [Polosys_ERP]

/****** Object: StoredProcedure [dbo].[InsertEmployees] Script Date: 12/04/2013 10:46:17 ******/

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

-- =============================================

-- Author : MOHAMMED SHAMSHEER

-- Create date: 31/JUL/2013

-- Description: Return Values

--*** 0 if EmployeeName exists ELSE

-- ID on Save

-- =============================================

ALTER PROCEDURE [dbo].[InsertEmployees]

(

@BranchID int,

@EmployeeCode VARCHAR(50),

@EmployeeName VARCHAR(100),

@ShortName VARCHAR(20),

@Address1 VARCHAR(100),

@Address2 VARCHAR(100),

@Address3 VARCHAR(100),

@StateName VARCHAR(50),

@PIN VARCHAR(20),

@Phone VARCHAR(20),

@Mobile VARCHAR(20),

@Email VARCHAR(100),

@DesignationID BIGINT,

@AccLedgerID BIGINT,

@Nationality VARCHAR(50),

@Gender VARCHAR(1),

@BloodGroup VARCHAR(12),

@PassportNo VARCHAR(30),

@PassportExpDate DATETIME,

@VisaDetails varchar(50),

@VisaExpDate DATETIME,

@DOB DATETIME,

@DOJ DATETIME,

@IsResign BIT,

@ResignDate DATETIME,

@Qualification VARCHAR(50),

@Notes VARCHAR(100),

@Remarks VARCHAR(100),

@EmpImage VARCHAR(200),

@WindowsEmpImage VARBINARY(MAX),

@CreatedUserID BIGINT,

@IsActive BIT,

@Probotion_Period VARCHAR(15),

@Temporary BIT,

@IsPurchaser BIT,

@IsSalesMan BIT,

@IsReciept BIT,

@WageType varchar(20),

@WageAmt numeric(18,2)

)

DECLARE @id AS BIGINT

SELECT @id=ISNULL(MAX(EmployeeID),0)FROM Employees

SET @id=@id+1

-- check Employee name exist or not

-- if EmployeeName exist in the employee then return 0 else Perform Save and Return ID

DECLARE @CHECKEmployeeName AS VARCHAR(100)

SELECT @CHECKEmployeeName= EmployeeName FROM Employees WHERE (@EmployeeName=EmployeeName OR EmployeeCode=@EmployeeCode) AND BranchID=@BranchID

IF @CHECKEmployeeName=@EmployeeName

SELECT 0

ELSE

BEGIN

INSERT INTO Employees

(

EmployeeID,

BranchID,

EmployeeCode,

EmployeeName,

ShortName,

Address1,

Address2,

Address3,

StateName,

PIN,

Phone,

Mobile,

Email,

DesignationID,

AccLedgerID,

Nationality,

Gender,

BloodGroup,

PassportNo,

PassportExpDate,

VisaDetails,

VisaExpDate,

DOB,

DOJ,

IsResign,

ResignDate,

Qualification,

Notes,

Remarks,

EmpImage,

WindowsEmpImage,

CreatedUserID,

CreatedDate,

ModifiedUserID,

ModifiedDate,

IsActive,

Probotion_Period,

Temporary,

IsPurchaser,

IsSalesMan,

IsReciept,

WageType,

WageAmt

)

VALUES

(

@id,

@BranchID,

@EmployeeCode,

@EmployeeName,

@ShortName,

@Address1,

@Address2,

@Address3,

@StateName,

@PIN,

@Phone,

@Mobile,

@Email,

@DesignationID,

@AccLedgerID,

@Nationality,

@Gender,

@BloodGroup,

@PassportNo,

@PassportExpDate,

@VisaDetails,

@VisaExpDate,

@DOB,

@DOJ,

@IsResign,

@ResignDate,

@Qualification,

@Notes,

@Remarks,

@EmpImage,

@WindowsEmpImage,

@CreatedUserID,

getdate(),

@CreatedUserID,

getdate(),

@IsActive,

@Probotion_Period,

@Temporary,

@IsPurchaser,

@IsSalesMan,

@IsReciept,

@WageType,

@WageAmt

)

SELECT @id

END

--------------------------------------------------

error showing windowimage is not supplied :

i check for number of parameter,itspelling,itsformat every thing corrrect

i build class file also but again its not working any body have any idea..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

mohammed shamsheer12y ago
@windowsEmpImage=new Byte[0]; instead of i intialized @windowsEmpImage=null now it's working...it will help others...
mohammed shamsheer12y ago
We are developing project in windows and web in web i dont want but in windows it needed we both using sams db...so cannot do like that
Sanjeeb Lenka12y ago
As from your error msg it seems you are not passing WindowsImage parameter to procedure. plz check that in your save all the values are passed correctly and not null.

if you want to insert null if the value is not passed just mention it in Stored procedudre:

ALTER PROCEDURE [dbo].[InsertEmployees]
(

@WindowsEmpImage VARBINARY(MAX)=NULL

}