public IHttpActionResult PutTransaction_Type(string id, Transaction_Type transaction_Type)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != transaction_Type.ID)
{
return(BadRequest());
}
db.Entry(transaction_Type).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Transaction_TypeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostTransaction_Type(Transaction_Type transaction_Type)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Transaction_Type.Add(transaction_Type);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (Transaction_TypeExists(transaction_Type.ID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = transaction_Type.ID }, transaction_Type));
}
public Transaction CreateTransaction(Transaction_Type type, string documentID)
{
Transaction transation = new Transaction();
//get next document number
try
{
transation.DocumentNumber =
sopNumber.GetNextSopNumber((int)type, documentID,
connString).Trim();
//get school year
getSchoolYear();
transation.SYFrom = schoolyrfrom;
transation.SYTo = schoolyrto;
transation.TransactionType = type;
rollback = true;
}
catch (Exception ex)
{
log.Error(ex);
throw new Exception("Unable to create new transaction.");
}
return transation;
}
public Transaction CreateTransaction(Transaction_Type type, string documentID)
{
Transaction transation = new Transaction();
//get next document number
try
{
transation.DocumentNumber =
sopNumber.GetNextSopNumber((int)type, documentID,
connString).Trim();
//get school year
getSchoolYear();
transation.SYFrom = schoolyrfrom;
transation.SYTo = schoolyrto;
transation.TransactionType = type;
rollback = true;
}
catch (Exception ex)
{
log.Error(ex);
throw new Exception("Unable to create new transaction.");
}
return(transation);
}
public IHttpActionResult GetTransaction_Type(string id)
{
Transaction_Type transaction_Type = db.Transaction_Type.Find(id);
if (transaction_Type == null)
{
return(NotFound());
}
return(Ok(transaction_Type));
}
public Transaction GetTransaction(string transactionNo, Transaction_Type sopType)
{
Transaction transaction = null;
for (int i = 0; i <= List.Count - 1; i++)
{
if (GetTransaction(i).DocumentNumber == transactionNo
&& GetTransaction(i).TransactionType == sopType)
{
transaction = GetTransaction(i);
}
}
return transaction;
}
internal TransactionHandle(TransitionalPeriodTransactionMessContainer txManagerFacade, QueryExecutionEngine engine, GraphDatabaseQueryService queryService, TransactionRegistry registry, TransactionUriScheme uriScheme, bool implicitTransaction, LoginContext loginContext, long customTransactionTimeout, LogProvider logProvider)
{
this._txManagerFacade = txManagerFacade;
this._engine = engine;
this._queryService = queryService;
this._registry = registry;
this._uriScheme = uriScheme;
this._type = implicitTransaction ? Transaction_Type.@implicit : Transaction_Type.@explicit;
this._loginContext = loginContext;
this._customTransactionTimeout = customTransactionTimeout;
this._log = logProvider.getLog(this.GetType());
this._id = registry.Begin(this);
}
public Transaction GetTransaction(string transactionNo, Transaction_Type sopType)
{
Transaction transaction = null;
for (int i = 0; i <= List.Count - 1; i++)
{
if (GetTransaction(i).DocumentNumber == transactionNo &&
GetTransaction(i).TransactionType == sopType)
{
transaction = GetTransaction(i);
}
}
return(transaction);
}
public IHttpActionResult DeleteTransaction_Type(string id)
{
Transaction_Type transaction_Type = db.Transaction_Type.Find(id);
if (transaction_Type == null)
{
return(NotFound());
}
db.Transaction_Type.Remove(transaction_Type);
db.SaveChanges();
return(Ok(transaction_Type));
}
public void RollbackDocumentNumber(string assessmentNumber, Transaction_Type type, string documentID)
{
//buggy
bool result = true;
if (rollback)
{
try
{
result = sopNumber.RollBackSopNumber(assessmentNumber, (int)type,
documentID, connString);
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
}
}
public Items GetAssessmentItems(string assessmentNo
, Transaction_Type sopType)
{
Items items = new Items();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentItems", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@SOPType", (int)sopType));
comm.Parameters.Add(new SqlParameter("@Assessment_No", assessmentNo));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Item i = new Item();
i.ItemNo = dr["Item Number"].ToString();
i.ItemDescription = dr["Item Description"].ToString();
i.Qty = Convert.ToDecimal(dr["Quantity"].ToString());
i.Unitprice = Convert.ToDecimal(dr["Unit Price"].ToString());
i.ItemClass = dr["Item Class"].ToString();
i.Uofm = dr["U of M"].ToString();
i.MarkDown = Convert.ToDecimal(dr["Markdown"]);
items.Add(i);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return(items);
}
public Discounts GetAssessmentDiscountsByDocID(string transactionNo, Transaction_Type type)
{
Discounts discounts = new Discounts();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentDiscountsByDocID", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@Assessment_No", transactionNo));
comm.Parameters.Add(new SqlParameter("@SOPType", (int)type));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Discount d = new Discount();
d.DiscountID = dr["Discount ID"].ToString();
d.DiscountDescription = dr["Discount Description"].ToString();
d.Percent = decimal.Round(Convert.ToDecimal((dr["Percent"]).ToString()), 2);
d.DiscountType = (Discount_Type)Convert.ToInt32(dr["Discount Type"].ToString());
d.Amount = decimal.Round(Convert.ToDecimal((dr["Discount Amount"]).ToString()), 2);
d.ItemAppliedTo = dr["Applied To"].ToString();
d.Computed = true;
discounts.Add(d);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return(discounts);
}
public Schedule GetAssessmentSchedule(string assessmentNo, Transaction_Type sopType)
{
Schedule sked = new Schedule();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentScheduleByDocID", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@AssessmentNo", assessmentNo));
comm.Parameters.Add(new SqlParameter("@SOPType", (int)sopType));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Due due = new Due();
due.Date = Convert.ToDateTime(dr["Due Date"]);
due.Amount = Convert.ToDecimal(dr["Amount"]);
sked.Add(due);
}
}
}
}
catch (Exception ex)
{
sked = null;
log.Error(ex);
throw;
}
return(sked);
}
public Schedule GetAssessmentSchedule(string assessmentNo, Transaction_Type sopType)
{
Schedule sked = new Schedule();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentScheduleByDocID", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@AssessmentNo", assessmentNo));
comm.Parameters.Add(new SqlParameter("@SOPType", (int)sopType));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Due due = new Due();
due.Date = Convert.ToDateTime(dr["Due Date"]);
due.Amount = Convert.ToDecimal(dr["Amount"]);
sked.Add(due);
}
}
}
}
catch (Exception ex)
{
sked = null;
log.Error(ex);
throw;
}
return sked;
}
private void txtAssessmentNo_Enter(object sender, EventArgs e)
{
try
{
Transaction_Type doctype = Transaction_Type.Assessment;
tryRollback();
if (cboDoctype.Text.Equals(Enum.GetName(typeof(Transaction_Type), Transaction_Type.Assessment)))
{
doctype = Transaction_Type.Assessment;
documentID = config["Document_ID"].ToString();
}
else if (cboDoctype.Text.Equals(Enum.GetName(typeof(Transaction_Type), Transaction_Type.Drop)))
{
documentID = config["Document_ID_Return"].ToString();
doctype = Transaction_Type.Drop;
}
else if (cboDoctype.Text.Equals(Enum.GetName(typeof(Transaction_Type), Transaction_Type.Add)))
{
documentID = config["Document_ID_Invoice"].ToString();
doctype = Transaction_Type.Add;
}
transaction = TransactionAdapter.Instance.CreateTransaction(doctype, documentID);
txtAssessmentNo.Text = transaction.DocumentNumber;
transaction.TransactionType = doctype;
cboDoctype.Enabled = false;
}
catch (Exception ex)
{
log.Error(ex);
Prompt.ShowError(ex.Message);
}
}
public void RollbackDocumentNumber(string assessmentNumber, Transaction_Type type, string documentID)
{
//buggy
bool result = true;
if (rollback)
{
try
{
result = sopNumber.RollBackSopNumber(assessmentNumber, (int)type,
documentID, connString);
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
}
}
public Discounts GetAssessmentDiscountsByDocID(string assessmentNo, Transaction_Type type)
{
return(DiscountData.Instance.GetAssessmentDiscountsByDocID(assessmentNo, type));
}
public Schedule GetAssessmentSchedule(string assessmentNo, Transaction_Type sopType)
{
return(PlanData.Instance.GetAssessmentSchedule(assessmentNo, sopType));
}
public void RollbackDocumentNumber(string transactionNo, Transaction_Type type, string documentID)
{
TransactionData.Instance.RollbackDocumentNumber(transactionNo, type, documentID);
}
public Transaction CreateTransaction(Transaction_Type type, string documentID)
{
return TransactionData.Instance.CreateTransaction(type, documentID);
}
public Schedule GetAssessmentSchedule(string assessmentNo, Transaction_Type sopType)
{
return PlanData.Instance.GetAssessmentSchedule(assessmentNo, sopType);
}
public Items GetAssessmentItems(string assessmentNo, Transaction_Type sopType)
{
return ItemData.Instance.GetAssessmentItems(assessmentNo, sopType);
}
public void RollbackDocumentNumber(string transactionNo, Transaction_Type type, string documentID)
{
TransactionData.Instance.RollbackDocumentNumber(transactionNo, type, documentID);
}
public Transaction CreateTransaction(Transaction_Type type, string documentID)
{
return(TransactionData.Instance.CreateTransaction(type, documentID));
}
public Discounts GetAssessmentDiscountsByDocID(string transactionNo, Transaction_Type type)
{
Discounts discounts = new Discounts();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentDiscountsByDocID", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@Assessment_No", transactionNo));
comm.Parameters.Add(new SqlParameter("@SOPType", (int)type));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Discount d = new Discount();
d.DiscountID = dr["Discount ID"].ToString();
d.DiscountDescription = dr["Discount Description"].ToString();
d.Percent = decimal.Round(Convert.ToDecimal((dr["Percent"]).ToString()), 2);
d.DiscountType = (Discount_Type)Convert.ToInt32(dr["Discount Type"].ToString());
d.Amount = decimal.Round(Convert.ToDecimal((dr["Discount Amount"]).ToString()), 2);
d.ItemAppliedTo = dr["Applied To"].ToString();
d.Computed = true;
discounts.Add(d);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return discounts;
}
public virtual TransitionalTxManagementKernelTransaction NewTransaction(Transaction_Type type, LoginContext loginContext, long customTransactionTimeout)
{
return(new TransitionalTxManagementKernelTransaction(_db, type, loginContext, customTransactionTimeout, _txBridge));
}
public Discounts GetAssessmentDiscountsByDocID(string assessmentNo, Transaction_Type type)
{
return DiscountData.Instance.GetAssessmentDiscountsByDocID(assessmentNo, type);
}
public virtual TransactionalContext Create(HttpServletRequest request, GraphDatabaseQueryService service, Transaction_Type type, LoginContext loginContext, string query, IDictionary <string, object> queryParameters)
{
TransactionalContextFactory contextFactory = Neo4jTransactionalContextFactory.create(service, _locker);
ClientConnectionInfo clientConnection = HttpConnectionInfoFactory.create(request);
InternalTransaction transaction = service.BeginTransaction(type, loginContext);
return(contextFactory.NewContext(clientConnection, transaction, query, ValueUtils.asMapValue(queryParameters)));
}
public Items GetAssessmentItems(string assessmentNo, Transaction_Type sopType)
{
return(ItemData.Instance.GetAssessmentItems(assessmentNo, sopType));
}
public Items GetAssessmentItems(string assessmentNo
, Transaction_Type sopType)
{
Items items = new Items();
try
{
using (SqlConnection conn = new SqlConnection(connString))
using (SqlCommand comm = new SqlCommand("usp_GetAssessmentItems", conn))
{
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Clear();
comm.Parameters.Add(new SqlParameter("@SOPType", (int)sopType));
comm.Parameters.Add(new SqlParameter("@Assessment_No", assessmentNo));
conn.Open();
using (SqlDataReader dr = comm.ExecuteReader())
{
while (dr.Read())
{
Item i = new Item();
i.ItemNo = dr["Item Number"].ToString();
i.ItemDescription = dr["Item Description"].ToString();
i.Qty = Convert.ToDecimal(dr["Quantity"].ToString());
i.Unitprice = Convert.ToDecimal(dr["Unit Price"].ToString());
i.ItemClass = dr["Item Class"].ToString();
i.Uofm = dr["U of M"].ToString();
i.MarkDown = Convert.ToDecimal(dr["Markdown"]);
items.Add(i);
}
}
}
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
return items;
}
