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