public void SaveOrderContactDetails(SaveOrderContactDetailsRequest request)
{
Domain.OrderContact orderContact = new Domain.OrderContact()
{
ContactName = request.ContactName,
ContactNo = request.ContactNo,
ExtNo = request.ExtNo,
OrderId = request.OrderId
};
_staffOrderRepo.SaveOrderContactDetails(orderContact);
}
public GetListStaffOrdersForStaffMemberResponse GetStaffOrdersForStaffMember(GetStaffOrdersForStaffMemberRequest request)
{
var orders = _staffOrderRepo.GetOrdersForStaffMember(request.EmpNo);
List <GetStaffOrdersForStaffMemberResponse> list = new List <GetStaffOrdersForStaffMemberResponse>();
foreach (var item in orders)
{
var contactDetails = _staffOrderRepo.GetOrderContactDetails(item.OrderId);
if (contactDetails == null)
{
contactDetails = new Domain.OrderContact()
{
ContactName = String.Empty,
ContactNo = String.Empty,
OrderId = 0,
ExtNo = String.Empty
};
}
list.Add(new GetStaffOrdersForStaffMemberResponse()
{
OrderId = item.OrderId,
Dept = item.Dept,
Description = item.Description,
EmployeeNo = item.EmployeeNo,
Mailing = item.Mailing,
Month = item.Month,
OrderDate = item.OrderDate.ToString("yyyy/MM/dd"),
page = item.page,
OrderCode = item.OrdCode,
Price = item.Price,
Size = item.Size,
StatusID = item.StatusID,
ContactName = contactDetails.ContactName,
ContactNo = contactDetails.ContactNo,
ExtNo = contactDetails.ExtNo
});
}
GetListStaffOrdersForStaffMemberResponse response = new GetListStaffOrdersForStaffMemberResponse()
{
Responses = list
};
return(response);
}
public OrderContact GetOrderContactDetails(int ordNo)
{
IDbConnection conn = _connectionFactory.GetNewSqlConnectionWithLoginDetails(new SqlConnection(connection), String.Empty, String.Empty);
var sqlStr = "select StaffOrdNo as OrderId, " +
"ContactName, " +
"ContactNo, " +
"ExtNo" +
" from stoOrderContact " +
"where StaffOrdNo = @OrdNo ";
DynamicParameters param = new DynamicParameters();
param.Add("@OrdNo", ordNo, dbType: DbType.Int32, direction: ParameterDirection.Input);
Domain.OrderContact orderContact = conn.Query <Domain.OrderContact>(sqlStr, param, commandType: CommandType.Text).SingleOrDefault();
return(orderContact);
}
