public static dbo_ReceiveDetailClass Select_Record(dbo_ReceiveDetailClass clsdbo_ReceiveDetailPara)
{
dbo_ReceiveDetailClass clsdbo_ReceiveDetail = new dbo_ReceiveDetailClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[ReceiveDetailSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Billing_Detail_ID", clsdbo_ReceiveDetailPara.Billing_Detail_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_ReceiveDetail.Receive_Detail_ID = reader["Receive_Detail_ID"] is DBNull ? null : reader["Receive_Detail_ID"].ToString();
clsdbo_ReceiveDetail.Billing_Detail_ID = reader["Billing_Detail_ID"] is DBNull ? null : reader["Billing_Detail_ID"].ToString();
clsdbo_ReceiveDetail.Material_No = reader["Material_No"] is DBNull ? null : reader["Material_No"].ToString();
clsdbo_ReceiveDetail.Qty = reader["Qty"] is DBNull ? null : (Int16?)reader["Qty"];
clsdbo_ReceiveDetail.UOM = reader["UOM"] is DBNull ? null : reader["UOM"].ToString();
clsdbo_ReceiveDetail.Net_Value = reader["Net_Value"] is DBNull ? null : (Decimal?)reader["Net_Value"];
clsdbo_ReceiveDetail.Vat = reader["Vat"] is DBNull ? null : (Decimal?)reader["Vat"];
clsdbo_ReceiveDetail.Total = reader["Total"] is DBNull ? null : (Decimal?)reader["Total"];
}
else
{
clsdbo_ReceiveDetail = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_ReceiveDetail);
}
finally
{
connection.Close();
}
return(clsdbo_ReceiveDetail);
}
public static bool Delete(dbo_ReceiveDetailClass clsdbo_ReceiveDetail)
{
SqlConnection connection = SAMDataClass.GetConnection();
string deleteProcedure = "[dbo].[ReceiveDetailDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_ReceiveDetail.Receive_Detail_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldReceive_Detail_ID", clsdbo_ReceiveDetail.Receive_Detail_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldReceive_Detail_ID", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Billing_Detail_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldBilling_Detail_ID", clsdbo_ReceiveDetail.Billing_Detail_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldBilling_Detail_ID", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Material_No != null)
{
deleteCommand.Parameters.AddWithValue("@OldMaterial_No", clsdbo_ReceiveDetail.Material_No);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldMaterial_No", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Qty.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldQty", clsdbo_ReceiveDetail.Qty);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldQty", DBNull.Value);
}
if (clsdbo_ReceiveDetail.UOM != null)
{
deleteCommand.Parameters.AddWithValue("@OldUOM", clsdbo_ReceiveDetail.UOM);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldUOM", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Net_Value.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldNet_Value", clsdbo_ReceiveDetail.Net_Value);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldNet_Value", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Vat.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldVat", clsdbo_ReceiveDetail.Vat);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldVat", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Total.HasValue == true)
{
deleteCommand.Parameters.AddWithValue("@OldTotal", clsdbo_ReceiveDetail.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();
}
}
public static bool Add(dbo_ReceiveDetailClass clsdbo_ReceiveDetail, String Created_By)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "ReceiveDetailInsert";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_ReceiveDetail.Receive_Detail_ID != null)
{
insertCommand.Parameters.AddWithValue("@Receive_Detail_ID", clsdbo_ReceiveDetail.Receive_Detail_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Receive_Detail_ID", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Billing_Detail_ID != null)
{
insertCommand.Parameters.AddWithValue("@Billing_Detail_ID", clsdbo_ReceiveDetail.Billing_Detail_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Billing_Detail_ID", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Material_No != null)
{
insertCommand.Parameters.AddWithValue("@Material_No", clsdbo_ReceiveDetail.Material_No);
}
else
{
insertCommand.Parameters.AddWithValue("@Material_No", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Qty.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Qty", clsdbo_ReceiveDetail.Qty);
}
else
{
insertCommand.Parameters.AddWithValue("@Qty", DBNull.Value);
}
if (clsdbo_ReceiveDetail.UOM != null)
{
insertCommand.Parameters.AddWithValue("@UOM", clsdbo_ReceiveDetail.UOM);
}
else
{
insertCommand.Parameters.AddWithValue("@UOM", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Net_Value.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Net_Value", clsdbo_ReceiveDetail.Net_Value);
}
else
{
insertCommand.Parameters.AddWithValue("@Net_Value", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Vat.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Vat", clsdbo_ReceiveDetail.Vat);
}
else
{
insertCommand.Parameters.AddWithValue("@Vat", DBNull.Value);
}
if (clsdbo_ReceiveDetail.Total.HasValue == true)
{
insertCommand.Parameters.AddWithValue("@Total", clsdbo_ReceiveDetail.Total);
}
else
{
insertCommand.Parameters.AddWithValue("@Total", DBNull.Value);
}
if (!string.IsNullOrEmpty(Created_By))
{
insertCommand.Parameters.AddWithValue("@Created_By", Created_By);
}
else
{
insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value);
}
insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
insertCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}