protected void radbutSaveAbonentInfo_Click(object sender, EventArgs e) { UniversalEntity ue = new UniversalEntity(); NewFAbonent fa = new NewFAbonent(); NewFAbonentDO fado = new NewFAbonentDO(); ue = fado.RetrieveByOrderID(Utilities.ConvertToInt(hfODID.Value)); if (ue.Count > 0) { fa = (NewFAbonent)ue[0]; fa.PhysicalNumberJournal = tbNumberJournalPhysical.Text; fa.Address = tbAddress.Text; fa.Surname = tbClientSurname.Text; fa.DistrictID = Utilities.ConvertToInt(ddlDistrict.SelectedValue); fa.FirstName = tbClientName.Text; fa.LastName = tbClientLastName.Text; fa.Phone = tbPhone.Text; fa.NotPay = cbNotPay.Checked; //fa.RejectVodomer = cbRejectVodomer.Checked; fado.Update(fa, GetCurrentUser().ID); } _OrderID = Utilities.ConvertToInt(hfODID.Value); Bind(); }
public int Create(NewFAbonent ent) { int createdid = 0; NewFAbonentDAO entDAO = new NewFAbonentDAO(); sc = new SqlCommand("CreateFAbonent2018"); sc.CommandType = CommandType.StoredProcedure; addParameters(ent); createdid = entDAO.createEntity(sc); return(createdid); }
public NewFAbonent createEntityFromReader(SqlDataReader dr) { NewFAbonent ent = new NewFAbonent(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { ent.ID = Convert.ToInt32(dr["ID"]); } if (!dr.IsDBNull(dr.GetOrdinal("FirstName"))) { ent.FirstName = dr["FirstName"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Surname"))) { ent.Surname = dr["Surname"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("NumberJournal"))) { ent.PhysicalNumberJournal = dr["NumberJournal"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("LastName"))) { ent.LastName = dr["LastName"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Address"))) { ent.Address = dr["Address"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Phone"))) { ent.Phone = dr["Phone"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("DistrictID"))) { ent.DistrictID = Convert.ToInt32(dr["DistrictID"]); } if (!dr.IsDBNull(dr.GetOrdinal("NotPay"))) { ent.NotPay = Convert.ToBoolean(dr["NotPay"]); } /*if (!dr.IsDBNull(dr.GetOrdinal("RejectVodomer"))) * ent.RejectVodomer = Convert.ToBoolean(dr["RejectVodomer"]);*/ return(ent); }
void AddParametersToSqlCommand(NewFAbonent ent, ref SqlCommand sc) { sc.Parameters.Add("@FirstName", ent.FirstName); sc.Parameters.Add("@Surname", ent.Surname); sc.Parameters.Add("@LastName", ent.LastName); sc.Parameters.Add("@Address", ent.Address); sc.Parameters.Add("@Phone", ent.Phone); sc.Parameters.Add("@NumberJournal", ent.PhysicalNumberJournal); sc.Parameters.Add("@DistrictID", ent.DistrictID); sc.Parameters.Add("@NotPay", ent.NotPay); //sc.Parameters.Add("@RejectVodomer", ent.RejectVodomer); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (dr.Read()) { NewFAbonent ent = new NewFAbonent(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public void EditorMode() { User u = GetCurrentUser(); u.GetPermissions(); //проверяем наличие прав для редактировнаия if (u.ChekPermission("Editor")) { punAdonentEditor.Visible = true; gvJournal.Visible = false; gvJournal2.Visible = true; BindDistricts(); UniversalEntity ue = new UniversalEntity(); NewFAbonent fa = new NewFAbonent(); NewFAbonentDO fado = new NewFAbonentDO(); ue = fado.RetrieveByOrderID(_OrderID); if (ue.Count > 0) { fa = (NewFAbonent)ue[0]; tbNumberJournalPhysical.Text = fa.PhysicalNumberJournal; tbAddress.Text = fa.Address; tbClientSurname.Text = fa.Surname; ddlDistrict.SelectedValue = fa.DistrictID.ToString(); tbClientName.Text = fa.FirstName; tbClientLastName.Text = fa.LastName; tbPhone.Text = fa.Phone; cbNotPay.Checked = fa.NotPay; //cbRejectVodomer.Checked = fa.RejectVodomer; } NewFOrder fo = new NewFOrder(); NewFOrderDO fodDO = new NewFOrderDO(); ue = fodDO.RetrieveFOrderById(_OrderID); if (ue.Count > 0) { fo = (NewFOrder)ue[0]; cbDefectVodomer.Checked = fo.DefectVodomer; } } else { punAdonentEditor.Visible = false; gvJournal.Visible = true; gvJournal2.Visible = false; } }
public bool UpdateAbonent(NewFAbonent ent, int UserID) { bool succes = true; NewFAbonentDAO entDAO = new NewFAbonentDAO(); sc = new SqlCommand("UpdateFAbonent2018"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@UserID", UserID); sc.Parameters.Add("@FAbonentID", ent.ID); sc.Parameters.Add("@FirstName", ent.FirstName); sc.Parameters.Add("@Surname", ent.Surname); sc.Parameters.Add("@LastName", ent.LastName); sc.Parameters.Add("Address", ent.Address); sc.Parameters.Add("@NumberJournal", ent.PhysicalNumberJournal); sc.Parameters.Add("@Phone", ent.Phone); sc.Parameters.Add("@DistrictID", ent.DistrictID); sc.Parameters.Add("@NotPay", ent.NotPay); //sc.Parameters.Add("@RejectVodomer", ent.RejectVodomer); succes = entDAO.updateEntity(sc); return(succes); }
void addParameters(NewFAbonent ent) { AddParametersToSqlCommand(ent, ref sc); }
public void Bind() { EditorMode(); cbSeld.Checked = false; cbSeld.Enabled = true; cbPaid.Checked = false; cbPaid.Enabled = true; cbRejectVodomer.Checked = false; cbRejectVodomer.Enabled = true; cbDefectVodomer.Checked = false; cbDefectVodomer.Enabled = true; tbPaymentDay.Enabled = true; tbPaymentDay.Text = DateTime.Now.ToShortDateString(); NewFOrder fo = new NewFOrder(); NewFOrderDO fodo = new NewFOrderDO(); //StringBuilder sbl = new StringBuilder(); UniversalEntity ue = new UniversalEntity(); ue = fodo.RetrieveFOrderById(_OrderID); if (ue.Count > 0) { fo = (NewFOrder)ue[0]; if (fo.DateOut != null) { cbSeld.Checked = true; cbSeld.Enabled = false; cbPaid.Checked = true; cbPaid.Enabled = false; } if (fo.IsPaid) { cbPaid.Checked = true; cbPaid.Enabled = false; cbSeld.Checked = true; cbSeld.Enabled = false; if (fo.PaymentDay.HasValue) { tbPaymentDay.Text = fo.PaymentDay.Value.ToShortDateString(); } tbPaymentDay.Enabled = false; } if (fo.DefectVodomer) { cbDefectVodomer.Checked = true; cbDefectVodomer.Enabled = false; } } hfODID.Value = _OrderID.ToString(); StringBuilder sb = new StringBuilder(); NewFAbonent fa = new NewFAbonent(); NewFAbonentDO fado = new NewFAbonentDO(); ue = fado.RetrieveByOrderID(_OrderID); if (ue.Count > 0) { fa = (NewFAbonent)ue[0]; if (fa.NotPay) { cbPaid.Enabled = false; btActRubNew.Enabled = false; //btPay.Enabled = false; //btOrder.Enabled = false; //btOrderCheck.Enabled = false; btNewActCheckRub.Enabled = false; //btWithdrawalAct.Enabled = false; } sb.AppendLine("<span>ФИО: " + fa.Surname + " " + fa.FirstName + " " + fa.LastName + "</span><br/>"); sb.AppendLine("<span>номер по журналу: " + fa.PhysicalNumberJournal + "</span><br/>"); sb.AppendLine("<span>Тел.: " + fa.Phone + "</span><br/>"); sb.AppendLine("<span>Адрес: " + fa.Address + "</span><br/>"); if (fa.NotPay) { sb.AppendLine("<span style=\"color:red;font-size:18px;\">Без оплаты</span><br/>"); } litAbonentInfo2018.Text = sb.ToString(); } }
//Сохранение в базу 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 = "*377;08;1;1 Опр. метр. хар."; 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) { NewFAbonent fa = sa.FAbon; NewFAbonentDO fado = new NewFAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; NewFOrder fo = new NewFOrder(); NewFOrderDO fodo = new NewFOrderDO(); fo.ActionType = "*377;08;1;0 Проведение периодической поверки счетчика"; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.Create(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOD2018 fod = new FOD2018(); FOrderDetails2018DO foddo = new FOrderDetails2018DO(); 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.CreateFOrderDetails(fod); } Response.Redirect("FJournal2018.aspx?id=" + foid.ToString()); } } } if (sa.Type == (short)Abonent.Special) { AlternativeAbonent sab = sa.AlternativeAbon; AlternativeAbonentDO sabo = new AlternativeAbonentDO(); int fid = sabo.Create(sab); if (fid > 0) { sa.AlternativeAbon.ID = fid; Session["Abonent"] = sa; AlternativeOrder so = new AlternativeOrder(); AlternativeOrderDO sod = new AlternativeOrderDO(); so.WorkType = "*377;09;1;1 Снятие/установка водомеров."; so.SAbonentID = fid; so.UserID = GetCurrentUser().ID; int soid = sod.CreateSOrder(so); if (soid > 0) { hfOrder.Value = soid.ToString(); AlternativeOrderDetails sd = new AlternativeOrderDetails(); AlternativeOrderDetailsDO sodDO = new AlternativeOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create1(v); sd.SOrderID = soid; sd.VodomerID = vid; sd.StartValue = v.VodomerPreview.StartValue; int uodid = sodDO.Create(sd); } Response.Redirect("SJournal.aspx?id=" + soid.ToString()); } } } // LoadStep3(); } } }
//Добавление абонента физ лицо protected void lbAbonentAdd_Click(object sender, EventArgs e) { Session["Abonent"] = null; SessionAbonent sa = new SessionAbonent(); StringBuilder sb = new StringBuilder(); StringBuilder sbError = new StringBuilder(); if (string.IsNullOrEmpty(tbClientSurname.Text)) { sbError.Append("Необходимо заполнить фамилию.<br/>"); } if (string.IsNullOrEmpty(tbClientName.Text)) { sbError.Append("Необходимо заполнить имя.<br/>"); } if (string.IsNullOrEmpty(tbClientLastName.Text)) { sbError.Append("Необходимо заполнить отчество.<br/>"); } /*if (string.IsNullOrEmpty(tbNumberJournal.Text)) * { * sbError.Append("Необходимо ввести номер по журналу.</br>"); * }*/ if (string.IsNullOrEmpty(tbAddress.Text)) { sbError.Append("Необходимо заполнить адрес.<br/>"); } if (string.IsNullOrEmpty(tbPhone.Text)) { sbError.Append("Необходимо заполнить телефон.<br/>"); } if (ddlDistrict.SelectedValue == "0") { sbError.Append("Необходимо выбрать район.<br/>"); } if (sbError.Length > 0) { //SetMessege("Предупреждение", sbError.ToString()); radWM.RadAlert(sbError.ToString(), null, null, "Предупреждение", ""); } else { if (hfClientType.Value == Abonent.Private.ToString()) { sa.Type = (short)Abonent.Private; NewFAbonent fa = new NewFAbonent(); fa.Surname = tbClientSurname.Text.Trim(); fa.FirstName = tbClientName.Text.Trim(); fa.LastName = tbClientLastName.Text.Trim(); fa.Phone = tbPhone.Text.Trim(); fa.Address = tbAddress.Text.Trim(); fa.PhysicalNumberJournal = tbNumberJournal.Text.Trim(); fa.DistrictID = Convert.ToInt32(ddlDistrict.SelectedValue); fa.NotPay = cbNotPay.Checked; //fa.RejectVodomer = cbRejectVodomer.Checked; sa.FAbon = fa; sb.AppendLine("<b><span>Номер по журналу: " + fa.PhysicalNumberJournal + "</span><br/>"); sb.AppendLine("<b><span>ФИО: " + fa.Surname + " " + fa.FirstName + " " + fa.Surname + "</span><br/>"); sb.AppendLine("<span>Тел.: " + fa.Phone + "</span><br/>"); sb.AppendLine("<span>Адрес: " + fa.Address + "</span><br/></b>"); if (fa.NotPay) { sb.AppendLine("<span>Без оплаты</span><br/>"); } /*if (fa.RejectVodomer) * { * sb.AppendLine("<span>Брак</span><br/>"); * }*/ litAbonentInfo.Text = sb.ToString(); } Session["Abonent"] = sa; ClearFAbonentForm(); Step1.Visible = false; Step2.Visible = true; radgridD.Rebind(); } }
//Сохранение в базу 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) { NewFAbonent fa = sa.FAbon; NewFAbonentDO fado = new NewFAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; FOrder2018 fo = new FOrder2018(); FOrder2018DO fodo = new FOrder2018DO(); fo.ActionType = "Определения метрологических характеристик водомера."; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.CreateFOrder(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOD2018 fod = new FOD2018(); FOrderDetails2018DO foddo = new FOrderDetails2018DO(); 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.CreateFOrderDetails(fod); } } } } if (sa.Type == (short)Abonent.Special) { AlternativeAbonent sab = sa.AlternativeAbon; AlternativeAbonentDO sabo = new AlternativeAbonentDO(); int fid = sabo.Create(sab); if (fid > 0) { sa.AlternativeAbon.ID = fid; Session["Abonent"] = sa; AlternativeOrder so = new AlternativeOrder(); AlternativeOrderDO sod = new AlternativeOrderDO(); so.WorkType = "Снятие/установка водомеров."; so.SAbonentID = fid; so.UserID = GetCurrentUser().ID; int soid = sod.CreateSOrder(so); if (soid > 0) { hfOrder.Value = soid.ToString(); AlternativeOrderDetails sd = new AlternativeOrderDetails(); AlternativeOrderDetailsDO sodDO = new AlternativeOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); sd.SOrderID = soid; sd.VodomerID = vid; sd.StartValue = v.VodomerPreview.StartValue; int uodid = sodDO.Create(sd); } } } } //SetMessege("Статус", "Абонент и водомер успешно внесены в базу."); LoadStep3(); } } }