public DocumentCreatedEvent(DocumentId entityId, UserId userId, DocumentNumber number, Option <DocumentDescription> description,
DateTime timeStamp) : base(entityId.Value, timeStamp)
{
UserId = userId;
Number = number;
Description = description;
}
public IHttpActionResult PK9DataAdd([FromBody] ReceiptDataModel item)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = new DocumentNumber();
if (conn.OpenConnection())
{
try
{
string SQLString = @"INSERT INTO receiptdata(DocumentBookNumber, DocumentNumber, DocumentDate, PayerType,
PayerRunno, AsReceiptTo, AsReceiptToRemark,
ReceiptAmount, ReceiptPaytype, ReceiptDate, ReceiptBank, ReceiptBillNumber,
ReceiptChqBank, ReceiptChqNumber, ReceiptOther)
VALUES (@DocumentBookNumber, @DocumentNumber, @DocumentDate, @PayerType, @PayerRunno,
@AsReceiptTo, @AsReceiptToRemark, @ReceiptAmount,
@ReceiptPaytype, @ReceiptDate, @ReceiptBank, @ReceiptBillNumber, @ReceiptChqBank,
@ReceiptChqNumber, @ReceiptOther) ";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
docNum = utilLibs.GetDocumentNo("pk9");
qExe.Parameters.AddWithValue("@documentbooknumber", docNum.BookNo);
qExe.Parameters.AddWithValue("@documentnumber", docNum.DocumentNo);
qExe.Parameters.AddWithValue("@documentdate", Convert.ToDateTime(item.DocumentDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@PayerType", item.PayerType);
qExe.Parameters.AddWithValue("@PayerRunno", item.PayerRunno);
qExe.Parameters.AddWithValue("@AsReceiptTo", item.AsReceiptTo);
qExe.Parameters.AddWithValue("@AsReceiptToRemark", item.AsReceiptToRemark);
qExe.Parameters.AddWithValue("@ReceiptAmount", item.ReceiptAmount);
qExe.Parameters.AddWithValue("@ReceiptPaytype", item.ReceiptPayType);
qExe.Parameters.AddWithValue("@ReceiptDate", Convert.ToDateTime(item.ReceiptDate, new CultureInfo("en-US")));
qExe.Parameters.AddWithValue("@ReceiptBank", item.ReceiptBank);
qExe.Parameters.AddWithValue("@ReceiptBillNumber", item.ReceiptBillNumber);
qExe.Parameters.AddWithValue("@ReceiptChqBank", item.ReceiptChqBank);
qExe.Parameters.AddWithValue("@ReceiptChqNumber", item.ReceiptChqNumber);
qExe.Parameters.AddWithValue("@ReceiptOther", item.ReceiptOther);
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = returnid.ToString()
}));
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public void TestSubscriber()
{
var id = MemoId.New;
var docId = Guid.NewGuid().ToString();
var docNumber = new DocumentNumber("100");
var docAddress = new Address("12700", "Россия",
"Москва", "проспект Мира", "1");
var userId = "TestUser";
var fixture = new SubscriberFixture <MemoSigningSubscriber, MemoId, MemoUpdated>(this);
//BDD тест (сценарий)
fixture.For()
//Допустим (предусловия)
.GivenNothing()
//Когда (тестируемые действия)
.When(new MemoUpdated(id, new MemoDocument(docId, docNumber, docAddress)),
new EventMetadata {
UserId = userId
})
//Тогда (проверка результатов)
.ThenExpect <MemoId, SignMemo>(command =>
command.Id == id &&
command.UserId == userId);
}
public IHttpActionResult PutDocumentNumber(int id, DocumentNumber documentNumber)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != documentNumber.Id)
{
return(BadRequest());
}
db.Entry(documentNumber).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DocumentNumberExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void ทดสอบแก้ไขPK9()
{
PK9DataController service = new PK9DataController();
ReceiptDataModel item = new ReceiptDataModel();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = utilLibs.GetDocumentNo("pk9");
item.DocumentRunno = 4;
item.DocumentBookNumber = "1";
item.DocumentNumber = "AC0004";
item.DocumentDate = DateTime.Now;
item.PayerType = "1";
item.PayerRunno = 3;
item.AsReceiptTo = "ค่าบำรุงพรรคการเมืองรายปี";
item.AsReceiptToRemark = "";
item.ReceiptAmount = 6500;
item.ReceiptPayType = "";
item.ReceiptDate = DateTime.Now;
item.ReceiptBank = "";
item.ReceiptBillNumber = "";
item.ReceiptChqBank = "";
item.ReceiptChqNumber = "";
item.ReceiptOther = "";
var result = service.PK9DataEdit(item);
Assert.IsTrue(result != null);
}
partial void OnDocumentNumberChanged()
{
if (!string.IsNullOrEmpty(_DocumentNumber))
{
_DocumentNumber = DocumentNumber.TextEncode();
}
}
public void ทดสอบบันทึกเอกสารPK9()
{
PK9DataController service = new PK9DataController();
ReceiptDataModel item = new ReceiptDataModel();
UtilLibs utilLibs = new UtilLibs();
DocumentNumber docNum = utilLibs.GetDocumentNo("pk9");
item.DocumentBookNumber = docNum.BookNo;
item.DocumentNumber = docNum.DocumentNo;
item.DocumentDate = DateTime.Now;
item.PayerType = "2";
item.PayerRunno = 1;
item.AsReceiptTo = "ค่าจัดกิจกรรมระดมทุน";
item.AsReceiptToRemark = "";
item.ReceiptAmount = 1750;
item.ReceiptPayType = "";
item.ReceiptDate = DateTime.Now;
item.ReceiptBank = "";
item.ReceiptBillNumber = "";
item.ReceiptChqBank = "";
item.ReceiptChqNumber = "";
item.ReceiptOther = "";
var result = service.PK9DataAdd(item);
Assert.IsTrue(result != null);
}
public IHttpActionResult GetDocumentNumber(int id)
{
DocumentNumber documentNumber = db.DocumentNumbers.Find(id);
if (documentNumber == null)
{
return(NotFound());
}
return(Ok(documentNumber));
}
public IHttpActionResult PostDocumentNumber(DocumentNumber documentNumber)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.DocumentNumbers.Add(documentNumber);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = documentNumber.Id }, documentNumber));
}
public void TestDocumentIdentity()
{
DocumentNumber docNum = new DocumentNumber(
TestUtilities.TEST_DOC_NUM.ToCharArray());
DocumentIdentity id = new DocumentIdentity(docNum, 2012, 07);
String idStr = id.ToString();
Assert.AreEqual(TestUtilities.TEST_DOC_ID, idStr);
DocumentIdentity newId = DocumentIdentity.Parse(idStr);
Assert.AreEqual(newId, id);
}
public IHttpActionResult DeleteDocumentNumber(int id)
{
DocumentNumber documentNumber = db.DocumentNumbers.Find(id);
if (documentNumber == null)
{
return(NotFound());
}
db.DocumentNumbers.Remove(documentNumber);
db.SaveChanges();
return(Ok(documentNumber));
}
/// <summary>
/// Converts to string.
/// </summary>
/// <returns>
/// A <see cref = "string"/> that represents this instance.
/// </returns>
public override string ToString()
{
try
{
return(Verify.Element(DocumentNumber)
? DocumentNumber.GetValue()
: string.Empty);
}
catch (Exception ex)
{
Fail(ex);
return(string.Empty);
}
}
public void NormalizeValues()
{
CourtOrganizationId = CourtOrganizationId.EmptyToNull();
DocumentDirectionId = DocumentDirectionId.EmptyToNull();
DocumentKindId = DocumentKindId.EmptyToNull();
DocumentGroupId = DocumentGroupId.EmptyToNull();
DocumentTypeId = DocumentTypeId.EmptyToNull();
DocumentNumber = DocumentNumber.EmptyToNull();
DocumentYear = DocumentYear.EmptyToNull();
DateTo = DateTo.MakeEndDate();
PersonName = PersonName.EmptyToNull();
PersonUIC = PersonUIC.EmptyToNull();
PersonRoleId = PersonRoleId.EmptyToNull();
}
public override int GetHashCode()
{
unchecked {
const int randomPrime = 397;
int hashCode = Id.GetHashCode();
hashCode = (hashCode * randomPrime) ^ ArchiveId.GetHashCode();
hashCode = (hashCode * randomPrime) ^ (FondNumber != null ? FondNumber.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (FondName != null ? FondName.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (InventoryNumber != null ? InventoryNumber.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ DocumentNumber.GetHashCode();
hashCode = (hashCode * randomPrime) ^ (TimeInterval != null ? TimeInterval.GetHashCode() : 0);
hashCode = (hashCode * randomPrime) ^ (Language != null ? Language.GetHashCode() : 0);
return(hashCode);
}
}
public void UpdateMemoTest()
{
//Создаем заготовку для теста
var fixture = new AggregateFixture <MemoId, MemoAggregate, IMemoState, MemoState>(this);
var id = MemoId.New;
//Параметры документа
var docId = Guid.NewGuid().ToString();
var docNumber = new DocumentNumber("100");
var docAddress = new Address("12700", "Россия",
"Москва", "проспект Мира", "1");
//BDD тест (сценарий)
fixture.For(id)
//Допустим (предусловия)
.GivenNothing()
//Когда (тестируемые действия)
.When(new UpdateMemo(id,
new MemoDocument(docId, docNumber, docAddress)))
//Тогда (проверка результатов)
.ThenExpectResult(e => e.IsSuccess)
.ThenExpectDomainEvent <MemoUpdated>(e
=> e.AggregateEvent.Id == id &&
e.AggregateEvent.Document != null &&
e.AggregateEvent.Document.Id == docId &&
e.AggregateEvent.Document.Number == docNumber &&
e.AggregateEvent.Document.CustomerAddress == docAddress)
.ThenExpectState(s
=> s.Status == MemoStatus.Undefined &&
s.Document != null &&
s.Document.Id == docId &&
s.Document.Number == docNumber &&
s.Document.CustomerAddress == docAddress);
}
public string GetInvoiceNumber(string code, int currentUserId)
{
DocumentNumber invoiceNumber = new DocumentNumber();
string invNumberStr = "";
string formatCurrentDate = DateTime.Now.ToString("ddMMyyyy");
invoiceNumber.Code = _context
.DocumentNumbers
.Where(u => u.Code == code)
.Select(u => u.Code)
.SingleOrDefault();
invoiceNumber.CurrentSequence = _context
.DocumentNumbers
.Where(u => u.Code == code)
.Select(u => u.CurrentSequence)
.SingleOrDefault();
invNumberStr = invoiceNumber.Code + "-" + formatCurrentDate + "-" + invoiceNumber.CurrentSequence.ToString();
UpdateDocSeqNumber(invoiceNumber.CurrentSequence, code, currentUserId);
return(invNumberStr);
}
public Order(DocumentNumber number)
{
_number = number;
_status = OrderStatus.New;
_created = Date.Today;
}
public void EnterDocumentNumber(string documentNumber)
{
DocumentNumber.SendKeys(documentNumber);
}
public bool Equals(DocumentNumber other)
{
return(string.Equals(_documentNumber, other._documentNumber));
}
public void NormalizeValues()
{
ResolutionNumber = ResolutionNumber.EmptyToNull();
DocumentNumber = DocumentNumber.EmptyToNull();
JudgeId = JudgeId.EmptyToNull().EmptyToNull(0);
}
private static Validation <Error, Document> CreateDocument(string number = "1234", string description = "Test")
{
return(DocumentNumber.Create(number)
.Bind(num => DocumentDescription.Create(description)
.Map(desc => new Document(new DocumentId(Guid.Empty), new UserId(Guid.Empty), num, desc))));
}
public Order(DocumentNumber number)
{
_number = number;
}
public DocumentMe(DocumentNumber documentNumber)
{
_state = new DocumentState();
Number = documentNumber;
}
public DocumentUpdatedEvent(DocumentId entityId, DocumentNumber number, Option <DocumentDescription> description,
DateTime timeStamp) : base(entityId.Value, timeStamp)
{
Number = number;
Description = description;
}
public IHttpActionResult GenDocumentPK11(string documentRunno)
{
DBConnector.DBConnector conn = new DBConnector.DBConnector();
UtilLibs utilLibs = new UtilLibs();
if (conn.OpenConnection())
{
try
{
string SQLString = @"select docs.*, dt.DonateAssetType
from donatedetaildata docs left join donatetype dt
on docs.DonateTypeRunno = dt.DonateTypeRunno
where DocumentRunno = @DocumentRunno
and dt.DonateAssetType = '1'
and (docs.DocRefNo is null or docs.DocRefNo = '')
order by docs.DetailRunno";
MySqlCommand qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("DocumentRunno", documentRunno);
MySqlDataReader detailReader = qExe.ExecuteReader();
bool CashType = false;
bool BillType = false;
bool ChqueType = false;
double DonateAmount = 0;
List <int> RunnoList = new List <int>();
while (detailReader.Read())
{
if (string.IsNullOrEmpty(detailReader["BankChqueNo"].ToString()) &&
string.IsNullOrEmpty(detailReader["Bill"].ToString()))
{
CashType = true;
}
else if (!string.IsNullOrEmpty(detailReader["BankChqueNo"].ToString()) &&
string.IsNullOrEmpty(detailReader["Bill"].ToString()))
{
ChqueType = true;
}
else if (string.IsNullOrEmpty(detailReader["BankChqueNo"].ToString()) &&
!string.IsNullOrEmpty(detailReader["Bill"].ToString()))
{
BillType = true;
}
DonateAmount = DonateAmount + double.Parse(detailReader["Amount"].ToString());
RunnoList.Add(int.Parse(detailReader["DetailRunno"].ToString()));
}
detailReader.Close();
if (CashType || ChqueType || BillType)
{
SQLString = @"select * from donatedata where DocumentRunno = @DocumentRunno";
qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("DocumentRunno", documentRunno);
detailReader = qExe.ExecuteReader();
DocumentNumber docNum = new DocumentNumber();
DateTime docDate = DateTime.Now;
int DonatorRunno = -1;
while (detailReader.Read())
{
DonatorRunno = int.Parse(detailReader["DonatorRunno"].ToString());
}
detailReader.Close();
if (DonateAmount > 0 && DonatorRunno != -1)
{
docNum = utilLibs.GetDocumentNo("pk11");
SQLString = @"INSERT INTO document11 (DocumentType, DocBookNo, DocNo,
DocDate, DonatorRunno, DonateAmount, CashFlag, BillFlag, ChqueFlag)
VALUES (@DocumentType, @DocBookNo, @DocNo, @DocDate, @DonatorRunno,
@DonateAmount, @CashFlag, @BillFlag, @ChqueFlag)";
qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
qExe.Parameters.AddWithValue("DocumentType", "PK11");
qExe.Parameters.AddWithValue("DocBookNo", docNum.BookNo);
qExe.Parameters.AddWithValue("DocNo", docNum.DocumentNo);
qExe.Parameters.AddWithValue("DocDate", docDate);
qExe.Parameters.AddWithValue("DonatorRunno", DonatorRunno);
qExe.Parameters.AddWithValue("DonateAmount", DonateAmount);
if (CashType)
{
qExe.Parameters.AddWithValue("CashFlag", "Y");
}
else
{
qExe.Parameters.AddWithValue("CashFlag", "N");
}
if (BillType)
{
qExe.Parameters.AddWithValue("BillFlag", "Y");
}
else
{
qExe.Parameters.AddWithValue("BillFlag", "N");
}
if (ChqueType)
{
qExe.Parameters.AddWithValue("ChqueFlag", "Y");
}
else
{
qExe.Parameters.AddWithValue("ChqueFlag", "N");
}
qExe.ExecuteNonQuery();
long returnid = qExe.LastInsertedId;
SQLString = @"update donatedetaildata set DocRefNo = @DocRefNo, DocRefBook = @DocRefBook, DocType = @DocType
where DetailRunno = @DetailRunno";
qExe = new MySqlCommand
{
Connection = conn.connection,
CommandText = SQLString
};
foreach (var runno in RunnoList)
{
qExe.Parameters.Clear();
qExe.Parameters.AddWithValue("DetailRunno", runno);
qExe.Parameters.AddWithValue("DocRefNo", docNum.DocumentNo);
qExe.Parameters.AddWithValue("DocRefBook", docNum.BookNo);
qExe.Parameters.AddWithValue("DocType", "PK11");
qExe.ExecuteNonQuery();
}
conn.CloseConnection();
return(Json(new ResultDataModel {
success = true, errorMessage = "", returnRunno = returnid.ToString()
}));
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "ข้อมูลไม่ถูกต้องไม่สามารถสร้างเอกสาร พ.ก. 11 ได้ หรือทำการสร้างเอกสารไปแล้ว", returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = true, errorMessage = "ไม่มีข้อมูลในประเภทเอกสาร พ.ก. 11 หรือทำการสร้างเอกสารไปแล้ว", returnRunno = ""
}));
}
}
catch (Exception e)
{
return(Json(new ResultDataModel {
success = false, errorMessage = e.Message, returnRunno = ""
}));
}
}
else
{
return(Json(new ResultDataModel {
success = false, errorMessage = "Database connect fail!", returnRunno = ""
}));
}
}
public static Validation <Error, DocumentUpdatedEvent> Create(Guid documentId, string number,
string description) =>
DocumentNumber.Create(number)
.Bind(num => DocumentDescription.Create(description)
.Map(desc => new DocumentUpdatedEvent(new DocumentId(documentId), num, desc, DateTime.UtcNow)));
