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();
}
}
}
