protected virtual HospitalityExpense GetHospitalityExpenseFromreader(IDataReader reader)
{
EntityConverter <HospitalityExpense> hospitalityExpenseEntity = new EntityConverter <HospitalityExpense>();
HospitalityExpense hospitalityExpense = hospitalityExpenseEntity.Convert(reader);
return(hospitalityExpense);
}
public int InsertUpdateExpenseTracking(HospitalityExpense hospitalityExpense)
{
using (SqlConnection sqlConnection = new SqlConnection(this.ConnectionString))
{
sqlConnection.Open();
SqlCommand sqlCommand = new SqlCommand("[Job_InsertUpdateExpenseTracking]", sqlConnection);
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.AddWithValue("@Date", hospitalityExpense.ExpenseDate);
sqlCommand.Parameters.AddWithValue("@MerchantName", hospitalityExpense.MerchantName);
sqlCommand.Parameters.AddWithValue("@ExpenseTypeID", hospitalityExpense.ExpenseTypeID);
sqlCommand.Parameters.AddWithValue("@IsClientBillable", hospitalityExpense.IsClientBillable);
sqlCommand.Parameters.AddWithValue("@IsServiceCharges", hospitalityExpense.IsServiceCharges);
sqlCommand.Parameters.AddWithValue("@Comments", hospitalityExpense.Comments);
sqlCommand.Parameters.AddWithValue("@BillPercentage", hospitalityExpense.BillPercentage);
sqlCommand.Parameters.AddWithValue("@BillAmount", hospitalityExpense.BillAmount);
sqlCommand.Parameters.AddWithValue("@AmountChargeable", hospitalityExpense.AmountChargeable);
sqlCommand.Parameters.AddWithValue("@ServiceChargePercent", hospitalityExpense.ServiceChargePercent);
sqlCommand.Parameters.AddWithValue("@ServiceChargeAmount", hospitalityExpense.ServiceChargeAmount);
sqlCommand.Parameters.AddWithValue("@TotalExpenseAmount", hospitalityExpense.TotalExpenseAmount);
sqlCommand.Parameters.AddWithValue("@HospitalityExpenseID", hospitalityExpense.HospitalityExpenseID);
sqlCommand.Parameters.AddWithValue("@JobID", hospitalityExpense.JobID);
sqlCommand.Parameters.AddWithValue("@ExpenseTypeDescription", hospitalityExpense.ExpenseTypeDescription);
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@OutHospitalityExpenseId";
sqlParameter.SqlDbType = SqlDbType.Int;
sqlParameter.Size = 15;
sqlParameter.Direction = ParameterDirection.Output;
sqlCommand.Parameters.Add(sqlParameter);
int hospitalityExpenseId = 0;
ExecuteNonQuery(sqlCommand);
if (hospitalityExpense.HospitalityExpenseID != 0)
{
hospitalityExpenseId = hospitalityExpense.HospitalityExpenseID;
return(hospitalityExpenseId);
}
hospitalityExpenseId = Convert.ToInt32(sqlCommand.Parameters["@OutHospitalityExpenseId"].Value);
return(hospitalityExpenseId);
}
}
