コード例 #1
0
ファイル: RemarkModel.cs プロジェクト: sbunlimited/itraacv2-1
        static public void SaveRemarks(string ownerGUIDFieldName, string ownerGUID, string userMessagePrefix, DataView v)
        {
            if (v == null)
            {
                return;
            }

            string savefilter = v.RowFilter;

            v.RowFilter = "";

// ReSharper disable InconsistentNaming
            using (var Remark_u = new iTRAACProc("Remark_u"))
// ReSharper restore InconsistentNaming
                foreach (var remark in v.Cast <DataRowView>().Where(remark => remark.IsDirty()))
                {
                    Remark_u.AssignValues(remark);
                    if (!Remark_u.ExecuteNonQuery(userMessagePrefix + " Save Remark: "))
                    {
                        continue;
                    }
                    remark["RowGUID"] = Remark_u["@RowGUID"]; //for inserts
                    remark.AcceptChanges();
                }
            v.RowFilter = savefilter;
        }
コード例 #2
0
        protected bool SaveMe(bool isFiling = false, bool updateSponsor = true)
        {
            // generally, inserts and deletes will be edge cases handled elsewhere, modified fields on existing rows are the primary save scenario for child lists hanging off main entities like TaxForm (e.g. TaxFormRemarks)

            //pulling back on this for now... seems theoretically possible to save a pending NF2 with un-printed status just like NF1's, it's not "issued" until it's printed
            //if (IsClass2 && !Validate())
            //{
            //  ShowUserMessage("It is invalid to save an NF2/EF2 that's not fully completed.");
            //  return (false);
            //}

            if (Fields.IsDirty()) //the "Fields" logic does actually need to be here if called from FileForm() rather than base.Save();
            {
// ReSharper disable InconsistentNaming
                using (var TaxForm_u = new iTRAACProc("TaxForm_u"))
// ReSharper restore InconsistentNaming
                {
                    TaxForm_u.AssignValues(Fields);
                    TaxForm_u["@IsFiling"] = isFiling;
                    if (!TaxForm_u.ExecuteDataSet(UserMessagePrefix))
                    {
                        return(false);
                    }
                    Fields.AcceptChanges();
                    if (isFiling)
                    {
                        CacheTables(TaxForm_u);
                    }
                }

                if (updateSponsor)
                {
                    OnFormStatusChange();
                }
            }

            if (ExtendedFields.IsDirty())
            {
// ReSharper disable InconsistentNaming
                using (var TaxForm_TransactionTypeExt_u = new Proc("TaxForm_TransactionTypeExt_u"))
// ReSharper restore InconsistentNaming
                {
                    TaxForm_TransactionTypeExt_u.AssignValues(ExtendedFields);
                    TaxForm_TransactionTypeExt_u["@TaxFormGUID"] = GUID;
                    if (!TaxForm_TransactionTypeExt_u.ExecuteNonQuery(UserMessagePrefix))
                    {
                        return(false);
                    }
                }
                ExtendedFields.AcceptChanges();
            }

            RemarkModel.SaveRemarks("FKRowGUID", GUID, UserMessagePrefix, TaxFormRemarks);

            return(true);
        }
コード例 #3
0
        protected override bool SaveSubClass()
        {
            bool success = true;

            if (Fields.IsDirty())
            {
                using (var taxOfficeU = new iTRAACProc("TaxOffice_u"))
                {
                    if (taxOfficeU.AssignValues(Current.Fields).ExecuteNonQuery("Tax Office - ", true))
                    {
                        Fields.AcceptChanges();
                    }
                    else
                    {
                        success = false;
                    }
                }
            }

            if (UserTable.GetChanges() != null)
            {
                using (var userU = new iTRAACProc("User_u"))
                {
                    foreach (DataRowView r in from DataRowView r in UserTable.DefaultView where r.IsDirty() select r)
                    {
                        if (userU.AssignValues(r).ExecuteNonQuery(String.Format("Saving User: {0} - ", r["UserNameId"])))
                        {
                            r.AcceptChanges();
                        }
                        else
                        {
                            success = false;
                        }
                    }
                }
            }

            return(success);
        }
コード例 #4
0
        private bool SaveJustSponsorRecord()
        {
// ReSharper disable InconsistentNaming
            using (var Sponsor_u = new iTRAACProc("Sponsor_u"))
// ReSharper restore InconsistentNaming
            {
                Fields.Row.SetAllNonDBNullColumnsToEmptyString("-");
                try
                {
                    Sponsor_u.AssignValues(Fields);
                    if (!Sponsor_u.ExecuteDataSet(UserMessagePrefix))
                    {
                        return(false);                                      //base class clears "Fields" dirty flags for us
                    }
                    CacheTables(Sponsor_u);
                }
                finally
                {
                    Fields.Row.RemoveEmptyPlaceholder("-");
                }
            }
            return(true);
        }
コード例 #5
0
ファイル: SponsorModel.cs プロジェクト: dggowda047/itraacv2-1
    private bool SaveJustSponsorRecord()
    {
// ReSharper disable InconsistentNaming
      using (var Sponsor_u = new iTRAACProc("Sponsor_u"))
// ReSharper restore InconsistentNaming
      {
        Fields.Row.SetAllNonDBNullColumnsToEmptyString("-");
        try
        {
          Sponsor_u.AssignValues(Fields);
          if (!Sponsor_u.ExecuteDataSet(UserMessagePrefix)) return (false); //base class clears "Fields" dirty flags for us
          CacheTables(Sponsor_u);
        }
        finally
        {
          Fields.Row.RemoveEmptyPlaceholder("-");
        }
      }
      return (true);
    }
コード例 #6
0
ファイル: SponsorModel.cs プロジェクト: dggowda047/itraacv2-1
    protected override bool SaveSubClass()
    {
      //validate everything first so we see all the red boxes at once... 
      var isValid = true;

      ValidateGeneric(ref isValid, "Rank");
      ValidateGeneric(ref isValid, "DEROS");
      ValidateGeneric(ref isValid, "DutyLocation");

      ValidateGeneric(ref isValid, "DutyPhoneDSN1", "'?'.Length == 3", "Enter 3 Digits");
      ValidateGeneric(ref isValid, "DutyPhoneDSN2", "'?'.Length == 4", "Enter 4 Digits");

      ValidateGeneric(ref isValid, "OfficialMailCMR");
      ValidateGeneric(ref isValid, "OfficialMailBox");
      ValidateGeneric(ref isValid, "OfficialMailCity");
      ValidateGeneric(ref isValid, "OfficialMailState");
      ValidateGeneric(ref isValid, "OfficialMailZip", "'?'.Length == 5", "Enter 5 Digits");

      ValidateGeneric(ref isValid, "HomePhoneCountry");
      ValidateGeneric(ref isValid, "HomePhone");

      var validateUTAP = Fields.Field<bool>("IsUTAPActive");
      ValidateGeneric(Fields, ref isValid, "HomeStreet,IsUTAPActive", validateUTAP);
      ValidateGeneric(Fields, ref isValid, "HomeStreetNumber,IsUTAPActive", validateUTAP);
      ValidateGeneric(Fields, ref isValid, "HomeCity,IsUTAPActive", validateUTAP);
      ValidateGeneric(Fields, ref isValid, "HomePostal,IsUTAPActive", validateUTAP);

      foreach(DataRowView member in HouseMembers)
      {
        ValidateGeneric(member, ref isValid, "SSN1", true, "'?'.Length == 3", "Enter 3 Digits");
        ValidateGeneric(member, ref isValid, "SSN2", true, "'?'.Length == 2", "Enter 2 Digits");
        ValidateGeneric(member, ref isValid, "SSN3", true, "'?'.Length == 4", "Enter 4 Digits");
        if (ValidateGeneric(member, ref isValid, "FName"))
          ValidateGeneric(member, ref isValid, "FName", true, "'?' != '?'.toUpperCase()", "Use proper uppper/lower casing for all names.\nForms will automatically print in all upper case.");
        if (ValidateGeneric(member, ref isValid, "LName"))
          ValidateGeneric(member, ref isValid, "LName", true, "'?' != '?'.toUpperCase()", "Use proper uppper/lower casing for all names.\nForms will automatically print in all upper case.");
      }

      if (!isValid)
      {
        ShowUserMessage("Please correct all highlighted fields before saving.");
        return (false);
      }

      //then save attempt to save everything if we made it through all the validation...
      if (Fields.IsDirty()) if (!SaveJustSponsorRecord()) return (false);

      foreach (var member in HouseMembers.Cast<DataRowView>().Where(member => member.IsDirty()))
// ReSharper disable InconsistentNaming
        using (Proc Client_u = new iTRAACProc("Client_u"))
// ReSharper restore InconsistentNaming
        {
          Client_u.AssignValues(member);
          if (!Client_u.ExecuteDataSet(UserMessagePrefix)) return (false);
          member.AcceptChanges();
          CacheTables(Client_u);
        }

      RemarkModel.SaveRemarks("SponsorGUID", GUID, UserMessagePrefix, SponsorRemarks);

      return (true);
    }
コード例 #7
0
        protected override bool SaveSubClass()
        {
            //validate everything first so we see all the red boxes at once...
            var isValid = true;

            ValidateGeneric(ref isValid, "Rank");
            ValidateGeneric(ref isValid, "DEROS");
            ValidateGeneric(ref isValid, "DutyLocation");

            ValidateGeneric(ref isValid, "DutyPhoneDSN1", "'?'.Length == 3", "Enter 3 Digits");
            ValidateGeneric(ref isValid, "DutyPhoneDSN2", "'?'.Length == 4", "Enter 4 Digits");

            ValidateGeneric(ref isValid, "OfficialMailCMR");
            ValidateGeneric(ref isValid, "OfficialMailBox");
            ValidateGeneric(ref isValid, "OfficialMailCity");
            ValidateGeneric(ref isValid, "OfficialMailState");
            ValidateGeneric(ref isValid, "OfficialMailZip", "'?'.Length == 5", "Enter 5 Digits");

            ValidateGeneric(ref isValid, "HomePhoneCountry");
            ValidateGeneric(ref isValid, "HomePhone");

            var validateUTAP = Fields.Field <bool>("IsUTAPActive");

            ValidateGeneric(Fields, ref isValid, "HomeStreet,IsUTAPActive", validateUTAP);
            ValidateGeneric(Fields, ref isValid, "HomeStreetNumber,IsUTAPActive", validateUTAP);
            ValidateGeneric(Fields, ref isValid, "HomeCity,IsUTAPActive", validateUTAP);
            ValidateGeneric(Fields, ref isValid, "HomePostal,IsUTAPActive", validateUTAP);

            foreach (DataRowView member in HouseMembers)
            {
                ValidateGeneric(member, ref isValid, "SSN1", true, "'?'.Length == 3", "Enter 3 Digits");
                ValidateGeneric(member, ref isValid, "SSN2", true, "'?'.Length == 2", "Enter 2 Digits");
                ValidateGeneric(member, ref isValid, "SSN3", true, "'?'.Length == 4", "Enter 4 Digits");
                if (ValidateGeneric(member, ref isValid, "FName"))
                {
                    ValidateGeneric(member, ref isValid, "FName", true, "'?' != '?'.toUpperCase()", "Use proper uppper/lower casing for all names.\nForms will automatically print in all upper case.");
                }
                if (ValidateGeneric(member, ref isValid, "LName"))
                {
                    ValidateGeneric(member, ref isValid, "LName", true, "'?' != '?'.toUpperCase()", "Use proper uppper/lower casing for all names.\nForms will automatically print in all upper case.");
                }
            }

            if (!isValid)
            {
                ShowUserMessage("Please correct all highlighted fields before saving.");
                return(false);
            }

            //then save attempt to save everything if we made it through all the validation...
            if (Fields.IsDirty())
            {
                if (!SaveJustSponsorRecord())
                {
                    return(false);
                }
            }

            foreach (var member in HouseMembers.Cast <DataRowView>().Where(member => member.IsDirty()))
            {
// ReSharper disable InconsistentNaming
                using (Proc Client_u = new iTRAACProc("Client_u"))
// ReSharper restore InconsistentNaming
                {
                    Client_u.AssignValues(member);
                    if (!Client_u.ExecuteDataSet(UserMessagePrefix))
                    {
                        return(false);
                    }
                    member.AcceptChanges();
                    CacheTables(Client_u);
                }
            }

            RemarkModel.SaveRemarks("SponsorGUID", GUID, UserMessagePrefix, SponsorRemarks);

            return(true);
        }
コード例 #8
0
    protected override bool SaveSubClass()
    {
      bool success = true;

      if (Fields.IsDirty())
      {
        using (var taxOfficeU = new iTRAACProc("TaxOffice_u"))
        {
          if (taxOfficeU.AssignValues(Current.Fields).ExecuteNonQuery("Tax Office - ", true))
            Fields.AcceptChanges();
          else success = false;
        }
      }

      if (UserTable.GetChanges() != null)
      {
        using (var userU = new iTRAACProc("User_u"))
        {
          foreach (DataRowView r in from DataRowView r in UserTable.DefaultView where r.IsDirty() select r)
          {
            if (userU.AssignValues(r).ExecuteNonQuery(String.Format("Saving User: {0} - ", r["UserNameId"])))
              r.AcceptChanges();
            else success = false;
          }
        }
      }

      return (success);
    }
コード例 #9
0
ファイル: TaxFormModel.cs プロジェクト: dggowda047/itraacv2-1
    protected bool SaveMe(bool isFiling = false, bool updateSponsor = true)
    {
      // generally, inserts and deletes will be edge cases handled elsewhere, modified fields on existing rows are the primary save scenario for child lists hanging off main entities like TaxForm (e.g. TaxFormRemarks)

      //pulling back on this for now... seems theoretically possible to save a pending NF2 with un-printed status just like NF1's, it's not "issued" until it's printed
      //if (IsClass2 && !Validate())
      //{
      //  ShowUserMessage("It is invalid to save an NF2/EF2 that's not fully completed.");
      //  return (false);
      //}

      if (Fields.IsDirty()) //the "Fields" logic does actually need to be here if called from FileForm() rather than base.Save();
      {
// ReSharper disable InconsistentNaming
        using (var TaxForm_u = new iTRAACProc("TaxForm_u"))
// ReSharper restore InconsistentNaming
        {
          TaxForm_u.AssignValues(Fields);
          TaxForm_u["@IsFiling"] = isFiling;
          if (!TaxForm_u.ExecuteDataSet(UserMessagePrefix)) return (false);
          Fields.AcceptChanges();
          if (isFiling) CacheTables(TaxForm_u);
        }

        if (updateSponsor) OnFormStatusChange();
      }

      if (ExtendedFields.IsDirty())
      {
// ReSharper disable InconsistentNaming
        using (var TaxForm_TransactionTypeExt_u = new Proc("TaxForm_TransactionTypeExt_u"))
// ReSharper restore InconsistentNaming
        {
          TaxForm_TransactionTypeExt_u.AssignValues(ExtendedFields);
          TaxForm_TransactionTypeExt_u["@TaxFormGUID"] = GUID;
          if (!TaxForm_TransactionTypeExt_u.ExecuteNonQuery(UserMessagePrefix)) return (false);
        }
        ExtendedFields.AcceptChanges();
      }

      RemarkModel.SaveRemarks("FKRowGUID", GUID, UserMessagePrefix, TaxFormRemarks);

      return (true);
    }
コード例 #10
0
ファイル: RemarkModel.cs プロジェクト: dggowda047/itraacv2-1
    static public void SaveRemarks(string ownerGUIDFieldName, string ownerGUID, string userMessagePrefix, DataView v)
    {
      if (v == null) return;

      string savefilter = v.RowFilter;
      v.RowFilter = "";

// ReSharper disable InconsistentNaming
      using (var Remark_u = new iTRAACProc("Remark_u"))
// ReSharper restore InconsistentNaming
      foreach (var remark in v.Cast<DataRowView>().Where(remark => remark.IsDirty()))
      {
        Remark_u.AssignValues(remark);
        if (!Remark_u.ExecuteNonQuery(userMessagePrefix + " Save Remark: ")) continue;
        remark["RowGUID"] = Remark_u["@RowGUID"]; //for inserts
        remark.AcceptChanges();
      }
      v.RowFilter = savefilter;
    }