public SaleData getLastMonthSaleData(int id, int ano, int mes)
{
SqlDataReader record = null;
SqlConnection cnn = conect.connect();
using (var com = cnn.CreateCommand())
{
SqlParameter[] parSelect = getParSelectArray();
parSelect[0].Value = id;
parSelect[1].Value = ano;
parSelect[2].Value = mes;
string query1 = "select siguiente, id, ano, mes, unidades, anterior from dbo.SaleData where id = @id and ano = @ano and mes = @mes";
com.CommandText = query1;
com.Parameters.AddRange(parSelect);
com.CommandType = CommandType.Text;
record = com.ExecuteReader();
}
SaleData lastMonth = new SaleData();
if (record.HasRows)
{
while (record.Read())
{
lastMonth.siguiente = record.GetInt32(0);
lastMonth.id = record.GetInt32(1);
lastMonth.ano = record.GetInt32(2);
lastMonth.mes = record.GetInt32(3);
lastMonth.unidades = record.GetInt32(4);
lastMonth.anterior = record.GetInt32(5);
}
}
cnn.Close();
return(lastMonth);
}
public void Post(SaleModel item)
{
SaleData data = new SaleData(config);
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
data.SaveSale(item, userId);
}
public List <SaleReportModel> GetSalesReport()
{
SaleData data = new SaleData();
var result = data.GetSaleReport();
return(result);
}
public void Post(SaleModel model)
{
SaleData data = new SaleData();
string cashierId = RequestContext.Principal.Identity.GetUserId();
data.SaveSale(model, cashierId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier); // old way -RequestContext.Principal.Identity.GetUserId();
data.SaveSale(sale, userId);
}
private void SellProducts()
{
var products = ApplicationManager.Instance.DataHolder.GetProductsData().Where((s) => s.identification == idInputField.text);
var product = products.FirstOrDefault();
var oldProductData = product;
if (product == null || product.amount < Convert.ToInt32(amountInputField.text))
{
return;
}
var saleData = new SaleData(nicknameInputField.text, idInputField.text,
Convert.ToInt32(amountInputField.text), product.price, DateTime.Now);
ApplicationManager.Instance.DataHolder.GetSalesData().Add(saleData);
product.amount -= Convert.ToInt32(amountInputField.text);
product.profit += Convert.ToInt32(amountInputField.text) * product.price;
ApplicationManager.Instance.AdminPageManager.UpdateData(oldProductData, product);
var user = ApplicationManager.Instance.DataHolder
.GetUsersData().FirstOrDefault(s => s.nickname == nicknameInputField.text);
if (user != null)
{
user.spent += Convert.ToInt32(amountInputField.text) * product.price;
}
Hide();
}
private void SortData(DateTime iFrom, DateTime iTo)
{
TimeSpan aTS = iTo - iFrom;
for (int i = 0; i < aTS.Days; i++)
{
DateTime aTime = iFrom.AddDays(i);
SaleData aData = new SaleData();
aData.Date = aTime.ToString("yyyy-MM-dd");
aData.SaleCount = 0;
aSaleData.Add(aData);
}
for (int i = 0; i < aSQLData.Count; i++)
{
for (int k = 0; k < aSaleData.Count; k++)
{
string iTime = DateTime.Parse(aSQLData[i].Date).ToString("yyyy-MM-dd");
string kTime = DateTime.Parse(aSaleData[k].Date).ToString("yyyy-MM-dd");
if (iTime == kTime)
{
aSaleData[k].SaleCount += aSQLData[i].SaleCount;
break;
}
}
}
}
public void Post(SaleModel model)
{
var saleData = new SaleData();
var loggedInUserId = RequestContext.Principal.Identity.GetUserId();
saleData.SaveSale(model, loggedInUserId);
}
public static string Delete(int idSale)
{
SaleData DSale = new SaleData();
DSale.IdSale = idSale;
return(DSale.Delete(DSale));
}
public static string Insert(DateTime dateSale, string receiptType, string serie, string sequent, decimal iva, int idCustomer, int idEmployee, DataTable dtDetails)
{
SaleData DSale = new SaleData();
DSale.DateSale = dateSale;
DSale.ReceiptType = receiptType;
DSale.Serie = serie;
DSale.Sequent = sequent;
DSale.Iva = iva;
DSale.IdCustomer = idCustomer;
DSale.IdEmployee = idEmployee;
List <SaleDetailData> saleDetails = new List <SaleDetailData>();
foreach (DataRow row in dtDetails.Rows)
{
SaleDetailData detail = new SaleDetailData();
detail.IdEntryDetail = Convert.ToInt32(row["id_detalle_entrada"].ToString());
detail.Amount = Convert.ToInt32(row["cantidad"].ToString());
detail.PriceSale = Convert.ToDecimal(row["precio_venta"].ToString());
detail.Discount = Convert.ToDecimal(row["descuento"].ToString());
saleDetails.Add(detail);
}
return(DSale.Insert(DSale, saleDetails));
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
data.SaveSale(sale, userId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier); //RequestContext.Principal.Identity.GetUserId(); // getting user Id from user who is logged in. data given to only one cashier.
data.SaveSale(sale, userId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
string userId = RequestContext.Principal.Identity.GetUserId();
data.SaveSale(sale, userId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
string userId = RequestContext.Principal.Identity.GetUserId(); // getting user Id from user who is logged in. data given to only one cashier.
data.SaveSale(sale, userId);
}
public void Post(SaleModel sale)
{
var data = new SaleData(_config);
var cashierId = RequestContext.Principal.Identity.GetUserId();
data.SaveSale(sale, cashierId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
List <SaleDetailDBModel> details = new List <SaleDetailDBModel>();
string userId = RequestContext.Principal.Identity.GetUserId();
data.SaveSale(sale, userId, details);
}
public void Post(SaleModel sale)
{
//Handle the ata which are received in the API
var data = new SaleData();
var cashierId = RequestContext.Principal.Identity.GetUserId();
data.SaveSale(sale, cashierId);
}
public void Post(SaleModel sale)
{
SaleData data = new SaleData();
//string userId = RequestContext.Principal.Identity.GetUserId();
string userId = "7962aed8-bfaf-41d6-bf73-bfbb4f81647c"; // TODO: 这里出问题了：register 用户是把info存入了"EFData" 这个db, 但是我们在这里query是query "KelvinData" DB.
data.SaveSale(sale, userId);
}
public void Post(SaleModel sale)
{
SaleData saleData = new SaleData();
// user id is taken from authorization
string userId = RequestContext.Principal.Identity.GetUserId();
saleData.SaveSale(sale, userId);
}
public override global::System.Data.DataSet Clone()
{
SaleData cln = ((SaleData)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public async Task <SaleData> PostSaleData(SaleDataDTO saleDataDTO)
{
SaleData saleData = SaleData.ConvertFromDTO(saleDataDTO);
_context.SaleDatas.Add(saleData);
await _context.SaveChangesAsync();
return(saleData);
}
public List <SaleReportModel> GetSalesReport()
{
//if (RequestContext.Principal.IsInRole("Admin"))
//{
// // Do asmin stuff
//}
SaleData data = new SaleData();
return(data.GetSaleReport());
}
public async Task <ActionResult <SaleData> > PostSaleData(SaleDataDTO saleDataDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
SaleData saleData = await saleDataRepository.PostSaleData(saleDataDTO);
return(CreatedAtAction(nameof(GetSaleData), new { id = saleData.ID }, saleData));
}
public List <SaleReportModel> GetSalesReport()
{
if (RequestContext.Principal.IsInRole("Admin"))
{
//Add administrator activties
}
SaleData data = new SaleData(_config);
return(data.GetSaleReport());
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
SaleData ds = new SaleData();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public void Post(SaleModel sale)
{
if (sale == null)
{
throw new ArgumentNullException(nameof(sale));
}
string loggedInUserId = RequestContext.Principal.Identity.GetUserId();
SaleData data = new SaleData();
data.SaveSale(sale, loggedInUserId);
}
public List <SaleReportModel> GetSaleReport()
{
////Custom report if needed
//if (RequestContext.Principal.IsInRole("Manager"))
//{
// //Do Admin stuffs
//}
SaleData data = new SaleData();
return(data.GetSaleReports());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string aProductID = Request["ProductID"].ToString();
DateTime aFrom = DateTime.Parse(Request["DateFrom"].ToString());
DateTime aTo = DateTime.Parse(Request["DateTo"].ToString());
//取出日期差
TimeSpan aTS = aTo - aFrom;
if (aProductID == "")
{
return;
}
using (SqlConnection aCon = new SqlConnection("Data Source=184.168.47.10;Integrated Security=False;User ID=MobileDaddy;PASSWORD=Aa54380438!;Connect Timeout=15;Encrypt=False;Packet Size=4096"))
{
aCon.Open();
string aSQLStr = string.Format("SELECT * FROM BuyData WHERE RecTime >= '{0}' AND RecTime< '{1}' AND ProductID = '{2}'", aFrom.ToString("yyyy - MM - dd"), aTo.ToString("yyyy - MM - dd"), aProductID);
using (SqlCommand aCmd = new SqlCommand(aSQLStr, aCon))
{
SqlDataReader aRD = aCmd.ExecuteReader();
while (aRD.Read())
{
SaleData aData = new SaleData();
aData.Date = aRD["RecTime"].ToString();
aData.SaleCount = int.Parse(aRD["ProductCount"].ToString());
aSQLData.Add(aData);
}
aRD.Close();
}
aCon.Close();
}
SortData(aFrom, aTo);
AllSaleData aAllData = new AllSaleData();
aAllData.rows = aSaleData.ToArray();
string aJsonStr = JsonConvert.SerializeObject(aAllData);
Response.Write(aJsonStr);
}
catch (Exception ex)
{
Response.Write(ex);
}
}
public List <SaleReportModel> GetSalesReport()
{
//if (RequestContext.Principal.IsInRole("Admin"))
//{
// // Do admin stuff
//}
//else if (RequestContext.Principal.IsInRole("Manager"))
//{
// // Do Manager stuff
//}
SaleData data = new SaleData(_config);
return(data.GetSaleReport());
}
public List <SaleReportModel> GetSalesReport()
{
//if(RequestContext.Principal.IsInRole("Admin"))
//{
// //do admin related stuff
//}
//else if (RequestContext.Principal.IsInRole("Admin"))
//{
// //do manager related stuff
//}
SaleData data = new SaleData();
return(data.GetSaleReport());
}
