public bool UpdateFOrder(FOrder2018 ent)
{
/*bool success = true;
* FOrder2018DAO entDAO = new FOrder2018DAO();
* sc = new SqlCommand("UpdateFOrder2018");
* sc.CommandType = CommandType.StoredProcedure;
* sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer);
* sc.Parameters.Add("@UserID", ent.UserID);
* sc.Parameters.Add("@IsPaid", ent.IsPaid);
* if (ent.DateOut == null)
* {
* sc.Parameters.Add("@DateOut", DBNull.Value);
* }
* else
* {
* sc.Parameters.Add("@DateOut", ent.DateOut);
* }
* if (ent.PaymentDay == null)
* {
* sc.Parameters.Add("@PaymentDay", DBNull.Value);
* }
* else
* {
* sc.Parameters.Add("@PaymentDay", ent.PaymentDay);
* }
* success = (entDAO.updateEntity(sc));
* return success;*/
bool success = true;
FOrder2018DAO entDAO = new FOrder2018DAO();
sc = new SqlCommand("UpdateFOrder2018");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@ID", ent.ID);
sc.Parameters.Add("@IsPaid", ent.IsPaid);
sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer);
sc.Parameters.Add("@UserID", ent.UserID);
if (ent.DateOut == null)
{
sc.Parameters.Add("@DateOut", DBNull.Value);
}
else
{
sc.Parameters.Add("@DateOut", ent.DateOut);
}
if (ent.PaymentDay == null)
{
sc.Parameters.Add("@PaymentDay", DBNull.Value);
}
else
{
sc.Parameters.Add("@PaymentDay", ent.PaymentDay.Value);
}
//addParameters(ent);
success = entDAO.updateEntity(sc);
return(success);
}
public FOrder2018 createEntityFromReader(SqlDataReader dr)
{
FOrder2018 ent = new FOrder2018();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
ent.ID = Convert.ToInt32(dr["ID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("FAbonentID")))
{
ent.FAbonentID = Convert.ToInt32(dr["FAbonentID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("DateIn")))
{
ent.DateIn = Convert.ToDateTime(dr["DateIn"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("DateOut")))
{
ent.DateOut = Convert.ToDateTime(dr["DateOut"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("Comment")))
{
ent.Comment = dr["Comment"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("IsPaid")))
{
ent.IsPaid = Convert.ToBoolean(dr["IsPaid"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("ActionType")))
{
ent.ActionType = dr["ActionType"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("PaymentDay")))
{
ent.PaymentDay = Convert.ToDateTime(dr["PaymentDay"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("UserID")))
{
ent.UserID = Convert.ToInt32(dr["UserID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("DefectVodomer")))
{
ent.DefectVodmer = Convert.ToBoolean(dr["DefectVodomer"]);
}
return(ent);
}
public int CreateFOrder(FOrder2018 ent)
{
int createid = 0;
FOrder2018DAO entDAO = new FOrder2018DAO();
sc = new SqlCommand("CreateFOrder2018");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createid = (entDAO.createEntity(sc));
return(createid);
}
void AddParametersToSqlCommand(FOrder2018 ent, ref SqlCommand sc)
{
sc.Parameters.Add("@FAbonentID", ent.FAbonentID);
//sc.Parameters.Add("@DateIn", ent.DateIn);
//sc.Parameters.Add("@DateOut", ent.DateOut);
//sc.Parameters.Add("@Comment", ent.Comment);
//sc.Parameters.Add("@IsPaid", ent.IsPaid);
sc.Parameters.Add("@ActionType", ent.ActionType);
//sc.Parameters.Add("@PaymentDay", ent.PaymentDay);
sc.Parameters.Add("@UserID", ent.UserID);
//sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer);
}
public override UniversalEntity createEntity()
{
UniversalEntity ue = new UniversalEntity();
while (!dr.Read())
{
FOrder2018 ent = new FOrder2018();
ent = createEntityFromReader(dr);
ue.Add(ent);
}
return(ue);
}
void addParameters(FOrder2018 ent)
{
AddParametersToSqlCommand(ent, ref sc);
}
//Сохранение в базу
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();
}
}
}
