public bool InsertTScanLabel(string @Customer, string @Part_Id, string @Part_No, string @Part_Name, Decimal @Pack_Qty, string @Rank_No, string @Issue_No, string @Serial_No, string @Order_No, string @CreateBy, string @UNIQUEID, string RanNo = "", string @Label_Id = "") { bool success = true; int rownum = 0; try { BeginTransaction(); SqlComm.CommandType = CommandType.StoredProcedure; SqlComm.CommandText = "spInsTScanLabel"; SqlComm.Parameters.Clear(); SqlComm.Parameters.Add(new SqlParameter("@Customer", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Part_Id", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Part_No", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Part_Name", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Pack_Qty", SqlDbType.Decimal)); SqlComm.Parameters.Add(new SqlParameter("@Rank_No", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Issue_No", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Serial_No", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Order_No", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@CreateBy", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@UNIQUEID", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@RanNo", SqlDbType.VarChar)); SqlComm.Parameters.Add(new SqlParameter("@Label_Id", SqlDbType.VarChar)); SqlComm.Parameters["@Customer"].Value = @Customer; SqlComm.Parameters["@Part_Id"].Value = @Part_Id; SqlComm.Parameters["@Part_No"].Value = @Part_No; SqlComm.Parameters["@Part_Name"].Value = @Part_Name; SqlComm.Parameters["@Pack_Qty"].Value = @Pack_Qty; SqlComm.Parameters["@Rank_No"].Value = @Rank_No; SqlComm.Parameters["@Issue_No"].Value = @Issue_No; SqlComm.Parameters["@Serial_No"].Value = @Serial_No; SqlComm.Parameters["@Order_No"].Value = @Order_No; SqlComm.Parameters["@CreateBy"].Value = @CreateBy; SqlComm.Parameters["@UNIQUEID"].Value = @UNIQUEID; SqlComm.Parameters["@RanNo"].Value = @RanNo; SqlComm.Parameters["@Label_Id"].Value = @Label_Id; SqlComm.CommandTimeout = 0; rownum = SqlComm.ExecuteNonQuery(); success = (rownum > 0) ? true : false; if (success) { CommitTransaction(); } else { RollbackTrasaction(); } } catch (Exception ex) { success = false; RollbackTrasaction(); } finally { CloseConnection(); } return(success); }