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); } }