public StringModel ToStringModel <BLModel, StringModel>()
{
Mapper.CreateMap <OpenPurchaseOrders, StringOpenPurchaseOrders>()
.ForAllMembers(item => item.ToString().CutDownTo(50));
var stringModel = Mapper.Map <OpenPurchaseOrders, StringOpenPurchaseOrders>(this);
stringModel.RowTransactionType = RowTransactionType.CutDownTo(1);
stringModel.ExtractionDate = ExtractionDate.DateTimeToString();
stringModel.OrderDate = OrderDate.DateToString();
stringModel.RequestedDate = RequestedDate.DateToString();
stringModel.ReceivedDate = ReceivedDate.DateToString();
stringModel.FreeText1 = FreeText1.CutDownTo(100);
stringModel.FreeText2 = FreeText2.CutDownTo(100);
stringModel.FreeText3 = FreeText3.CutDownTo(100);
stringModel.FreeText4 = FreeText4.CutDownTo(100);
Mapper.CreateMap <StringDealerPartsMaster, StringModel>();
var stringModelRet = Mapper.Map <StringOpenPurchaseOrders, StringModel>(stringModel);
return(stringModelRet);
}
public override string ToString()
{
return($"=======MAILITEM=======\n" +
$"Entry ID: {EntryID}\n" +
$"Folder Entry ID: {FolderEntryID}\n" +
$"Folder Name: {FolderPath}\n" +
$"Subject: {Subject}\n" +
$"Received Date: {ReceivedDate.ToString("dd/MM/yyyy hh:mm:ss")}\n" +
$"From: {From}\n" +
$"To: {To}\n" +
$"CC: {CC}\n" +
$"======================\n");
}
public T ReadValue <T> ()
{
if (typeof(T).Equals(typeof(byte)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadByte(), typeof(T)));
}
else if (typeof(T).Equals(typeof(int)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadInt(), typeof(T)));
}
else if (typeof(T).Equals(typeof(float)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadFloat(), typeof(T)));
}
else if (typeof(T).Equals(typeof(long)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadLong(), typeof(T)));
}
else if (typeof(T).Equals(typeof(bool)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadBool(), typeof(T)));
}
else if (typeof(T).Equals(typeof(short)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadShort(), typeof(T)));
}
else if (typeof(T).Equals(typeof(string)))
{
int length = ReadValue <int>();
return((T)System.Convert.ChangeType(ReceivedDate.ReadString(length), typeof(T)));
}
else if (typeof(T).Equals(typeof(MNT_NetworkPackage)))
{
byte[] bytes = ReadArray <byte>();
MNT_NetworkPackage pack = new MNT_NetworkPackage(bytes);
return((T)System.Convert.ChangeType(pack, typeof(T)));
}
else if (typeof(T).Equals(typeof(Vector3)))
{
Vector3 vect = new Vector3();
vect.x = ReadValue <float>();
vect.y = ReadValue <float>();
vect.z = ReadValue <float>();
return((T)System.Convert.ChangeType(vect, typeof(T)));
}
else
{
return(default(T));
}
}
private void writeToProposalOpening()
{
Dictionary <string, string> fields = new Dictionary <string, string>();
fields["<Bid Number>"] = BidNumber;
fields["<Project Name>"] = ProjectName;
fields["<Location>"] = Location;
fields["<Salesperson>"] = Salesperson;
fields["<Estimator>"] = Estimator;
fields["<DateReceived>"] = ReceivedDate.ToShortDateString();
fields["<DateDue>"] = DueDate.ToShortDateString();
fields["<RequestedBy>"] = RequestedBy;
using (WordprocessingDocument doc =
WordprocessingDocument.Open(BidFolder + @"\Proposal Opening Form.docx", true))
{
var body = doc.MainDocumentPart.Document.Body;
Table table = body.Elements <Table>().First();
foreach (TableRow row in table.Elements <TableRow>())
{
foreach (TableCell cell in row.Elements <TableCell>())
{
foreach (var para in cell.Elements <Paragraph>())
{
foreach (var run in para.Elements <Run>())
{
foreach (var text in run.Elements <Text>())
{
foreach (string key in fields.Keys)
{
if (text.Text.Contains(key))
{
text.Text = text.Text.Replace(key, fields[key]);
}
}
}
}
}
}
}
}
}
//--------------------------------------
// PUBLIC METHODS
//--------------------------------------
public T ReadValue <T> ()
{
if (typeof(T).Equals(typeof(byte)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadByte(), typeof(T)));
}
else if (typeof(T).Equals(typeof(int)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadInt(), typeof(T)));
}
else if (typeof(T).Equals(typeof(float)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadFloat(), typeof(T)));
}
else if (typeof(T).Equals(typeof(long)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadLong(), typeof(T)));
}
else if (typeof(T).Equals(typeof(bool)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadBool(), typeof(T)));
}
else if (typeof(T).Equals(typeof(short)))
{
return((T)System.Convert.ChangeType(ReceivedDate.ReadShort(), typeof(T)));
}
else if (typeof(T).Equals(typeof(string)))
{
int length = ReadValue <int>();
return((T)System.Convert.ChangeType(ReceivedDate.ReadString(length), typeof(T)));
}
else
{
return(default(T));
}
}
public bool SaveReceivedDate(int userID, int employeeID)
{
QueryOutput queryResult;
var query = String.Format("update Warranty set ReceivedDate = {0} where ID = {1}", ReceivedDate.DbValue(), ID);
Execute(new DbQuery(userID, employeeID, DbAction.Warranty.Modify, query, true, ID), out queryResult);
return(queryResult == QueryOutput.Success);
}
public Warranty Save(ModelStateDictionary modelState, int userID, int employeeID, int bussinessID, string employeeName = null)
{
QueryOutput queryResult;
if (!Validate(modelState))
{
Result = false;
return(null);
}
var query = "";
var action = "";
var id = ID.ToString();
if (ID > 0)
{
query = String.Format(
@"update Warranty
set TransferDate = {1}, ReceivedDate = {2}, ProcessedDate = {3}, ReturnedDate = {4}, FinishDate = {5}, Service = N'{13}',
ProductState = N'{6}', Fee = {7}, Discount = {8}, Other = N'{9}', Note = N'{10}', ContactName = N'{11}', ContactPhone = N'{12}'
where ID = {0}",
new object[] {
ID, TransferDate.DbValue(), ReceivedDate.DbValue(), ProcessedDate.DbValue(), ReturnedDate.DbValue(),
FinishDate.DbValue(), ProductState, Fee, Discount, Other, Note, ContactName, ContactPhone, Service
});
action = DbAction.Warranty.Modify;
}
else
{
Code = NewUniqueCode(userID, employeeID, bussinessID, "Warranty");
EmployeeID = employeeID;
BussinessID = bussinessID;
EmployeeName = employeeName;
SubmitDate = DateTime.Now;
var clientID = "@ClientID";
query = String.Format("declare {0} int = {1}", clientID, ClientID.DbValue());
if ((!ClientID.HasValue || ClientID <= 0) && !String.IsNullOrEmpty(ClientName))
{
query += String.Format(
@" declare @client table (ID int)
insert Client(BussinessID, Code, Name, Phone, Address, Point, Status)
output inserted.ID into @client
values ({0}, '{1}', N'{2}', '{3}', N'{4}', 0, 'active')
set {5} = (select top 1 ID from @client)",
bussinessID, String.IsNullOrEmpty(ClientCode) ? NewUniqueCode(userID, employeeID, bussinessID, "Client", 3, null) : ClientCode, ClientName, ClientPhone, ClientAddress, clientID);
}
query += String.Format(
@" declare @output table (ID int)
insert Warranty(BussinessID, EmployeeID, WarehouseID, ProductID, Code, SubmitDate, TransferDate, ReceivedDate, ProcessedDate, ReturnedDate, FinishDate,
ProductState, Fee, Discount, Other, Note, Status, ClientID, OrderID, OrderCode, ContactName, ContactPhone, ReceiveWarehouseID, Service)
output inserted.ID into @output
values ({0}, {1}, {2}, {3}, N'{4}', {5}, {6}, {7}, {8}, {9}, {10}, N'{11}', {12}, {13}, N'{14}', N'{15}', 'active', {16}, {17}, '{18}', N'{19}', N'{20}', {21}, N'{22}')",
new object[] {
BussinessID, EmployeeID, WarehouseID, ProductID, Code, SubmitDate.DbValue(), TransferDate.DbValue(), ReceivedDate.DbValue(),
ProcessedDate.DbValue(), ReturnedDate.DbValue(), FinishDate.DbValue(), ProductState, Fee, Discount, Other, Note,
clientID, OrderID.DbValue(), OrderCode, ContactName, ContactPhone, ReceiveWarehouseID, Service
});
id = "(select top 1 ID from @output)";
if (Transactions != null)
{
foreach (var tran in Transactions)
{
query += tran.AddTransactionQuery(employeeID, TransactionClass.Warranty, ref id);
}
}
action = DbAction.Warranty.Create;
}
query += String.Format(
@" select top 1 w.ID, w.BussinessID, w.EmployeeID, w.WarehouseID, w.ProductID, w.ClientID, w.OrderID, w.Code, w.Service,
w.SubmitDate, w.TransferDate, w.ReceivedDate, w.ProcessedDate, w.ReturnedDate, w.FinishDate, w.ProductState, w.Fee, w.Discount, w.Other, w.Note,
rwh.Name as [ReceiveWarehouseName], wh.Name as [WarehouseName], w.ContactName, w.ContactPhone, e.Name as [EmployeeName],
c.Name as [ClientName], c.Code as [ClientCode], c.Address as [ClientAddress], c.Phone as [ClientPhone],
case when w.OrderID is not null then o.Code else w.OrderCode end as [OrderCode], isnull(sum(t.Amount), 0) as [Paid]
from Warranty w
join Warehouse wh on w.WarehouseID = wh.ID and w.Status = 'active' and ((select Username from Login where ID = {1}) = 'admin' or wh.ID in (select WarehouseID from LoginWarehouse where LoginID = {1}))
join Warehouse rwh on w.ReceiveWarehouseID = rwh.ID
join Employee e on w.EmployeeID = e.ID
join Product p on p.ID = w.ProductID
left join Client c on w.ClientID = c.ID
left join [Order] o on w.OrderID = o.ID
left join Transactions t on w.ID = t.WarrantyID
where w.ID = {0} and w.Status = 'active'
group by w.ID, w.BussinessID, w.EmployeeID, w.WarehouseID, w.ProductID, w.ClientID, w.OrderID, w.Code, w.ContactName, w.ContactPhone,
w.SubmitDate, w.TransferDate, w.ReceivedDate, w.ProcessedDate, w.ReturnedDate, w.FinishDate, w.ProductState, w.Service,
w.Fee, w.Discount, w.Other, w.Note, wh.Name, rwh.Name, e.Name, c.Name, c.Code, c.Address, c.Phone, o.Code, w.OrderCode" , id, userID);
var record = Query <Warranty>(new DbQuery(userID, employeeID, action, query, true, id), out queryResult).FirstOrDefault();
if (Result = (queryResult == QueryOutput.Success))
{
Messages = new List <string>()
{
"Lưu thông tin thành công"
}
}
;
return(record);
}
private void metroButton1_Click(object sender, EventArgs e)
{
//variables;
string ProductName;
int ProductQuantity;
string SupplierName;
int ReceivedStatus;
decimal OrderCost;
string ReceivedDate;
string Received;
SqlConnection sqlcon = new SqlConnection(Globals_Class.ConnectionString);
sqlcon.Open();
string cmd = "Select ProductName, ProductQuantity, SupplierName, ReceivedStatus, OrderCost, ReceivedDate FROM ReceiveSupplierOrder";
SqlCommand sqlcom = new SqlCommand(cmd, sqlcon);
SqlDataReader reader;
reader = sqlcom.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
ProductName = (reader["ProductName"].ToString());
ProductQuantity = Convert.ToInt32((reader["ProductQuantity"]));
SupplierName = (reader["SupplierName"].ToString());
ReceivedStatus = Convert.ToInt32((reader["ReceivedStatus"]));
OrderCost = Convert.ToDecimal((reader["OrderCost"]));
ReceivedDate = (reader["ReceivedDate"].ToString());
if (ReceivedStatus == 1)
{
Received = "Yes";
}
else
{
Received = "No";
}
Details += "\n" + "Product Name:" + " " + ProductName + "\n" + "Quantity Ordered:" + " " + ProductQuantity.ToString() + "\n" + "Supplier Name:" + " " + SupplierName + "\n" + "Received Status:" + " " + Received + "\n" + "Order Cost:" + " " + OrderCost.ToString() + "\n" + "Received Date:" + " " + ReceivedDate.ToString() + "\n";
}
}
reader.Close();
sqlcon.Close();
documentWriter();
}
