public IHttpActionResult GetPriceBI(SearchMap searchDto)
{
var repos = new TDAssetRespository();
SetionType sectionT = new SetionType();
GetPriceBI resultList = new GetPriceBI();
List <string> data = null;
List <BarchartValue> value = null;
List <BarchartValue> value2 = null;
BarchartValue barValue = null;
var barchart = new Barchart();
int row = 0;
var estimateData = repos.GetPriceBI(searchDto);
resultList.EstimateData = estimateData.OrderByDescending(o => Converting.ToDecimal(o.ParcelWAHPriceMax))
.ThenBy(c => c.MarketWAHPriceMax).ThenBy(c => c.DisplayName).ToList();
if (estimateData != null)
{
data = new List <string>();
value = new List <BarchartValue>();
value2 = new List <BarchartValue>();
row = 0;
foreach (EstimateData result in estimateData.OrderByDescending(o => Converting.ToDecimal(o.ParcelWAHPriceMax))
.ThenBy(c => c.MarketWAHPriceMax).ThenBy(c => c.DisplayName))
{
if (row >= overMax)
{
break;
}
barValue = new BarchartValue();
barValue.name = result.DisplayName;
barValue.value = Converting.ToDecimal(result.ParcelWAHPriceMax);
barValue.key = result.DisplayCode;
value.Add(barValue);
barValue = new BarchartValue();
barValue.name = result.DisplayName;
barValue.value = Converting.ToDecimal(result.MarketWAHPriceMax);
barValue.key = result.DisplayCode;
value2.Add(barValue);
data.Add(result.DisplayName);
row++;
}
barchart.Data = data;
barchart.Value = value;
barchart.Value2 = value2;
}
resultList.Barchart = barchart;
return(Json(resultList));
}
public List <TblJobOrder> Gets(int page = 1, int size = 0
, string src = "", long id = 0)
{
var data = (from q in db.TblJobOrder select q)
/* .Include(x => x.AttachmentType.Where(o => o.JobOrderId == id))
* .Include(x => x.EquipmentType.Where(o => o.JobOrderId == id))
* .Include(x => x.LandType.Where(o => o.JobOrderId == id))
* .Include(x => x.ObstructionType.Where(o => o.JobOrderId == id))
* .Include(x => x.ProjectType.Where(o => o.JobOrderId == id))
* .Include(x => x.UndergroundType.Where(o => o.JobOrderId == id))*/
.AsQueryable();
data = Filter(data, src)
.OrderBy(x => x.JobName);
if (size > 0)
{
data = data.Skip((page - 1) * size).Take(size);
}
foreach (TblJobOrder job in data)
{
job.CreateDateToString = Converting.ToDDMMYYYY(job.CreatedDate);
job.SaleOrder = (from q in db.TblSaleOrder.Where(o => o.SaleOrderId == job.SaleOrderId).Include(o => o.Sale) select q).FirstOrDefault();
}
return(data.ToList());
}
public List <TblInvoice> GetList(long userId)
{
var data = (from i in db.TblInvoice.Where(o => o.CreatedBy == userId || userId == 0)
select new TblInvoice
{
InvoiceId = i.InvoiceId,
InvoiceNo = i.InvoiceNo,
InvoiceDate = i.InvoiceDate,
StrInvoiceDate = i.InvoiceDate != null ? Converting.ToDDMMYYYY(i.InvoiceDate) : "",
SaleOrderId = i.SaleOrderId,
InvoiceRemark = i.InvoiceRemark,
InvoiceTerm = i.InvoiceTerm,
InvoiceAmount = i.InvoiceAmount,
StatusId = i.StatusId,
CreatedBy = i.CreatedBy,
CreatedDate = i.CreatedDate,
UpdatedBy = i.UpdatedBy,
UpdatedDate = i.UpdatedDate,
DueDate = i.DueDate,
DepositAmount = i.DepositAmount,
IsDeposit = i.IsDeposit,
SaleOrder = null,
ConditionId = i.ConditionId,
CreatedByName = (from emp in db.SysAccount.Where(acc => acc.AccountId == i.CreatedBy) select emp.AccountName).FirstOrDefault()
});
return(data.ToList());
}
protected override void Received(byte[] data, int length)
{
try
{
buffer.Add(data[0]);
if (data[0] == 35 && buffer[buffer.Count - 2] == 35) //The last 2 bytes are '##'
{
//Take the header off then convert to byte array
byte[] body = new byte[buffer.Count];
buffer.CopyTo(0, body, 0, buffer.Count);
this.NotifySocketDataRecived(Converting.CopyBytes(0, body, body.Length));
//{
// string errorTelegram = string.Format("<{0}>", bodyLength.ToString());
// errorTelegram += System.Text.Encoding.ASCII.GetString(body);
// Core.Environment.Log.Write(string.Format("ATC Socket {0} Incorrect message length, message ignored: {1}", Name, errorTelegram));
//}
buffer.Clear();
}
this.Read(1);
}
catch
{
this.Disconnect(true);
}
}
public List <TransferHeader> GetList(string TransferType = "")
{
var data = (from d in db.TransferHeader.Where(o => o.TransferType == TransferType)
select new TransferHeader
{
TransferId = d.TransferId,
TransferNo = d.TransferNo,
TransferType = d.TransferType,
TransferDate = d.TransferDate,
StrTransferDate = "",
TransferTime = d.TransferTime,
JobOrderId = d.JobOrderId,
ReceiveTo = d.ReceiveTo,
Reason = d.Reason,
CarType = d.CarType,
Company = d.Company,
CarNo = d.CarNo,
CarBrand = d.CarBrand,
SendToDepartment = d.SendToDepartment,
Remark = d.Remark,
EmpId = d.EmpId,
BillNo = d.BillNo,
TransferStatus = d.TransferStatus,
StrTransferStatus = Converting.TransferStatus(d.TransferStatus.ToString()),
Note1 = d.Note1,
CreatedDate = d.CreatedDate,
UpdatedDate = d.UpdatedDate
});
return(data.ToList());
}
public object GetDefaultValue(Type type)
{
return(this.GetObjectContext("defaultValue", () => {
var value = this.GetSetting("defaultValue");
return !string.IsNullOrEmpty(value) ? Converting.GetConvert(value).TryToObject(type) : null;
}));
}
private void btCalibrateWheel_Click(object sender, EventArgs e)
{
var ctlpt = this.InputRawDB.ControlPoints;
CalibrateWheelForm calibwheel = new CalibrateWheelForm();
calibwheel.SelectedRawAxis = SelectedAxis;
var res = calibwheel.ShowDialog(this);
if (res == DialogResult.OK)
{
ctlpt.Clear();
// SCale values to percent given the range
double X = Converting.NormalizeToPct(calibwheel.RawMostLeft_cts, this.InputRawDB.RawMin_cts, this.InputRawDB.RawMax_cts);
double Y = 0.0; // 0%
ctlpt.Add(new System.Windows.Point(X, Y));
X = Converting.NormalizeToPct(calibwheel.RawMostCenter_cts, this.InputRawDB.RawMin_cts, this.InputRawDB.RawMax_cts);
Y = 0.5; // 50%
ctlpt.Add(new System.Windows.Point(X, Y));
X = Converting.NormalizeToPct(calibwheel.RawMostRight_cts, this.InputRawDB.RawMin_cts, this.InputRawDB.RawMax_cts);
Y = 1.0; // 100%
ctlpt.Add(new System.Windows.Point(X, Y));
this.InputRawDB.ControlPoints = ctlpt.OrderBy(p => p.X).ThenBy(p => p.Y).ToList <System.Windows.Point>();
SelectedPoint = InputRawDB.FindClosestControlPoint(X);
lbSelectedPoint.Text = "Selected point: " + SelectedPoint + "/" + this.InputRawDB.ControlPoints.Count + " total";
FillLine();
}
}
public List <TblSaleOrder> GetListForInvoiceByCondition(string fromDate = "", string toDate = "", string status = "1")
{
var data = db.TblSaleOrder
.OrderByDescending(c => c.SaleOrderId)
.AsQueryable();
DateTime stDate, enDate;
//var saleOrderId = db.TblSaleOrder.Select(x => x.SaleOrderId).ToArray();
if (fromDate != "")
{
stDate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US"));
enDate = DateTime.ParseExact(toDate, "dd/MM/yyyy", new System.Globalization.CultureInfo("en-US"));
//data = data.Where(x => !saleOrderId.Contains(x.SaleOrderId)
// && (x.SaleOrderDate.Value.Date >= stDate.Date && x.SaleOrderDate.Value.Date <= enDate.Date)
// && x.StatusId.ToString() == status);
data = data.Where(x => (x.SaleOrderDate.Value.Date >= stDate.Date && x.SaleOrderDate.Value.Date <= enDate.Date) &&
x.StatusId.ToString() == status);
}
else
{
//data = data.Where(x => !saleOrderId.Contains(x.SaleOrderId) && x.StatusId.ToString() == status);
data = data.Where(x => x.StatusId.ToString() == status);
}
if (data != null && data.ToList().Count > 0)
{
foreach (TblSaleOrder obj in data)
{
obj.strSaleOrderDate = Converting.ToDDMMYYYY(obj.SaleOrderDate);
}
}
return(data.ToList());
}
public List <TblJobOrder> GetByDate(string fromDate, string toDate)
{
List <TblJobOrder> jobOrder = (from o in db.TblJobOrder.Where(x => x.StatusId == 2) select new TblJobOrder
{
JobOrderId = o.JobOrderId,
JobOrderNo = o.JobOrderNo,
SaleOrderId = o.SaleOrderId,
JobName = o.JobName,
StartDate = o.StartDate,
StartDateToString = o.StartDate != null ? Converting.ToDDMMYYYY(o.StartDate.Value) : "",
EndDate = o.EndDate,
EndDateToString = o.EndDate != null ? Converting.ToDDMMYYYY(o.EndDate.Value) : "",
StartWorkingTime = o.StartWorkingTime,
EndWorkingTime = o.EndWorkingTime,
CustomerId = o.CustomerId,
CustomerName = o.CustomerName,
CustomerPhone = o.CustomerPhone,
CustomerEmail = o.CustomerEmail,
ProjectName = o.ProjectName,
StatusId = o.StatusId.HasValue ? o.StatusId.Value : 0,
Status = o.StatusId.HasValue ? Converting.JobOrderStatus(o.StatusId.Value) : Converting.JobOrderStatus(0),
SubDistrict = o.SubDistrict,
Team = o.Team,
CreatedByName = (from emp in db.SysAccount.Where(x => x.AccountId == o.CreatedBy) select emp.AccountName).FirstOrDefault(),
CreatedDate = o.CreatedDate,
CreateDateToString = o.CreatedDate.HasValue ? Converting.ToDDMMYYYY(o.CreatedDate.Value) : "",
}).OrderByDescending(o => o.CreatedDate).ToList();
return(jobOrder);
}
public List <SaleOrderHeader> GetHeader(DateTime dateTime)
{
List <SaleOrderHeader> result = new List <SaleOrderHeader>();
result = db.TblSaleOrder
.Where(x => x.SaleOrderDate.Value.ToString("yyyyMMdd") == dateTime.ToString("yyyyMMdd")).Select(o => new SaleOrderHeader {
SaleOrderId = o.SaleOrderId,
SaleOrderNo = o.SaleOrderNo,
SaleOrderDate = Converting.ToDDMMYYYY(o.SaleOrderDate),
DSaleOrderDate = o.SaleOrderDate,
SaleName = o.SaleName,
QuotationNo = o.QuotationNo,
//QuotationDate = Converting.ToDDMMYYYY(o.q),
CustomerId = o.CustomerId,
CustomerName = o.CustomerName,
JobOrderId = o.JobOrder != null ?o.JobOrder.JobOrderId.ToString():"",
JobOrderNo = o.JobOrder != null ? o.JobOrder.JobOrderNo.ToString() : "",
JobOrderName = o.JobOrder != null ? o.JobOrder.JobName : "",
JobOrderDate = o.JobOrder != null ? Converting.ToDDMMYYYY(o.JobOrder.StartDate) : "",
StatusId = o.StatusId,
Status = Converting.SaleOrderStatus(o.StatusId)
}).ToList();
return(result);
}
public List <TblSaleOrder> GetSaleOrderInInvoice(DateTime?fromDate, DateTime?toDate)
{
string sql = "sp_GetSaleOrderInInvoice";
List <SqlParameter> paramList = new List <SqlParameter>();
List <TblSaleOrder> list = new List <TblSaleOrder>();
TblSaleOrder dto = null;
SqlDataReader reader = null;
SqlCommand sqlCommand = null;
try
{
webdb.OpenConnection();
paramList.Add(new SqlParameter("@FromDate", fromDate.HasValue ? string.Format("{0}{1}{2}", fromDate.Value.Year, fromDate.Value.Month.ToString("##00"), fromDate.Value.Day.ToString("##00")):""));
paramList.Add(new SqlParameter("@ToDate", toDate.HasValue ? string.Format("{0}{1}{2}", toDate.Value.Year, toDate.Value.Month.ToString("##00"), toDate.Value.Day.ToString("##00")):""));
//connect.Open();
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = webdb.Connection;
sqlCommand.Parameters.AddRange(paramList.ToArray());
reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
dto = new TblSaleOrder();
dto.SaleOrderId = Converting.ToInt(reader["SaleOrderId"].ToString());
dto.SaleOrderNo = reader["SaleOrderNo"].ToString();
dto.SaleOrderDate = Converting.StringToDate(reader["SaleOrderDate"].ToString(), null);
dto.strSaleOrderDate = Converting.ToDDMMYYYY(dto.SaleOrderDate);
dto.QuotationNo = reader["QuotationNo"].ToString();
dto.CustomerId = Converting.ToInt(reader["CustomerId"].ToString());
dto.CustomerName = reader["CustomerName"].ToString();
dto.ContractName = reader["ContractName"].ToString();
dto.ConditionId = Converting.ToInt(reader["ConditionId"].ToString());
dto.SaleId = Converting.ToInt(reader["SaleId"].ToString());
dto.SaleName = reader["SaleName"].ToString();
dto.TeamId = Converting.ToInt(reader["TeamId"].ToString());
dto.CreatedBy = Converting.ToInt(reader["CreatedBy"].ToString());
list.Add(dto);
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
if (webdb.Connection.State == ConnectionState.Open)
{
webdb.CloseConnection();
}
}
return(list);
}
public void SITest()
{
Assert.AreEqual(Converting.SI("Мили", "Футы"), 5280);
Assert.AreEqual(Converting.SI("Квадратные Метры", "Гектары"), 0.0001);
Assert.AreEqual(Converting.SI("Кубические Метры", "Литры"), 1000);
Assert.AreEqual(Converting.SI("Узлы", "Метры в секунду"), 0.51444);
}
public IHttpActionResult GetCondoRegisterMenu2(SearchMap searchDto)
{
var repos = new TDAssetRespository();
SetionType sectionT = new SetionType();
/* switch (SectionType)
* {
* case "1":sectionT = SetionType.Region;break;
* case "2": sectionT = SetionType.Provice; break;
* case "3": sectionT = SetionType.Amphur; break;
* }*/
if (searchDto.FromYear != null && searchDto.FromMonth != null)
{
searchDto.FromYearMonth = searchDto.FromYear + Converting.ToInt(searchDto.FromMonth).ToString("##00");
}
if (searchDto.ToYear != null && searchDto.ToMonth != null)
{
searchDto.ToYearMonth = searchDto.ToYear + Converting.ToInt(searchDto.ToMonth).ToString("##00");
}
var estimateData = repos.GetCondoRegisterMenu2(searchDto);
return(Json(estimateData));
}
public IHttpActionResult GetPrice(SearchMap searchDto)
{
List <EstimateData> estimateData = null;
var repos = new TDAssetRespository();
SetionType sectionT = new SetionType();
/* switch (SectionType)
* {
* case "1":sectionT = SetionType.Region;break;
* case "2": sectionT = SetionType.Provice; break;
* case "3": sectionT = SetionType.Amphur; break;
* }*/
if (searchDto.costEstUnitType == "2") // ราคาซื้อขาย
{
estimateData = repos.GetPrice(searchDto);
estimateData = estimateData.Where(o => (Converting.ToDecimal(o.MarketWAHPrice) >= Converting.ToDecimal(searchDto.costEstMin) &&
Converting.ToDecimal(o.MarketWAHPrice) <= Converting.ToDecimal(searchDto.costEstMax)))
.OrderByDescending(x => Converting.ToDecimal(x.MarketWAHPriceMax)).ToList();
}
else
{
estimateData = repos.GetPrice(searchDto).Where(o => (Converting.ToDecimal(o.ParcelWAHPrice) >= Converting.ToDecimal(searchDto.costEstMin) &&
Converting.ToDecimal(o.ParcelWAHPrice) <= Converting.ToDecimal(searchDto.costEstMax)))
.OrderByDescending(x => Converting.ToDecimal(x.ParcelWAHPriceMax)).ToList();
}
return(Json(estimateData));
}
public List <SysMenu> GetMenuByRole(int roleId)
{
string sql = "GetMenuActive";
List <SqlParameter> paramList = new List <SqlParameter>();
List <SysMenu> list = new List <SysMenu>();
SysMenu dto = null;
SqlDataReader reader = null;
SqlCommand sqlCommand = null;
try
{
webdb.OpenConnection();
paramList.Add(new SqlParameter("@RoleId", roleId));
//connect.Open();
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = webdb.Connection;
sqlCommand.Parameters.AddRange(paramList.ToArray());
reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
dto = new SysMenu();
dto.MenuId = Converting.ToInt(reader["MenuId"].ToString());
dto.SiteId = Converting.ToInt(reader["SiteId"].ToString());
dto.MenuName = reader["MenuName"].ToString();
dto.MenuIcon = reader["MenuIcon"].ToString();
dto.MenuOrder = Converting.ToInt(reader["MenuOrder"].ToString());
dto.ParentId = Converting.ToInt(reader["ParentId"].ToString());
dto.MvcArea = reader["MvcArea"].ToString();
dto.MvcController = reader["MvcController"].ToString();
dto.MvcAction = reader["MvcAction"].ToString();
dto.FlagActive = Converting.ToBoolean(reader["FlagActive"].ToString());
dto.View = Converting.ToInt(reader["View"].ToString());
dto.Edit = Converting.ToInt(reader["Edit"].ToString());
dto.Delete = Converting.ToInt(reader["Delete"].ToString());
list.Add(dto);
}
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
if (webdb.Connection.State == ConnectionState.Open)
{
webdb.CloseConnection();
}
}
return(list);
}
private void btnCalibratePedal_Click(object sender, EventArgs e)
{
var ctlpt = this.InputRawDB.ControlPoints;
CalibratePedalForm calibpedal = new CalibratePedalForm();
calibpedal.SelectedRawAxis = SelectedAxis;
var res = calibpedal.ShowDialog(this);
if (res == DialogResult.OK)
{
ctlpt.Clear();
double Xreleased = Converting.NormalizeToPct(calibpedal.RawMostReleased_cts, this.InputRawDB.RawMin_cts, this.InputRawDB.RawMax_cts); // Released %
double Xpressed = Converting.NormalizeToPct(calibpedal.RawMostPressed_cts, this.InputRawDB.RawMin_cts, this.InputRawDB.RawMax_cts); // Pressed %
double Ystart = 0.0; // Start point = 0%
double Yend = 1.0; // End point = 100%
if (chkFullRangePedal.Checked)
{
// Full range of axis
if (chkNegPedal.Checked)
{
// Negative axis
Ystart = 1.0; // released = 100%
Yend = 0.0; // pressed = 0%
}
else
{
Ystart = 0.0; // released = 0%
Yend = 1.0; // pressed = 100%
}
}
else
{
// Half range, neutral point is 50%
if (chkNegPedal.Checked)
{
Ystart = 0.5; // released = 50%
Yend = 0.0; // pressed = 0%
}
else
{
Ystart = 0.5; // released = 50%
Yend = 1.0; // pressed = 100%
}
}
ctlpt.Add(new System.Windows.Point(Xreleased, Ystart));
ctlpt.Add(new System.Windows.Point(Xpressed, Yend));
this.InputRawDB.ControlPoints = ctlpt.OrderBy(p => p.X).ThenBy(p => p.Y).ToList <System.Windows.Point>();
SelectedPoint = InputRawDB.FindClosestControlPoint(Xpressed);
lbSelectedPoint.Text = "Selected point: " + SelectedPoint + "/" + this.InputRawDB.ControlPoints.Count + " total";
FillLine();
}
}
private List <Models.EstimateData> GetMapInfo(MapSearchCriteria criteria)
{
List <Models.EstimateData> result = new List <Models.EstimateData>(0);
var repos = new TDAssetRespository();
List <EstimateData> searchResult = null;
if (criteria.AreaType == "1")
{
searchResult = repos.GetPrice(new SearchMap()
{
SectionType = criteria.Type,
Code = criteria.ID,
ChanodeNo = criteria.ChanodeNo
});
}
else if (criteria.AreaType == "2")
{
searchResult = repos.GetCondoPrice(new SearchMap()
{
SectionType = criteria.Type,
Code = criteria.ID,
ChanodeNo = criteria.ChanodeNo
});
}
if (searchResult != null && searchResult.Count() > 0)
{
if (criteria.CostEstUnitType == "2") // ราคาซื้อขาย
{
searchResult = searchResult.Where(o => (Converting.ToDecimal(o.MarketWAHPrice) >= Converting.ToDecimal(criteria.CostEstMin) && Converting.ToDecimal(o.MarketWAHPrice) <= Converting.ToDecimal(criteria.CostEstMax))).ToList();
}
else
{
searchResult = searchResult.Where(o => (Converting.ToDecimal(o.ParcelWAHPrice) >= Converting.ToDecimal(criteria.CostEstMin) && Converting.ToDecimal(o.ParcelWAHPrice) <= Converting.ToDecimal(criteria.CostEstMax))).ToList();
}
foreach (EstimateData data in searchResult)
{
data.Name = data.DisplayName;
data.MapStructure = new Models.ViewModels.MapStructureInfo()
{
ParcelDrawingCode = (criteria.AreaType == "2") ? "poin" : data.ParcelColor,
MarketDrawingCode = (criteria.AreaType == "2") ? "poin" : data.MarketColor,
Shape = data.Shape.ToString()
};
data.PriceType = criteria.PriceType;
data.CostEstUnitType = criteria.CostEstUnitType;
data.AreaType = criteria.AreaType;
}
}
return(searchResult);
}
public void TestMethods1()
{
Converting obj = new Converting();
double expected = 0.2822;
double actual = obj.ConvertToOunces(8);
double delta = 0.0001;
Assert.AreEqual(expected, actual, delta);
}
public JsonResult GetSaleOrderByDate(string saleOrderDate)
{
string formateDate = "yyyy-MM-dd";
DateTime searchOrderDate = Converting.StringToDate(saleOrderDate, formateDate);
List <SaleOrderHeader> ob = uow.Modules.SaleOrder.GetHeader(searchOrderDate);
var js = new JavaScriptSerializer();
return(Json(ob, JsonRequestBehavior.AllowGet));
}
public void TestMethods()
{
Converting obj = new Converting();
double expected = 283.4952;
double actual = obj.ConvertToGrams(10);
double delta = 0.0001;
Assert.AreEqual(expected, actual, delta);
}
public RefTransferHeader GetTransferHeader(int transferid)
{
bool result = false;
string sql = "sp_TransfetHeader_GetById";
RefTransferHeader header = null;
SqlCommand sqlCommand = null;
List <SqlParameter> paramList = new List <SqlParameter>();
SqlConnection conn = null;
SqlDataReader reader = null;
try
{
paramList = new List <SqlParameter>();
paramList.Add(new SqlParameter("@TransferId", transferid));
webdb.OpenConnection();
conn = webdb.Connection;
sqlCommand = new SqlCommand();
sqlCommand.CommandText = sql;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = conn;
sqlCommand.Parameters.AddRange(paramList.ToArray());
reader = sqlCommand.ExecuteReader();
// if (reader.Read())
// {
header = Converting.ConvertDataReaderToObjList <RefTransferHeader>(reader).FirstOrDefault();
if (header != null)
{
reader.NextResult();
header.TransferDetail = Converting.ConvertDataReaderToObjList <TransferDetail>(reader);
reader.NextResult();
header.TransferRefHeader = Converting.ConvertDataReaderToObjList <TransferRefHeader>(reader);
}
// }
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
finally
{
webdb.CloseConnection();
}
return(header);
}
private void GetGridLocation()
{
if (this.transform.parent.gameObject.name.Contains("Column ("))
{
string s = this.transform.parent.gameObject.name.Substring(8);
char[] cA = s.ToCharArray();
string num = cA[0].ToString();
int columnNum = Converting.ConvertStringToInt(num);
LocationOnGrid.columnNumber = columnNum;
LocationOnGrid.gridSpaceNumber = (this.transform.GetSiblingIndex() + 1);
}
}
public JsonResult GetReport(string searchYear)
{
ChartModel Result = null;
List <string> xAix = new List <string>();
List <string> yAix = new List <string>();
List <string> yAix2 = new List <string>();
AccountPermission permission = GetPermission(CurrentUID);
try
{
List <SaleOrderHeader> obSaleOrder = uow.Modules.SaleOrder.GetHeader((permission.IsAdminTeam || permission.IsManager) ? 0 : CurrentUID);
List <TblQuotation> objQuation = uow.Modules.Quotation.GetList((permission.IsAdminTeam || permission.IsManager) ? 0 : CurrentUID);
xAix.AddRange(Converting.GetShortMonth());
int intMonth = 1;
obSaleOrder = obSaleOrder.Where(o => o.DSaleOrderDate.Value.Year.ToString() == searchYear).ToList();
objQuation = objQuation.Where(o => o.QuotationDate.Year.ToString() == searchYear).ToList();
foreach (string month in Converting.GetShortMonth())
{
string monthyearFormat = string.Format("{0}{1}", searchYear, intMonth.ToString("##00"));
decimal sumSaleOrder = obSaleOrder.Where(o => (o.DSaleOrderDate.Value.Year.ToString() + o.DSaleOrderDate.Value.Month.ToString("##00") == monthyearFormat)).Sum(o => o.SummaryTot.HasValue?o.SummaryTot.Value:0);
yAix.Add(sumSaleOrder.ToString());
decimal sumQuotation = objQuation.Where(o => (o.QuotationDate.Year.ToString() + o.QuotationDate.Month.ToString("##00") == monthyearFormat)).Sum(o => o.SummaryTot.HasValue ? o.SummaryTot.Value : 0);
yAix2.Add(sumQuotation.ToString());
intMonth++;
}
/* xAix.Add("Jan");
* xAix.Add("Feb");
*
* yAix.Add("10000");
* yAix.Add("20000");*/
Result = new ChartModel();
Result.xAixData = xAix;
Result.yAixData = yAix;
Result.yAixData2 = yAix2;
// customerResult = uow.Modules.Product.GetByCondition(ProductCode, ProductName).Where(o => o.PriceNet > 0).ToList();
}
catch (Exception ex)
{ }
return(Json(Result, JsonRequestBehavior.AllowGet));
}
public ActionResult Permissions(int id, string[] permissionId)
{
foreach (var p in permissionId)
{
using (var bllUsergroupPermission = new BLLUserGroupPermission())
{
bllUsergroupPermission.Add(new TBL_USERGROUP_PERMISSION {
PERMISSION_ID = Converting.GetInt32(p), USERGROUP_ID = id
});
}
}
return(Redirect(Url.Action("Permissions", new { id })));
}
public List <M_CustomerDTO> FindByObjList(object data)
{
List <SqlParameter> parameterList = new List <SqlParameter>();
objList = new List <M_CustomerDTO>();
List <M_Customer_Account> custAccountList = null;
List <M_Customer_Address> custAddreList = null;
string procName = "sp_M_Customer_FindByColumn";
try
{
adapter = new SqlDataAdapter();
SqlConnection conn = OpenConection();
if (data != null)
{
parameterList.AddRange(GetParameters(procName, data).ToArray());
}
command = new SqlCommand(procName, conn);
command.CommandType = CommandType.StoredProcedure;
if (data != null)
{
command.Parameters.AddRange(parameterList.ToArray());
}
using (SqlDataReader reader = command.ExecuteReader())
{
objList = Converting.GetListFromDataReader <M_CustomerDTO>(reader).ToList();
reader.NextResult();
custAccountList = Converting.GetListFromDataReader <M_Customer_Account>(reader).ToList();
reader.NextResult();
custAddreList = Converting.GetListFromDataReader <M_Customer_Address>(reader).ToList();
foreach (M_CustomerDTO custObj in objList)
{
custObj.AccountList = custAccountList.FindAll(cus => cus.CustomerOID == custObj.CustomerOID);
custObj.AddressList = custAddreList.FindAll(cus => cus.CustomerOID == custObj.CustomerOID);
}
}
}
catch (Exception ex) { }
finally
{
CloseConnection();
}
return(objList);
}
public ActionResult Boletas(DateTime?del = null, DateTime?hasta = null)
{
IEnumerable <Boleta> ListBoleta = null;
if (del.HasValue && hasta.HasValue)
{
ListBoleta = BoletaBL.GetReporteFechas(Converting.DateTimeToSqlString(del.Value), Converting.DateTimeToSqlString(hasta.Value, 1));
}
else
{
ListBoleta = BoletaBL.GetReporteFechas(Formatting.SqlStringDateFirstDayCurrentMonth(), Formatting.SqlStringDateLastDayCurrentMonth(1));
}
return(View(ListBoleta));
}
private void TextBox1_TextChanged(object sender, EventArgs e)
{
if ((comboBox1.Text == "Длина") || (comboBox1.Text == "Площадь") || (comboBox1.Text == "Объем") || (comboBox1.Text == "Скорость"))
{
textBox2.Text = Convert.ToString(Convert.ToDouble(textBox1.Text) * Converting.SI(comboBox2.Text, comboBox3.Text));
}
if (comboBox1.Text == "Масса")
{
textBox2.Text = Convert.ToString(Convert.ToDouble(textBox1.Text) * Converting.Mass(comboBox2.Text, comboBox3.Text));
}
if (comboBox1.Text == "Температура")
{
textBox2.Text = Convert.ToString(Converting.Temp(comboBox2.Text, comboBox3.Text, Convert.ToDouble(textBox1.Text)));
}
}
public JsonResult GetAllTeamNotIn(string StartDate, string EndDate)
{
DateTime stDate, enDate;
stDate = Converting.StringToDate(StartDate, "dd/MM/yyyy");
enDate = Converting.StringToDate(EndDate, "dd/MM/yyyy");
List <int> teamId = uow.Modules.JobOrder.GetTeamByPeriod(stDate, enDate);
List <TeamOperation> teamOperations = uow.Modules.TeamOperation.GetTeamNotIn(teamId);
// ob.TblSaleOrderDetail = uow.Modules.SaleOrderDetail.Gets(id ?? 0);
// TblCustomer objCustomer = uow.Modules.Customer.Get(Convert.ToInt32(ob.CustomerId));
return(Json(teamOperations, JsonRequestBehavior.AllowGet));
}
public IHttpActionResult GetPriceOfConstruction(SearchMap searchDto)
{
var repos = new TDAssetRespository();
SetionType sectionT = new SetionType();
/* switch (SectionType)
* {
* case "1":sectionT = SetionType.Region;break;
* case "2": sectionT = SetionType.Provice; break;
* case "3": sectionT = SetionType.Amphur; break;
* }*/
var estimateData = repos.GetPriceOfConstrucion(searchDto);
return(Json(estimateData.OrderByDescending(o => Converting.ToDecimal(o.ParcelPrice)).ToList()));
}
private static void Expense26Report(ExcelPackage ep, BusinessContext bc, int year, int month)
{
string name = PATH_EXPENSE_REPORT + " " + OFFICE_NAME;
var sheet = Helpers.GetSheet(ep, name);
int indexRow = 1;
sheet.View.ShowGridLines = false;
sheet.Column(1).Width = Helpers.PixelsToInches(330);
sheet.Column(2).Width = Helpers.PixelsToInches(450);
Helpers.CreateCell(sheet, indexRow, 1, indexRow, 2, APPEAL, Color.Transparent, 12, false, ExcelHorizontalAlignment.Right, ExcelBorderStyle.None);
indexRow++;
Helpers.CreateCell(sheet, indexRow, 2, APPEAL_NAME, Color.Transparent, 12, false, ExcelHorizontalAlignment.Right, ExcelBorderStyle.None);
indexRow += 7;
Helpers.CreateCell(sheet, indexRow, 1, indexRow, 2, MEMORANDUM, Color.Transparent, 14, true, ExcelHorizontalAlignment.Center, ExcelBorderStyle.None);
indexRow += 2;
var infoCosts = bc.GetInfoCosts26Expense(year, month).ToList();
int countRows = 0;
string context = "Прошу снять из кассы АВ следующие суммы:" + Environment.NewLine;
countRows++;
foreach (var infoCost in infoCosts)
{
context += "Сумму в размере " + Converting.DoubleToCurrency(infoCost.Summ, infoCost.Currency) + " " + infoCost.ConcatNotes +
" – распределение по проектам согласно служебной записке." + Environment.NewLine;
}
Helpers.CreateCell(sheet, indexRow, 1, indexRow, 2, context,
Color.Transparent, 14, false, ExcelHorizontalAlignment.Left, ExcelBorderStyle.None);
indexRow += 6;
Helpers.CreateCell(sheet, indexRow, 1, FOOTER_26_APEL, Color.Transparent, 14, false, ExcelHorizontalAlignment.Left, ExcelBorderStyle.None);
Helpers.CreateCell(sheet, indexRow, 2, FOOTER_26_APEL_NAME, Color.Transparent, 14, false, ExcelHorizontalAlignment.Right, ExcelBorderStyle.None);
}
