public static dbo_BillingDetailClass Select_Record(String Billing_Detail_ID) { dbo_BillingDetailClass clsdbo_BillingDetail = new dbo_BillingDetailClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[BillingDetailSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Billing_Detail_ID", Billing_Detail_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_BillingDetail.Billing_Detail_ID = reader["Billing_Detail_ID"] is DBNull ? null : reader["Billing_Detail_ID"].ToString(); clsdbo_BillingDetail.Billing_ID = reader["Billing_ID"] is DBNull ? null : reader["Billing_ID"].ToString(); clsdbo_BillingDetail.Item_Position = reader["Item_Position"] is DBNull ? null : reader["Item_Position"].ToString(); clsdbo_BillingDetail.Material_No = reader["Material_No"] is DBNull ? null : reader["Material_No"].ToString(); clsdbo_BillingDetail.Qty = reader["Qty"] is DBNull ? null : (Int16?)reader["Qty"]; clsdbo_BillingDetail.UOM = reader["UOM"] is DBNull ? null : reader["UOM"].ToString(); clsdbo_BillingDetail.Net_Value = reader["Net_Value"] is DBNull ? null : (Decimal?)reader["Net_Value"]; clsdbo_BillingDetail.Vat = reader["Vat"] is DBNull ? null : (Decimal?)reader["Vat"]; clsdbo_BillingDetail.Total = reader["Total"] is DBNull ? null : (Decimal?)reader["Total"]; } else { clsdbo_BillingDetail = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_BillingDetail); } finally { connection.Close(); } return(clsdbo_BillingDetail); }
public static bool Delete(dbo_BillingDetailClass clsdbo_BillingDetail) { SqlConnection connection = SAMDataClass.GetConnection(); string deleteProcedure = "[dbo].[BillingDetailDelete]"; SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection); deleteCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_BillingDetail.Billing_Detail_ID != null) { deleteCommand.Parameters.AddWithValue("@OldBilling_Detail_ID", clsdbo_BillingDetail.Billing_Detail_ID); } else { deleteCommand.Parameters.AddWithValue("@OldBilling_Detail_ID", DBNull.Value); } if (clsdbo_BillingDetail.Billing_ID != null) { deleteCommand.Parameters.AddWithValue("@OldBilling_ID", clsdbo_BillingDetail.Billing_ID); } else { deleteCommand.Parameters.AddWithValue("@OldBilling_ID", DBNull.Value); } if (clsdbo_BillingDetail.Item_Position != null) { deleteCommand.Parameters.AddWithValue("@OldItem_Position", clsdbo_BillingDetail.Item_Position); } else { deleteCommand.Parameters.AddWithValue("@OldItem_Position", DBNull.Value); } if (clsdbo_BillingDetail.Material_No != null) { deleteCommand.Parameters.AddWithValue("@OldMaterial_No", clsdbo_BillingDetail.Material_No); } else { deleteCommand.Parameters.AddWithValue("@OldMaterial_No", DBNull.Value); } if (clsdbo_BillingDetail.Qty.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldQty", clsdbo_BillingDetail.Qty); } else { deleteCommand.Parameters.AddWithValue("@OldQty", DBNull.Value); } if (clsdbo_BillingDetail.UOM != null) { deleteCommand.Parameters.AddWithValue("@OldUOM", clsdbo_BillingDetail.UOM); } else { deleteCommand.Parameters.AddWithValue("@OldUOM", DBNull.Value); } if (clsdbo_BillingDetail.Net_Value.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldNet_Value", clsdbo_BillingDetail.Net_Value); } else { deleteCommand.Parameters.AddWithValue("@OldNet_Value", DBNull.Value); } if (clsdbo_BillingDetail.Vat.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldVat", clsdbo_BillingDetail.Vat); } else { deleteCommand.Parameters.AddWithValue("@OldVat", DBNull.Value); } if (clsdbo_BillingDetail.Total.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldTotal", clsdbo_BillingDetail.Total); } else { deleteCommand.Parameters.AddWithValue("@OldTotal", DBNull.Value); } deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); deleteCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }