void AddParametersToSqlCommand(FOrderDetails ent, ref SqlCommand sc) { sc.Parameters.Add("@FOrderID", ent.FOrderID); sc.Parameters.Add("@VodomerID", ent.VodomerID); sc.Parameters.Add("@StartValue", ent.StartValue); //sc.Parameters.Add("@EndValue", ent.EndValue); }
public int Create(FOrderDetails ent) { int createdid = 0; FOrderDetailsDAO entDAO = new FOrderDetailsDAO(); sc = new SqlCommand("CreateFOrderDetails"); sc.CommandType = CommandType.StoredProcedure; addParameters(ent); createdid = entDAO.createEntity(sc); return(createdid); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (dr.Read()) { FOrderDetails ent = new FOrderDetails(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public FOrderDetails createEntityFromReader(SqlDataReader dr) { FOrderDetails ent = new FOrderDetails(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { ent.ID = Convert.ToInt32(dr["ID"]); } if (!dr.IsDBNull(dr.GetOrdinal("FOrderID"))) { ent.FOrderID = Convert.ToInt32(dr["FOrderID"]); } if (!dr.IsDBNull(dr.GetOrdinal("VodomerID"))) { ent.VodomerID = Convert.ToInt32(dr["VodomerID"]); } if (!dr.IsDBNull(dr.GetOrdinal("StartValue"))) { ent.StartValue = dr["StartValue"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("EndValue"))) { ent.EndValue = dr["EndValue"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Price"))) { ent.Price = Convert.ToDouble(dr["Price"]); } if (!dr.IsDBNull(dr.GetOrdinal("PriceRub"))) { ent.PriceRub = Convert.ToDouble(dr["PriceRub"]); } if (!dr.IsDBNull(dr.GetOrdinal("SpecialPrice"))) { ent.SpecialPrice = Convert.ToDouble(dr["SpecialPrice"]); } if (!dr.IsDBNull(dr.GetOrdinal("DefectVodomer"))) { ent.MarriageVodomer = dr["DefectVodomer"].ToString(); } return(ent); }
//Сохранение в базу protected void lbSaveAll_Click(object sender, EventArgs e) { if (Session["Abonent"] != null) { SessionAbonent sa = (SessionAbonent)Session["Abonent"]; if (sa.Vodomer.Count == 0) { radWM.RadAlert("Необходимо добавить минимум 1 водомер.", null, null, "Предупреждение", ""); } else { if (sa.Type == (short)Abonent.Corporate) { UAbonent ua = sa.UAbon; UAbonentDO uado = new UAbonentDO(); int uid = uado.Create(ua); if (uid > 0) { sa.UAbon.ID = uid; Session["Abonent"] = sa; UOrder uo = new UOrder(); UOrderDO uodo = new UOrderDO(); uo.ActionType = "Определения метрологических характеристик водомера"; uo.UAbonentID = uid; uo.UserID = GetCurrentUser().ID; int uoid = uodo.Create(uo); if (uoid > 0) { hfOrder.Value = uoid.ToString(); UOrderDetails uod = new UOrderDetails(); UOrderDetailsDO uoddo = new UOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); uod.UOrderID = uoid; uod.VodomerID = vid; uod.StartValue = v.VodomerPreview.StartValue; int uodid = uoddo.Create(uod); } Response.Redirect("UJournal.aspx?id=" + uoid.ToString()); } } } if (sa.Type == (short)Abonent.Private) { FAbonent fa = sa.FAbon; FAbonentDO fado = new FAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; FOrder fo = new FOrder(); FOrderDO fodo = new FOrderDO(); fo.ActionType = "Определения метрологических характеристик водомера "; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.Create(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOrderDetails fod = new FOrderDetails(); FOrderDetailsDO foddo = new FOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); fod.FOrderID = foid; fod.VodomerID = vid; fod.StartValue = v.VodomerPreview.StartValue; int uodid = foddo.Create(fod); } Response.Redirect("FJournal.aspx?id=" + foid.ToString()); } } } // LoadStep3(); } } }
//Сохранение в базу protected void lbSaveAll_Click(object sender, EventArgs e) { if (Session["Abonent"] != null) { SessionAbonent sa = (SessionAbonent)Session["Abonent"]; if (sa.Vodomer.Count == 0) { SetMessege("Предупреждение", "Необходимо добавить минимум 1 водомер."); } else { if (sa.Type == (short)Abonent.Corporate) { UAbonent ua = sa.UAbon; UAbonentDO uado = new UAbonentDO(); int uid = uado.Create(ua); if (uid > 0) { sa.UAbon.ID = uid; Session["Abonent"] = sa; UOrder uo = new UOrder(); UOrderDO uodo = new UOrderDO(); uo.ActionType = "Поверка водомера."; uo.UAbonentID = uid; uo.UserID = GetCurrentUser().ID; int uoid = uodo.Create(uo); if (uoid > 0) { hfOrder.Value = uoid.ToString(); UOrderDetails uod = new UOrderDetails(); UOrderDetailsDO uoddo = new UOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); uod.UOrderID = uoid; uod.VodomerID = vid; uod.StartValue = v.VodomerPreview.StartValue; int uodid = uoddo.Create(uod); } } } } if (sa.Type == (short)Abonent.Private) { FAbonent fa = sa.FAbon; FAbonentDO fado = new FAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; FOrder fo = new FOrder(); FOrderDO fodo = new FOrderDO(); fo.ActionType = "Поверка водомера."; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.Create(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOrderDetails fod = new FOrderDetails(); FOrderDetailsDO foddo = new FOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); fod.FOrderID = foid; fod.VodomerID = vid; fod.StartValue = v.VodomerPreview.StartValue; int uodid = foddo.Create(fod); } } } } //SetMessege("Статус", "Абонент и водомер успешно внесены в базу."); LoadStep3(); } } }
//генерация квитнации protected void btPay_Click(object sender, EventArgs e) { NewFAbonentDO faDO = new NewFAbonentDO(); FOrderDO foDO = new FOrderDO(); VodomerType vt = new VodomerType(); FOrder fo; NewFAbonent fa; UniversalEntity ue = new UniversalEntity(); int id = Convert.ToInt32(hfODID.Value); ue = faDO.RetrieveByOrderID(id); Vodomer vod = new Vodomer(); VodomerDO vodDO = new VodomerDO(); FOrderDetailsDO fodDO = new FOrderDetailsDO(); FOrderDetails fods = new FOrderDetails(); //FOrderDetails fod; double sum = 0; //гривневая цена double getvat = 0; //гривневый ндс double uafin = 0; //гривневая итоговая сумма double sumrub = 0; //рублевая цена double getvatrub = 0; //рублевый ндс double finish = 0; //рублевая итоговая сумма if (ue.Count > 0) { fa = (NewFAbonent)ue[0]; ue = foDO.RetrieveFOrderById(id); if (ue.Count > 0) { fo = (FOrder)ue[0]; ue = fodDO.RetrieveFOrderDetailsByOrderID(id); foreach (FOrderDetails fod in ue) { //гривневый счет sum += fod.Price; getvat = sum * 0.2; getvat = Math.Round(getvat, 2); uafin = (sum + getvat); //рублевый счет sumrub += fod.Price; getvatrub = sumrub * 0.2; getvatrub = Math.Round(getvatrub, 2); finish = (sumrub + getvatrub) + (sumrub + getvatrub); } using (DocX document = DocX.Load(Request.MapPath("~\\Templates/kvit.docx"))) { //DocXExtender.ReplaceFormatedText(document, "DDD", "дата"); document.ReplaceText("FIO", fa.Surname + " " + fa.FirstName + " " + fa.LastName, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("ADDRESS", fa.Address, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("PNONE", fa.Phone, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("DATE", DateTime.Now.ToString("dd MMMM yyyy"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("NUMBER", fo.Prefix + fo.ID.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("VIEW", fo.ActionType, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("DIAMETR", vt.Diameter.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("NOMZAVOD", vod.FactoryNumber.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("SUM", sum.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("VAT", getvat.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("ALL", uafin.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); //document.ReplaceText("CENA", sumrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); //document.ReplaceText("NDS", getvatrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); document.ReplaceText("VSEGO", finish.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase); //VODOMER document.SaveAs(Request.MapPath("~\\Templates/kvitfa.docx")); litScript.Text = "<iframe style=\"display:none;\" src=\"../GetDocument.ashx?pay=Private\"></iframe>"; } } } }
void addParameters(FOrderDetails ent) { AddParametersToSqlCommand(ent, ref sc); }