public void addProduct(ProductModels product) { string cs = ConfigurationManager.ConnectionStrings["Con"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("addProduct", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramPrice = new SqlParameter(); paramPrice.ParameterName = "@Price"; paramPrice.Value = product.Price; cmd.Parameters.Add(paramPrice); SqlParameter paramColor = new SqlParameter(); paramColor.ParameterName = "@Color"; paramColor.Value = product.Color; cmd.Parameters.Add(paramColor); SqlParameter paramStorage = new SqlParameter(); paramStorage.ParameterName = "@Storage"; paramStorage.Value = product.Storage; cmd.Parameters.Add(paramStorage); SqlParameter paramProcessor = new SqlParameter(); paramProcessor.ParameterName = "@Processor"; paramProcessor.Value = product.Processor; cmd.Parameters.Add(paramProcessor); SqlParameter paramMemory = new SqlParameter(); paramMemory.ParameterName = "@Memory"; paramMemory.Value = product.Memory; cmd.Parameters.Add(paramMemory); SqlParameter paramDisplay = new SqlParameter(); paramDisplay.ParameterName = "@Display"; paramDisplay.Value = product.Display; cmd.Parameters.Add(paramDisplay); SqlParameter paramDetails = new SqlParameter(); paramDetails.ParameterName = "@Details"; paramDetails.Value = product.Details; cmd.Parameters.Add(paramDetails); SqlParameter paramBrandId = new SqlParameter(); paramBrandId.ParameterName = "@BrandId"; paramBrandId.Value = product.BrandId; cmd.Parameters.Add(paramBrandId); SqlParameter paramModelId = new SqlParameter(); paramModelId.ParameterName = "@ModelId"; paramModelId.Value = product.ModelId; cmd.Parameters.Add(paramModelId); SqlParameter paramCategoryId = new SqlParameter(); paramCategoryId.ParameterName = "@CategoryId"; paramCategoryId.Value = product.CategoryId; cmd.Parameters.Add(paramCategoryId); SqlParameter paramCreatedBy = new SqlParameter(); paramCreatedBy.ParameterName = "@CreatedBy"; paramCreatedBy.Value = product.CreatedBy; cmd.Parameters.Add(paramCreatedBy); SqlParameter paramCreatedDate = new SqlParameter(); paramCreatedDate.ParameterName = "@CreatedDate"; paramCreatedDate.Value = product.CreatedDate; cmd.Parameters.Add(paramCreatedDate); con.Open(); int Id = Convert.ToInt32(cmd.ExecuteScalar()); product.Id = Id; } }