private void lkpDestination_EditValueChanged(object sender, EventArgs e) { if (CurrentModel == null) { return; } var cityDataManager = new CityDataManager(); var countryDataManager = new CountryDataManager(); var cityModel = cityDataManager.GetFirst <CityModel>(WhereTerm.Default(lkpDestination.Value ?? 0, "Id")); if (cityModel != null) { var countryModel = countryDataManager.GetFirst <CountryModel>(WhereTerm.Default(cityModel.CountryId, "Id")); if (countryModel != null) { ((ShipmentModel)CurrentModel).PricingPlanId = countryModel.PricingPlanId; } } cityDataManager.Dispose(); countryDataManager.Dispose(); RefreshTariff(); }
protected override void BeforeFilter() { var param = new List <WhereTerm>(); param.Add(WhereTerm.Default(BaseControl.CorporateId, "corporate_id", EnumSqlOperator.Equals)); // ReSharper disable once ConditionIsAlwaysTrueOrFalse var dateNull = new DateTime(1900, 1, 1, 0, 0, 0); if (tbxFrom.Value > dateNull) { var fdate = new DateTime(tbxFrom.Value.Year, tbxFrom.Value.Month, tbxFrom.Value.Day, 0, 0, 0); param.Add(WhereTerm.Default(fdate, "date_process", EnumSqlOperator.GreatThanEqual)); } // ReSharper disable once ConditionIsAlwaysTrueOrFalse if (tbxTo.Value > dateNull) { var ldate = new DateTime(tbxTo.Value.Year, tbxTo.Value.Month, tbxTo.Value.Day, 23, 59, 59); param.Add(WhereTerm.Default(ldate, "date_process", EnumSqlOperator.LesThanEqual)); } // ReSharper disable once CoVariantArrayConversion if (param.Any()) { AutoCompleteWheretermFormater = param.ToArray(); } }
private static List <CorporateUserPrivilegeModel> GetPrivileges() { using (var dm = new CorporateUserPrivilegeDataManager()) { return(dm.Get <CorporateUserPrivilegeModel>(WhereTerm.Default(CorporateUserId, "corporate_user_id")).ToList()); } }
protected override void Filter(object sender, System.EventArgs e) { base.Filter(sender, e); if (EmployeeType != EmployeeModel.EmployeeType.All) { var toAdd = new List <IListParameter>(); toAdd.Add(WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals)); switch (EmployeeType) { case EmployeeModel.EmployeeType.CustomerService: toAdd.Add(WhereTerm.Default(true, "as_customer_service")); break; case EmployeeModel.EmployeeType.Messenger: toAdd.Add(WhereTerm.Default(true, "as_messenger")); break; case EmployeeModel.EmployeeType.Marketing: toAdd.Add(WhereTerm.Default(true, "as_marketing")); break; } AutoCompleteWheretermFormater = AutoCompleteWheretermFormater.Concat(toAdd).ToArray(); } var model = GotoFirstPage <EmployeeModel>(sender, e); objGrid.DataSource = model; NavigatorPagingState = PagingState; }
protected override void BeforeNew() { ClearForm(); tbxTtlPiece.Value = 1; tbxTtlGrossWeight.Value = 1; tbxTtlChargeable.Value = 1; tbxTariff.Value = 0; tbxHandlingFee.Value = 0; tbxTtlTariff.Value = 0; tbxTariffNet.Value = 0; tbxL.Value = 1; tbxW.Value = 1; tbxH.Value = 1; tbxOther.Value = 0; tbxGoodsValue.Value = 0; tbxInsurance.Value = 0; tbxGrandTotal.Value = 0; tbxDate.DateTime = DateTime.Now; lkpPackage.DefaultValue = new IListParameter[] { WhereTerm.Default("PARCEL", "name") }; lkpService.DefaultValue = new IListParameter[] { WhereTerm.Default("REGULAR", "name") }; lkpPayment.DefaultValue = new IListParameter[] { WhereTerm.Default("COLLECT", "name") }; lkpDestination.Focus(); }
private static List <FranchiseUserPrivilegeModel> GetPrivileges() { using (var dm = new FranchiseUserPrivilegeDataManager()) { return(dm.Get <FranchiseUserPrivilegeModel>(WhereTerm.Default(FranchiseUserId, "franchise_user_id")).ToList()); } }
private void Login(object sender, EventArgs e) { BaseControl.OpenForm(new LoginForm(), true); if (BaseControl.UserId > 0) { VisibleMenuItem(true); LoginButtons(false); tsDate.Text = DateTime.Now.ToString("dddd, yyyy-MMM-d"); tsUser.Text = BaseControl.UserLogin; tsCorporate.Text = BaseControl.CorporateName; var runningText = new RunningTextDataManager().GetRunningText(WhereTerm.Default(1, "announcement_type", EnumSqlOperator.Equals)); var text = ConfigurationManager.AppSettings["DefaultAnnouncement"]; if (DynamicQueryable.Any(runningText)) { var rFranchise = runningText.FirstOrDefault(r => r.CorporateId == BaseControl.CorporateId); if (rFranchise != null) { text = rFranchise.Name; } var rDate = runningText.FirstOrDefault(r => r.FromDate >= DateTime.Now && r.ToDate <= DateTime.Now && r.FromHour >= DateTime.Now.Hour && r.FromMinute >= DateTime.Now.Minute && r.ToHour <= DateTime.Now.Minute && r.ToMinute <= DateTime.Now.Minute); if (rDate != null) { text = rDate.Name; } } tsAnnouncement.MarqueeText = text; tsAnnouncement.Interval = 300; Authorization.FilterToolstripMenu(ms.Items); } }
private string HeaderDotMetrix(int hal) { string print = File.ReadAllText(@"ShipmentListPrint.txt"); // ReSharper disable InconsistentNaming var customer_name = "-"; var dest_city = "-"; var payment_method = "-"; var from_date = "-"; var to_date = "-"; // ReSharper restore InconsistentNaming customer_name = BaseControl.CorporateName; if (tbxDestination.Value != null) { dest_city = new CityDataManager().GetFirst <CityModel>(WhereTerm.Default((int)tbxDestination.Value, "id", EnumSqlOperator.Equals)).Name; } from_date = tbxFrom.Value.ToString("dd-MM-yyyy"); to_date = tbxTo.Value.ToString("dd-MM-yyyy"); print = print.Replace("{CUSTOMER_NAME}", customer_name); print = print.Replace("{DEST_CITY}", dest_city); print = print.Replace("{PAYMENT_METHOD}", payment_method); print = print.Replace("{FROM_DATE}", from_date); print = print.Replace("{TO_DATE}", to_date); print = print.Replace("{HAL}", hal.ToString("#").PadLeft(3, ' ') + string.Format("{0}", (char)15)); return(print); }
private void ShipmentListLoad(object sender, EventArgs e) { _ClearForm(panel1); tbxDestination.LookupPopup = new CityPopup(); tbxDestination.AutoCompleteDataManager = new CityDataManager(); tbxDestination.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; tbxDestination.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; tbxCustomer.LookupPopup = new CustomerPopup(new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals), WhereTerm.Default("0", "disabled", EnumSqlOperator.Equals), WhereTerm.Default(BaseControl.FranchiseId, "franchise_id", EnumSqlOperator.Equals) }); tbxCustomer.AutoCompleteDataManager = new CustomerDataManager(); tbxCustomer.AutoCompleteDisplayFormater = model => ((CustomerModel)model).Code + " - " + ((CustomerModel)model).Name; tbxCustomer.AutoCompleteWhereExpression = (s, p) => p.SetWhereExpression("(code = @0 OR name.StartsWith(@0)) AND branch_id = @1 AND disabled = @2 AND franchise_id = @3", s, BaseControl.BranchId, "0", BaseControl.FranchiseId); tbxFrom.Text = DateTime.Now.ToString(CultureInfo.InvariantCulture); tbxTo.Text = DateTime.Now.ToString(CultureInfo.InvariantCulture); btnPrint.Click += Print; }
public PickupPopup() { InitializeComponent(); var clDate = new GridColumn { Name = "clDate", Caption = @"Date", FieldName = "DateProcess", VisibleIndex = 0, Width = 60 }; clDate.DisplayFormat.FormatString = "dd-MM-yyyy"; clDate.DisplayFormat.FormatType = FormatType.DateTime; var clCode = new GridColumn { Name = "clCode", Caption = @"Code", FieldName = "Code", VisibleIndex = 1, Width = 75 }; SearchView.Columns.AddRange(new[] { clDate, clCode }); SearchView.GridControl = GridSearch; Load += OnLoad; DataManager.DefaultParameters = new IListParameter[] { WhereTerm.Default(BaseControl.CorporateId, "corporate_id", EnumSqlOperator.Equals) }; }
private bool CheckCn() { var ship = DataManager.GetFirst <ShipmentModel>(WhereTerm.Default(tbxNo.Text, "code", EnumSqlOperator.Equals)); if (ship != null) { if (ship.Id != CurrentModel.Id) { MessageBox.Show(Resources.cn_exists, Resources.title_information, MessageBoxButtons.OK); tbxNo.Text = string.Empty; tbxNo.Focus(); return(false); } } if (tbxNo.Text.Length > 4 && !((ShipmentDataManager)DataManager).CheckPrefixBranchShipment(BaseControl.BranchId, tbxNo.Text, true)) { MessageBox.Show(Resources.invalid_stt, Resources.invalid_stt_title, MessageBoxButtons.OK); tbxNo.Text = string.Empty; tbxNo.Focus(); return(false); } return(true); }
protected override void PopulateForm(FranchisePickupModel model) { ClearForm(); tbxSearch_Code.Text = model.Code; tbxDate.DateTime = model.DateProcess; tbxTtlPod.Value = model.TtlPod; tbxTtlPiece.Value = model.TtlPiece; tbxTtlWeight.Value = model.TtlGrossWeight; tbxTtlChargeable.Value = model.TtlChargeable; Balance = model.Balance; cbxSetoran.SelectedIndex = model.PaymentTypeAgent; if (model.MessengerId != null) { tbxMessenger.DefaultValue = new IListParameter[] { WhereTerm.Default((int)model.MessengerId, "id") }; } if (model.IsPrint) { rbData_Save.Enabled = false; rbData_Delete.Enabled = false; EnabledForm(false); } PodGrid.DataSource = new FranchisePickupDetailDataManager().GetPickupDetail(model.Id); PodGrid.Refresh(); }
private void Login(object sender, EventArgs e) { UseWaitCursor = true; if (tbxUsername.Text == "") { MessageBox.Show(Resources.empty_username, Resources.title_information); UseWaitCursor = false; return; } var dm = new CorporateUserDataManager(); var user = dm.Login(tbxUsername.Text, tbxPassword.Text, BaseControl.CorporateId); if (user != null) { var em = new CustomerDataManager(); var corporate = em.GetFirst <CustomerModel>(WhereTerm.Default(user.CorporateId, "id", EnumSqlOperator.Equals)); if (corporate != null) { BaseControl.UserId = user.Id; BaseControl.UserLogin = user.UserName; BaseControl.CorporateName = corporate.Name; BaseControl.BranchId = corporate.BranchId; var branch = new BranchDataManager().GetFirst <BranchModel>(WhereTerm.Default(corporate.BranchId, "id", EnumSqlOperator.Equals)); BaseControl.CityId = branch.CityId; BaseControl.BranchCode = branch.Code; var city = new CityDataManager().GetFirst <CityModel>(WhereTerm.Default(branch.CityId, "id", EnumSqlOperator.Equals)); BaseControl.CityName = city.Name; BaseControl.CountryId = city.CountryId; var country = new CountryDataManager().GetFirst <CountryModel>(WhereTerm.Default(city.CountryId, "id", EnumSqlOperator.Equals)); BaseControl.CountryName = country.Name; Authorization.SetCorporateUserId(BaseControl.UserId); Dispose(); } else { MessageBox.Show(string.Format("{0} {1}", Resources.franchise_account_not_found, Resources.contact_it_support), Resources.title_information); } } else { MessageBox.Show(Resources.invalid_login, Resources.title_login_failed); } UseWaitCursor = false; }
protected override void BeforeFilter() { var param = new List <WhereTerm>(); param.Add(WhereTerm.Default(BaseControl.BranchId, "BranchId", EnumSqlOperator.Equals)); param.Add(WhereTerm.Default(BaseControl.FranchiseId, "FranchiseId", EnumSqlOperator.Equals)); // ReSharper disable once ConditionIsAlwaysTrueOrFalse var dateNull = new DateTime(1900, 1, 1, 0, 0, 0); if (tbxFrom.Value > dateNull) { var fdate = new DateTime(tbxFrom.Value.Year, tbxFrom.Value.Month, tbxFrom.Value.Day, 0, 0, 0); param.Add(WhereTerm.Default(fdate, "PickupDate", EnumSqlOperator.GreatThanEqual)); } // ReSharper disable once ConditionIsAlwaysTrueOrFalse if (tbxTo.Value > dateNull) { var ldate = new DateTime(tbxTo.Value.Year, tbxTo.Value.Month, tbxTo.Value.Day, 23, 59, 59); param.Add(WhereTerm.Default(ldate, "PickupDate", EnumSqlOperator.LesThanEqual)); } if (!string.IsNullOrEmpty(tbxPod.Text)) { param.Add(WhereTerm.Default(tbxPod.Text, "ShipmentCode", EnumSqlOperator.Equals)); } // ReSharper disable once CoVariantArrayConversion if (param.Any()) { AutoCompleteWheretermFormater = param.ToArray(); } }
private void TariffLoad(object sender, EventArgs e) { lkpOrigin.LookupPopup = new ConsigneePopup(); lkpOrigin.AutoCompleteDataManager = new CityDataManager(); lkpOrigin.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; lkpOrigin.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; lkpOrigin.FieldLabel = "Origin City"; lkpOrigin.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) }; lkpDestination.LookupPopup = new ConsigneePopup(); lkpDestination.AutoCompleteDataManager = new CityDataManager(); lkpDestination.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; lkpDestination.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; lkpDestination.FieldLabel = "Destination City"; lkpDestination.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) }; lkpOrigin.Focus(); ClearForm(); btnFind.Click += ShowTariff; }
protected override ConsigneeModel Find(string searchTerm) { if (string.IsNullOrEmpty(searchTerm)) { return(new ConsigneeModel()); } return(DataManager.GetFirst <ConsigneeModel>(WhereTerm.Default(Convert.ToInt32(searchTerm), "id"), WhereTerm.Default(BaseControl.CorporateId, "corporate_id"))); }
private void OnLoad(object sender, EventArgs e) { tbxDestination.LookupPopup = new CityPopup(); tbxDestination.AutoCompleteDataManager = new CityDataManager(); tbxDestination.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; tbxDestination.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; }
public ShipmentPopup() { InitializeComponent(); var clDate = new GridColumn { Name = "clDate", Caption = @"Date", FieldName = "DateProcess", VisibleIndex = 0, Width = 60 }; clDate.DisplayFormat.FormatString = "dd-MM-yyyy"; clDate.DisplayFormat.FormatType = FormatType.DateTime; var clCode = new GridColumn { Name = "clCode", Caption = @"Code", FieldName = "Code", VisibleIndex = 1, Width = 75 }; var clOrigin = new GridColumn { Name = "clOrigin", Caption = @"Origin", FieldName = "CityName", VisibleIndex = 2 }; var clDestination = new GridColumn { Name = "clDestination", Caption = @"Destination", FieldName = "DestCity", VisibleIndex = 3 }; var clCustomer = new GridColumn { Name = "clCustomer", Caption = @"Customer", FieldName = "CustomerName", VisibleIndex = 3 }; SearchView.Columns.AddRange(new[] { clDate, clCode, clOrigin, clDestination, clCustomer }); SearchView.GridControl = GridSearch; Load += OnLoad; DataManager.DefaultParameters = new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals) }; }
public void OpenLookupPopup() { if (LookupPopup != null && Enabled) { ((BaseForm)LookupPopup).ShowDialog(); if (LookupPopup.SelectedValue > 0) { DefaultValue = new IListParameter[] { WhereTerm.Default(LookupPopup.SelectedValue, "id") }; } } }
public TrackingViewForm() { InitializeComponent(); form = this; DataManager.DefaultParameters = new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals), WhereTerm.Default(1, "sales_type_id", EnumSqlOperator.Equals), WhereTerm.Default(BaseControl.CorporateId, "customer_id", EnumSqlOperator.Equals) }; }
protected void FilterData(object sender, EventArgs e) { var param = new List <WhereTerm>(); if (tbxName.Text != "") { param.Add(WhereTerm.Default(tbxName.Text, "name", EnumSqlOperator.Like)); } // ReSharper disable once CoVariantArrayConversion PackageTypeGrid.DataSource = new PackageTypeDataManager().Get <PackageTypeModel>(param.ToArray()); PackageTypeGrid.Focus(); }
public override void AfterDelete() { var ds = PodView.DataSource as List <FranchiseCommissionModel>; foreach (var o in ds) { var s = new ShipmentDataManager().GetFirst <ShipmentModel>(WhereTerm.Default(o.ShipmentId, "id")); s.PODStatus = (int)EnumPodStatus.None; new ShipmentDataManager().Update <ShipmentModel>(s); } base.AfterDelete(); }
protected override void SaveDetail(bool isUpdate = false) { var details = PodGrid.DataSource as List <CorporatePickupDetailModel>; var manager = new CorporatePickupDetailDataManager(); var smanager = new ShipmentDataManager(); foreach (CorporatePickupDetailModel detail in details) { var pickupDetail = new CorporatePickupDetailModel(); var shipment = new ShipmentModel(); if (detail.StateChange == EnumStateChange.Insert && detail.Checked) { pickupDetail.Rowstatus = true; pickupDetail.Rowversion = DateTime.Now; pickupDetail.CorporatePickupId = CurrentModel.Id; pickupDetail.ShipmentId = detail.ShipmentId; pickupDetail.CreatedPc = Environment.MachineName; pickupDetail.Createdby = BaseControl.UserLogin; pickupDetail.Createddate = DateTime.Now; manager.Save <CorporatePickupDetailModel>(pickupDetail); shipment = smanager.GetFirst <ShipmentModel>(WhereTerm.Default(detail.ShipmentId, "id")); if (shipment != null) { shipment.PODStatus = (int)EnumPodStatus.PickedUp; shipment.ModifiedPc = Environment.MachineName; shipment.Modifiedby = BaseControl.UserLogin; shipment.Modifieddate = DateTime.Now; smanager.Update <ShipmentModel>(shipment); } } else if (detail.StateChange == EnumStateChange.Update && !detail.Checked) { manager.DeActive(detail.Id, BaseControl.UserLogin, DateTime.Now); shipment = smanager.GetFirst <ShipmentModel>(WhereTerm.Default(detail.ShipmentId, "id")); if (shipment != null) { shipment.PODStatus = (int)EnumPodStatus.None; shipment.ModifiedPc = Environment.MachineName; shipment.Modifiedby = BaseControl.UserLogin; shipment.Modifieddate = DateTime.Now; smanager.Update <ShipmentModel>(shipment); } } } }
private void AutoPopulateConsigneeDetail(object sender, EventArgs e) { if (lkpConsignee.Value != null) { var consignee = new ConsigneeDataManager().GetFirst <ConsigneeModel>(WhereTerm.Default((int)lkpConsignee.Value, "id", EnumSqlOperator.Equals)); if (consignee != null) { tbxConsigneeName.Text = consignee.Name; tbxConsigneeAddress.Text = consignee.Address; tbxConsigneePhone.Text = consignee.Phone; lkpPackage.Focus(); } } }
public EntryEconnoteForm() { InitializeComponent(); form = this; DataManager.DefaultParameters = new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals), WhereTerm.Default(1, "sales_type_id", EnumSqlOperator.Equals), WhereTerm.Default(BaseControl.CorporateId, "customer_id", EnumSqlOperator.Equals) }; Customer = new CustomerDataManager().GetFirst <CustomerModel>( WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals), WhereTerm.Default(BaseControl.CorporateId, "id", EnumSqlOperator.Equals) ); }
private void ShipmentListLoad(object sender, EventArgs e) { _ClearForm(panel1); tbxDestination.LookupPopup = new ConsigneePopup(); tbxDestination.AutoCompleteDataManager = new CityDataManager(); tbxDestination.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; tbxDestination.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; tbxFrom.Text = DateTime.Now.ToString(CultureInfo.InvariantCulture); tbxTo.Text = DateTime.Now.ToString(CultureInfo.InvariantCulture); btnPrint.Click += Print; }
public EmployeePopup(EmployeeModel.EmployeeType employeeType = EmployeeModel.EmployeeType.All, params IListParameter[] defaultParam) { InitializeComponent(); DataManager = new EmployeeDataManager(); DataManager.DefaultParameters = defaultParam; DataManager.DefaultParameters = new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals) }; PagingForm = new Paging { Direction = "ASC", Limit = PageLimit, SortColumn = "name" }; EmployeeType = employeeType; ObjNavigator.ButtonClick += NavigatorClick; }
private void OnLoad(object sender, EventArgs e) { tbxDestination.LookupPopup = new CityPopup(); tbxDestination.AutoCompleteDataManager = new CityDataManager(); tbxDestination.AutoCompleteDisplayFormater = model => ((CityModel)model).Name; tbxDestination.AutoCompleteWheretermFormater = s => new IListParameter[] { WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith) }; tbxCustomer.LookupPopup = new CustomerPopup(new IListParameter[] { WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals) }); tbxCustomer.AutoCompleteDataManager = new CustomerDataManager(); tbxCustomer.AutoCompleteText = model => ((CustomerModel)model).Name; tbxCustomer.AutoCompleteDisplayFormater = model => ((CustomerModel)model).Code + " - " + ((CustomerModel)model).Name; tbxCustomer.AutoCompleteWhereExpression = (s, p) => p.SetWhereExpression("(code = @0 OR name.StartsWith(@0)) AND branch_id = @1 AND franchise_id = @2", s, BaseControl.BranchId, BaseControl.FranchiseId); //SearchCodeLoad(sender, e); }
private IListParameter[] FilterVoid() { var param = new List <WhereTerm>(); param.Add(WhereTerm.Default(BaseControl.FranchiseId, "franchise_id", EnumSqlOperator.Equals)); param.Add(WhereTerm.Default(cbxVoid.Checked, "voided")); // ReSharper disable once ConditionIsAlwaysTrueOrFalse var dateNull = new DateTime(1900, 1, 1, 0, 0, 0); var fuck1 = tbxFrom.Value; if (fuck1 > dateNull) { var fdate = new DateTime(fuck1.Year, fuck1.Month, fuck1.Day, 0, 0, 0); param.Add(WhereTerm.Default(fdate, "date_process", EnumSqlOperator.GreatThanEqual)); } var fuck2 = tbxTo.Value; if (fuck2 > dateNull) { var ldate = new DateTime(fuck2.Year, fuck2.Month, fuck2.Day, 23, 59, 59); param.Add(WhereTerm.Default(ldate, "date_process", EnumSqlOperator.LesThanEqual)); } if (tbxCustomer.Value != null) { param.Add(WhereTerm.Default((int)tbxCustomer.Value, "customer_id", EnumSqlOperator.Equals)); } if (tbxDestination.Value != null) { param.Add(WhereTerm.Default((int)tbxDestination.Value, "dest_city_id", EnumSqlOperator.Equals)); } IListParameter[] p = null; if (param.Any()) { // ReSharper disable once CoVariantArrayConversion p = param.ToArray(); } return(p); }
protected override bool ValidateFormWithAlert() { var errors = ComponentValidationHelper.Validate(tbxName, tbxAddress, tbxPhone); if (errors.Count > 0) { MessageBox.Show(string.Join("\n", errors)); return(false); } var duplicate = DataManager.GetFirst <ConsigneeModel>(WhereTerm.Default(tbxName.Text, "name")); if (duplicate != null && duplicate.Id != CurrentModel.Id) { MessageBox.Show(@"Nama consignee ini tidak dapat digunakan!"); return(false); } return(true); }