public void AddRange(WhereTerm[] val)
{
for (int i = 0; i < val.Length; i++)
{
this.Add(val[i]);
}
}
protected override void BitwiseAnd(StringBuilder builder, WhereTerm term)
{
builder.Append("BITAND(");
this.Expression(builder, term.Expr1);
builder.Append(", ");
this.Expression(builder, term.Expr2);
builder.Append(") > 0");
}
private void PopulateInterfaceFromModel(int id)
{
using (var facade = new EmployeeCore())
{
var employee = facade.Get <IEmployeeModel>(WhereTerm.DefaultParam(id, "ID")).FirstOrDefault();
if (employee == null || !facade.IsSuccess)
{
MsgHelpers.ShowError(this, string.IsNullOrEmpty(facade.Message) ? "Employee not found" : facade.Message);
return;
}
address.Text = employee.Address;
bankAccount.Text = employee.BankAccount;
bankName.Text = employee.BankName;
birthDate.Value = employee.BirthDate;
cityName.Text = employee.City;
createdBy.Text = employee.CreatedBy;
createdDate.Value = employee.CreatedDate;
firstName.Text = employee.FirstName;
gender.Text = employee.Gender;
hireDate.Value = employee.HiredDate;
recordId.Text = employee.Id.ToString(CultureInfo.InvariantCulture);
lastName.Text = employee.LastName;
maritalStatus.Text = employee.MaritalStatus;
middleName.Text = employee.MiddleName;
nationalIdNumber.Text = employee.NationalIDNumber;
payrollGroupCode.Text = employee.PayrollGroupCode;
positionName.Text = employee.PositionName;
postalCode.Text = employee.PostalCode;
stateName.Text = employee.State;
titleName.Text = employee.Title;
createdBy.Text = employee.CreatedBy;
createdDate.Value = employee.CreatedDate;
modifiedBy.Text = employee.ModifiedBy;
modifiedDate.Value = employee.ModifiedDate.HasValue ? employee.ModifiedDate.Value : DateTime.Now;
employeeId.Text = employee.EmployeeID;
isTerminate.Text = employee.IsTerminate.ToString();
terminateDate.Value = employee.TerminateDate.HasValue ? employee.TerminateDate.Value : DateTime.Now;
terminateDate.Checked = employee.TerminateDate.HasValue;
terminateDescription.Text = employee.TerminateDescription;
}
}
private void PopulateInterfaceFromModel(int id)
{
using (var facade = new CityCore())
{
var city = facade.Get <ICityModel>(WhereTerm.DefaultParam(id, "ID")).FirstOrDefault();
if (city == null || !facade.IsSuccess)
{
MsgHelpers.ShowError(this, string.IsNullOrEmpty(facade.Message) ? "Employee not found" : facade.Message);
return;
}
recordId.Text = city.Id.ToString();
cityName.Text = city.CityName;
createdBy.Text = city.CreatedBy;
createdDate.Value = city.CreatedDate;
modifiedBy.Text = city.ModifiedBy;
if (city.ModifiedDate != null)
{
modifiedDate.Value = (DateTime)city.ModifiedDate;
}
}
}
public override void New()
{
base.New();
cbxRa.Enabled = false;
tbxTariff.Enabled = false;
tbxTariffNet.Enabled = false;
tbxHandlingFee.Enabled = false;
tbxTtlTariff.Enabled = false;
tbxTtlChargeable.Enabled = false;
tbxTariffNet.Enabled = false;
tbxGrandTotal.Enabled = false;
tbxInsurance.Enabled = false;
tbxDate.Enabled = false;
tbxPacking.Enabled = false;
lkpPayment.DefaultValue = new IListParameter[] { WhereTerm.Default("CREDIT", "name") };
rbPod_Void.Enabled = false;
MinWeight = 0;
}
public virtual void Parameter()
{
FromTerm tCustomers = FromTerm.Table("customers");
SelectQuery query = new SelectQuery();
query.Columns.Add(new SelectColumn("name", tCustomers));
query.FromClause.BaseTable = tCustomers;
query.WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Parameter(GetParameterName("pName")), SqlExpression.Field("name", tCustomers), CompareOperator.Equal));
string sql = Renderer.RenderSelect(query);
Console.WriteLine(sql);
if (connection != null)
{
IDbCommand command = connection.CreateCommand();
command.CommandText = sql;
command.Parameters.Add(CreateParameter("@pName", "John"));
command.ExecuteNonQuery();
}
}
public virtual void Having()
{
FromTerm tCustomers = FromTerm.Table("customers");
FromTerm tProducts = FromTerm.Table("products", "p");
FromTerm tOrders = FromTerm.Table("orders", "o");
SelectQuery query = new SelectQuery();
query.Columns.Add(new SelectColumn("name", tCustomers));
query.Columns.Add(new SelectColumn("price", tProducts, "sum", SqlAggregationFunction.Sum));
query.FromClause.BaseTable = tCustomers;
query.FromClause.Join(JoinType.Inner, query.FromClause.BaseTable, tOrders, "customerId", "customerId");
query.FromClause.Join(JoinType.Inner, tOrders, tProducts, "productId", "productId");
query.GroupByTerms.Add(new GroupByTerm("name", tCustomers));
query.HavingPhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("name", tCustomers), SqlExpression.String("John"), CompareOperator.Equal));
RenderSelect(query);
}
public PickupForm()
{
InitializeComponent();
form = this;
Shown += PickupFormShown;
DataManager.DefaultParameters = new IListParameter[]
{
WhereTerm.Default(BaseControl.FranchiseId, "franchise_id", EnumSqlOperator.Equals)
};
PodGrid.DoubleClick += (o, args) =>
{
var rows = PodView.GetSelectedRows();
if (rows.Count() > 0)
{
BaseControl.OpenRelatedForm(new TrackingViewForm(), PodView.GetRowCellValue(rows[0], "ShipmentCode").ToString(), CallingCommand);
}
};
}
protected override void BeforeFilter()
{
var param = new List <WhereTerm>();
param.Add(WhereTerm.Default(BaseControl.BranchId, "branch_id", EnumSqlOperator.Equals));
param.Add(WhereTerm.Default(BaseControl.FranchiseId, "franchise_id", EnumSqlOperator.Equals));
param.Add(WhereTerm.Default(BaseControl.CityId, "city_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));
}
if (tbxDestination.Value != null)
{
param.Add(WhereTerm.Default((int)tbxDestination.Value, "dest_city_id", EnumSqlOperator.Equals));
}
if (tbxCustomer.Value != null)
{
param.Add(WhereTerm.Default((int)tbxCustomer.Value, "customer_id", EnumSqlOperator.Equals));
}
// ReSharper disable once CoVariantArrayConversion
if (param.Any())
{
AutoCompleteWheretermFormater = param.ToArray();
}
}
/// <summary>
/// Recursivly renders a WhereClause
/// </summary>
/// <param name="builder"></param>
/// <param name="group"></param>
protected virtual void WhereClause(StringBuilder builder, WhereClause group)
{
if (group.IsEmpty)
{
return;
}
builder.AppendFormat("(");
for (int i = 0; i < group.Terms.Count; i++)
{
if (i > 0)
{
RelationshipOperator(builder, group.Relationship);
}
WhereTerm term = group.Terms[i];
WhereClause(builder, term);
}
bool operatorRequired = group.Terms.Count > 0;
foreach (WhereClause childGroup in group.SubClauses)
{
if (childGroup.IsEmpty)
{
continue;
}
if (operatorRequired)
{
RelationshipOperator(builder, group.Relationship);
}
WhereClause(builder, childGroup);
operatorRequired = true;
}
builder.AppendFormat(")");
}
/// <summary>
/// Recursivly renders a WhereClause
/// </summary>
/// <param name="builder"></param>
/// <param name="group"></param>
protected virtual void WhereClause(StringBuilder builder, WhereClause group)
{
if (group.IsEmpty)
{
return;
}
builder.AppendFormat("(");
for (int i = 0; i < group.Terms.Count; i++)
{
WhereTerm term = (WhereTerm)group.Terms[i];
WhereClause(builder, term);
if (i < group.Terms.Count - 1 || group.SubClauses.Count > 0)
{
RelationshipOperator(builder, term.Relationship);
}
}
for (int i = 0; i < group.SubClauses.Count; i++)
{
WhereClause childGroup = (WhereClause)group.SubClauses[i];
if (childGroup.IsEmpty)
{
continue;
}
WhereClause(builder, childGroup);
if (i < group.SubClauses.Count - 1)
{
RelationshipOperator(builder, childGroup.Relationship);
}
}
builder.AppendFormat(")");
}
public ConsigneeFilterPopup()
{
InitializeComponent();
var clName = new GridColumn
{
Name = "clName",
Caption = @"Name",
FieldName = "Name",
VisibleIndex = 0,
Width = 75
};
var clAddress = new GridColumn
{
Name = "clAddress",
Caption = @"Address",
FieldName = "Address",
VisibleIndex = 1
};
var clPhone = new GridColumn
{
Name = "clPhone",
Caption = @"Phone",
FieldName = "Phone",
VisibleIndex = 2
};
SearchView.Columns.AddRange(new[] { clName, clAddress, clPhone });
SearchView.GridControl = GridSearch;
DataManager.DefaultParameters = new IListParameter[]
{
WhereTerm.Default(BaseControl.CorporateId, "corporate_id", EnumSqlOperator.Equals)
};
label1.Visible = false;
tbxCode.Visible = false;
}
private void RefreshGrid()
{
Statuses.RaiseListChangedEvents = false;
Statuses.Clear();
new ShipmentStatusDataManager().
Get <ShipmentStatusModel>(WhereTerm.Default(CurrentModel.Id, "shipment_id")).
OrderByDescending(row => row.DateProcess).
Select((row, i) => new ShipmentStatusDataRow
{
BranchDataManager = BranchDataManager,
TrackingStatusDataManager = TrackingStatusDataManager,
MissDeliveryReasonDataManager = MissDeliveryReasonDataManager,
EmployeeDataManager = EmployeeDataManager,
Index = i + 1,
Id = row.Id,
ShipmentId = row.ShipmentId,
DateProcess = row.DateProcess,
TrackingStatusId = row.TrackingStatusId,
MissDeliveryReason = row.MissDeliveryReason,
PositionStatus = row.PositionStatus,
PositionStatusId = row.PositionStatusId,
BranchId = row.BranchId,
StatusBy = row.StatusBy,
StatusNote = row.StatusNote,
Reference = row.Reference,
Rowstatus = row.Rowstatus,
Rowversion = row.Rowversion,
Createddate = row.Createddate,
Createdby = row.Createdby,
Modifieddate = row.Modifieddate,
Modifiedby = row.Modifiedby,
})
.ForEach(row => Statuses.Add(row));
Statuses.RaiseListChangedEvents = true;
Statuses.ResetBindings();
}
private IListParameter[] FilterVoid()
{
var param = new List <WhereTerm>();
param.Add(WhereTerm.Default(BaseControl.CorporateId, "customer_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 (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);
}
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
if (tbxCustomer.Value != null)
{
customer_name =
new CustomerDataManager().GetFirst <CustomerModel>(WhereTerm.Default((int)tbxCustomer.Value, "id",
EnumSqlOperator.Equals)).Name;
}
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);
}
public override void New()
{
base.New();
cbxRa.Enabled = false;
tbxTariff.Enabled = false;
tbxTariffNet.Enabled = false;
tbxHandlingFee.Enabled = false;
tbxTtlTariff.Enabled = false;
tbxTtlDiscount.Enabled = false;
tbxTariffNet.Enabled = false;
tbxGlobalTotal.Enabled = false;
tbxInsurance.Enabled = false;
tbxDate.Enabled = false;
if (Customer != null)
{
tbxDiscount.Value = Customer.Discount;
}
lkpPayment.DefaultValue = new IListParameter[] { WhereTerm.Default("COLLECT", "name") };
rbPod_Void.Enabled = false;
}
protected override void BeforeFilter()
{
var param = new List <WhereTerm>();
CodeColumn = "Id";
if (!string.IsNullOrEmpty((tbxAddress.Text)))
{
param.Add(WhereTerm.Default(tbxAddress.Text, "address", EnumSqlOperator.Like));
}
if (!string.IsNullOrEmpty((tbxPhone.Text)))
{
param.Add(WhereTerm.Default(tbxPhone.Text, "phone", EnumSqlOperator.Like));
}
// ReSharper disable once CoVariantArrayConversion
if (param.Any())
{
AutoCompleteWheretermFormater = param.ToArray();
}
}
protected void FilterData(object sender, EventArgs e)
{
var param = new List <WhereTerm>();
param.Add(WhereTerm.Default(BaseControl.CorporateId, "corporate_id", EnumSqlOperator.Like));
if (tbxName.Text != "")
{
param.Add(WhereTerm.Default(tbxName.Text, "name", EnumSqlOperator.Like));
}
if (tbxAddress.Text != "")
{
param.Add(WhereTerm.Default(tbxAddress.Text, "address", EnumSqlOperator.Like));
}
if (tbxPhone.Text != "")
{
param.Add(WhereTerm.Default(tbxPhone.Text, "phone", EnumSqlOperator.Like));
}
// ReSharper disable once CoVariantArrayConversion
ConsigneeGrid.DataSource = new ConsigneeDataManager().Get <ConsigneeModel>(param.ToArray());
ConsigneeGrid.Focus();
}
/// <summary>
/// Creates a <see cref="SelectQuery"/> which produces drill-down results
/// </summary>
/// <param name="crossTabRowKey">Value identifying cross-tab's row</param>
/// <param name="crossTabColumnName">Name of a cross-tab column</param>
/// <returns>A <see cref="SelectQuery"/> which produces drill-down results of the specified cross-tab cell</returns>
public SelectQuery BuildDrillDownSql(SqlConstant crossTabRowKey, string crossTabColumnName)
{
Validate();
SelectQuery query = new SelectQuery();
query.Columns.Add(new SelectColumn("*"));
query.FromClause.BaseTable = GetBaseFromTerm();
PivotColumn pivotCol;
PivotColumnValue pivotVal;
if (!FindPivotColumnValue(crossTabColumnName, out pivotCol, out pivotVal))
{
throw new PivotTableException(string.Format("Cross-Tab column '{0}' could not be found in pivot transformation definition.", crossTabColumnName));
}
query.WherePhrase.Terms.Add(CreateColumnValueCondition(pivotCol, pivotVal));
if (crossTabRowKey != null)
{
query.WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field(rowField), SqlExpression.Constant(crossTabRowKey), CompareOperator.Equal));
}
return(query);
}
protected override poSelectQuery BuildQuery()
{
var selQuery = new poSelectQuery("heItems");
selQuery.AddColumn("heID", selQuery.BaseTable, "ID");
selQuery.AddColumn("heCode", selQuery.BaseTable, "heCode");
selQuery.AddColumn("heName", selQuery.BaseTable, "heName");
selQuery.AddColumns("heFactoryCode", "heSeasID", "heAMsntID", "heAuxiliaryCode", "heDetailedDescr", "heClassification", "heKind",
"heCompID", "heActive", "heNameSoundex", "heRefNumber", "heIaccID", "heProductionCatID", "heBlockSales", "heBlockPurchases", "heBlockWarehouses", "hePartInStockControl"
, "heSalInvAttrSpPrice", "hePurInvAttrSpPrice", "heCat01ID", "heCat02ID", "HECALCFROMVALUE",
"heRetailPrice", "heWholeSalesPrice");
selQuery.AddColumns("heSplrID", "heType");
selQuery.WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("heCompID", selQuery.FromClause.BaseTable), selQuery.ParameterValue(AppContext.GetService <heSystemParams>().CurrentCompanyID), CompareOperator.Equal));
selQuery.WherePhrase.Terms.Add(WhereTerm.CreateCompare(SqlExpression.Field("heType", selQuery.FromClause.BaseTable), selQuery.ParameterValue(Convert.ToInt16(hewItemsDataObjectProxy.ItemTypeEnum.Service)), CompareOperator.Equal));
selQuery.AddEnumColumn(AppContext, selQuery.FromClause.BaseTable, "Hercules;heItems;heKind");
selQuery.AddEnumColumn(AppContext, selQuery.FromClause.BaseTable, "Hercules;heItems;heClassification");
var AMesUnits = FromTerm.Table("heMeasurementUnits", "MU1");
selQuery.AddColumn("heName", AMesUnits, "AMUNAME");
selQuery.FromClause.Join(JoinType.Inner, selQuery.BaseTable, AMesUnits, "heAMsntID", "heID");
var vats = FromTerm.Table("heVATClasses", "Vats");
selQuery.AddColumn("heName", vats, "VTCLNAME");
selQuery.FromClause.Join(JoinType.Inner, selQuery.FromClause.BaseTable, vats, "heVtclID", "heID");
var iaccs = FromTerm.Table("heItemAccCategories", "Iacc");
selQuery.AddColumn("heName", iaccs, "IaccName");
selQuery.FromClause.Join(JoinType.Left, selQuery.FromClause.BaseTable, iaccs, "heIaccID", "heID");
return(selQuery);
}
private void RefreshServiceType()
{
if (lkpDestination.Value == null)
{
return;
}
int originBranchId = 0;
using (var cityDataManager = new CityDataManager())
{
var originCity = cityDataManager.GetFirst <CityModel>(WhereTerm.Default(BaseControl.CityId, "id"));
if (originCity != null)
{
originBranchId = originCity.BranchId;
}
}
BranchCityListModel branchCityListModel;
using (var branchCityListDataManager = new BranchCityListDataManager())
{
branchCityListModel = branchCityListDataManager.GetFirst <BranchCityListModel>(
WhereTerm.Default(originBranchId, "branch_id"),
WhereTerm.Default((int)lkpDestination.Value, "city_id")
);
}
if (branchCityListModel != null)
{
lkpService.DefaultValue = new IListParameter[] { WhereTerm.Default(SERVICE_TYPE_CITY_COURIER, "Name") };
}
else
{
RefreshTariff();
}
}
protected virtual void WhereClause(StringBuilder builder, WhereTerm term)
{
if ((term.Type == WhereTermType.Compare) && (term.Op == CompareOperator.BitwiseAnd))
{
this.BitwiseAnd(builder, term);
}
else if (term.Type == WhereTermType.Compare)
{
this.Expression(builder, term.Expr1);
builder.Append(" ");
this.Operator(builder, term.Op);
builder.Append(" ");
this.Expression(builder, term.Expr2);
}
else if ((((term.Type == WhereTermType.In) || (term.Type == WhereTermType.NotIn)) || (term.Type == WhereTermType.InSubQuery)) || (term.Type == WhereTermType.NotInSubQuery))
{
this.Expression(builder, term.Expr1);
if ((term.Type == WhereTermType.NotIn) || (term.Type == WhereTermType.NotInSubQuery))
{
builder.Append(" not");
}
builder.Append(" in (");
if ((term.Type == WhereTermType.InSubQuery) || (term.Type == WhereTermType.NotInSubQuery))
{
builder.Append(term.SubQuery);
}
else
{
this.ConstantList(builder, term.Values);
}
builder.Append(")");
}
else if ((term.Type == WhereTermType.Exists) || (term.Type == WhereTermType.NotExists))
{
if (term.Type == WhereTermType.NotExists)
{
builder.Append(" not");
}
builder.Append(" exists (");
builder.Append(term.SubQuery);
builder.Append(")");
}
else if (term.Type == WhereTermType.Between)
{
this.Expression(builder, term.Expr1);
builder.AppendFormat(" between ", new object[0]);
this.Expression(builder, term.Expr2);
builder.AppendFormat(" and ", new object[0]);
this.Expression(builder, term.Expr3);
}
else if ((term.Type == WhereTermType.IsNull) || (term.Type == WhereTermType.IsNotNull))
{
this.Expression(builder, term.Expr1);
builder.Append(" is ");
if (term.Type == WhereTermType.IsNotNull)
{
builder.Append("not ");
}
builder.Append(" null ");
}
}
public string GetQueryParameterLinq(params IListParameter[] parameters)
{
var hasRowParams = WhereTerm.ResizeParameter(ref parameters, 1);
if (!hasRowParams)
{
if (!_withoutDefault)
{
parameters[parameters.Length - 1] = WhereTerm.Default(true, DefaultValue.COLUMN_ROW_STATUS);
}
else
{
parameters[parameters.Length - 1] = WhereTerm.Default(0, "0", EnumSqlOperator.Equals);
}
}
if (DefaultParameters != null)
{
foreach (var listParameter in DefaultParameters)
{
var @where = (WhereTerm)listParameter;
Array.Resize(ref parameters, parameters.Length + 1);
parameters[parameters.Length - 1] = where;
}
}
var query = new StringBuilder();
ListValue = new Collection <object>();
ListClause = new Collection <string>();
var indexpass = 0;
foreach (var param in parameters)
{
var index = parameters.ToList().IndexOf(param) + indexpass;
switch (param.ParamDataType)
{
case EnumParameterDataTypes.DateTime:
{
var date1 = Convert.ToDateTime(param.Value);
var fdate = new DateTime(date1.Year, date1.Month, date1.Day, 0, 0, 0);
var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59);
if (param.Operator == EnumSqlOperator.Equals)
{
var fparma = WhereTerm.Default(fdate, param.ColumnName, EnumSqlOperator.GreatThanEqual);
var lparma = WhereTerm.Default(ldate, param.ColumnName, EnumSqlOperator.LesThanEqual);
query.Append(GetValueParameterLinq(fparma, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(fparma.GetValue());
index++;
indexpass++;
query.Append(GetValueParameterLinq(lparma, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(lparma.GetValue());
}
else
{
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(date1);
}
GetValueClause(param);
}
break;
case EnumParameterDataTypes.DateTimeRange:
{
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(param.Value);
var date1 = Convert.ToDateTime(((IListRangeParameter)param).GetValue2());
//var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59);
ListValue.Add(date1);
indexpass++;
}
break;
case EnumParameterDataTypes.Guid:
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(new Guid(param.Value.ToString()));
break;
default:
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(param.Value);
GetValueClause(param);
break;
}
}
if (query.Length != 0)
{
var qresult = query.ToString().Trim();
if (qresult.Substring(qresult.Length - 3, 3) == DefaultValue.LOGICAL_SQL.Trim())
{
qresult = qresult.Remove(qresult.Length - 3, 3);
}
return(qresult);
}
return(query.ToString());
}
protected override void SaveDetail(bool isUpdate = false)
{
var details = PodGrid.DataSource as List <FranchiseCommissionModel>;
var manager = new FranchisePickupDetailDataManager();
var smanager = new ShipmentDataManager();
foreach (FranchiseCommissionModel detail in details)
{
var pickupDetail = new FranchisePickupDetailModel();
var shipment = new ShipmentModel();
if (detail.StateChange == EnumStateChange.Insert && detail.Checked)
{
pickupDetail.Rowstatus = true;
pickupDetail.Rowversion = DateTime.Now;
pickupDetail.FranchisePickupId = CurrentModel.Id;
pickupDetail.ShipmentId = detail.ShipmentId;
pickupDetail.CreatedPc = Environment.MachineName;
pickupDetail.Createdby = BaseControl.UserLogin;
pickupDetail.Createddate = DateTime.Now;
manager.Save <FranchisePickupDetailModel>(pickupDetail);
shipment = smanager.GetFirst <ShipmentModel>(WhereTerm.Default(detail.ShipmentId, "id"));
if (shipment != null)
{
shipment.PODStatus = (int)EnumPodStatus.PickedUp;
shipment.TrackingStatusId = (int)EnumTrackingStatus.Pickup;
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.TrackingStatusId = (int)EnumTrackingStatus.FranchiseDataEntry;
shipment.ModifiedPc = Environment.MachineName;
shipment.Modifiedby = BaseControl.UserLogin;
shipment.Modifieddate = DateTime.Now;
smanager.Update <ShipmentModel>(shipment);
}
}
}
var voided = new ShipmentDataManager().Get <ShipmentModel>(
new IListParameter[]
{
WhereTerm.Default(true, "voided"),
WhereTerm.Default(5, "sales_type_id", EnumSqlOperator.Equals),
WhereTerm.Default(BaseControl.FranchiseId, "franchise_id", EnumSqlOperator.Equals),
WhereTerm.Default((int)EnumPodStatus.None, "pod_status")
}
);
foreach (var v in voided)
{
var pickupDetail = new FranchisePickupDetailModel();
pickupDetail.Rowstatus = true;
pickupDetail.Rowversion = DateTime.Now;
pickupDetail.FranchisePickupId = CurrentModel.Id;
pickupDetail.ShipmentId = v.Id;
pickupDetail.CreatedPc = Environment.MachineName;
pickupDetail.Createdby = BaseControl.UserLogin;
pickupDetail.Createddate = DateTime.Now;
manager.Save <FranchisePickupDetailModel>(pickupDetail);
v.PODStatus = (int)EnumPodStatus.PickedUp;
v.ModifiedPc = Environment.MachineName;
v.Modifiedby = BaseControl.UserLogin;
v.Modifieddate = DateTime.Now;
smanager.Update <ShipmentModel>(v);
}
}
public int Add(WhereTerm val)
{
return base.List.Add(val);
}
public string GetQueryParameterLinq(params IListParameter[] parameters)
{
var hasRowParams = WhereTerm.ResizeParameter(ref parameters, 1);
if (!hasRowParams)
{
parameters[parameters.Length - 1] = WhereTerm.Parameter(0, DefaultValue.COLUMN_ROW_STATUS);
}
var query = new StringBuilder();
ListValue = new Collection <object>();
var indexpass = 0;
foreach (var param in parameters)
{
var index = parameters.ToList().IndexOf(param) + indexpass;
switch (param.ParamDataType)
{
case EnumParamterDataTypes.DateTime:
{
var date1 = Convert.ToDateTime(param.GetValue());
var fdate = new DateTime(date1.Year, date1.Month, date1.Day, 0, 0, 0);
var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59);
var fparma = WhereTerm.Parameter(fdate, param.ColumnName, SqlOperator.GreatThanEqual);
var lparma = WhereTerm.Parameter(ldate, param.ColumnName, SqlOperator.LesThanEqual);
query.Append(GetValueParameterLinq(fparma, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(fparma.GetValue());
index++;
indexpass++;
query.Append(GetValueParameterLinq(lparma, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(lparma.GetValue());
}
break;
case EnumParamterDataTypes.DateTimeRange:
{
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(param.GetValue());
var date1 = Convert.ToDateTime(((IListRangeParameter)param).GetValue2());
//var ldate = new DateTime(date1.Year, date1.Month, date1.Day, 23, 59, 59);
ListValue.Add(date1);
indexpass++;
}
break;
default:
query.Append(GetValueParameterLinq(param, index) + DefaultValue.LOGICAL_SQL);
ListValue.Add(param.GetValue());
break;
}
}
if (query.Length != 0)
{
var qresult = query.ToString().Trim();
if (qresult.Substring(qresult.Length - 3, 3) == DefaultValue.LOGICAL_SQL.Trim())
{
qresult = qresult.Remove(qresult.Length - 3, 3);
}
return(qresult);
}
return(query.ToString());
}
private void RefreshTariff()
{
if (_isPopulatingForm)
{
return;
}
if (CurrentModel == null)
{
return;
}
if (((ShipmentModel)CurrentModel).Posted || ((ShipmentModel)CurrentModel).Voided)
{
return;
}
tbxTariff.Value = 0;
tbxHandlingFee.Value = 0;
cbxRa.Checked = false;
using (var dm = new DeliveryTariffDataManager())
{
DeliveryTariffModel dlvTariff = null;
if (lkpPackage.Value != null)
{
if (lkpDestination.Value != null)
{
dlvTariff = dm.GetByPackageTypeAndWeight((int)lkpPackage.Value, (int)lkpDestination.Value, tbxTtlGrossWeight.Value);
}
}
if (dlvTariff != null)
{
((ShipmentModel)CurrentModel).DeliveryFee = dlvTariff.Tariff;
DeliveryTariffMinimumWeight = dlvTariff.MinWeight;
}
else
{
((ShipmentModel)CurrentModel).DeliveryFee = 0;
DeliveryTariffMinimumWeight = 0;
}
}
if (((ShipmentModel)CurrentModel).PricingPlanId != PRICING_PLAN_DOMESTIC)
{
using (var tariffInternationalDataManager = new TariffInternationalDataManager())
{
var tariffIntModel = tariffInternationalDataManager.GetTariff(
((ShipmentModel)CurrentModel).PricingPlanId ?? 0,
lkpPackage.Value ?? 0,
tbxTtlChargeable.Value
);
if (tariffIntModel != null)
{
tbxTariff.Value = 0;
tbxTtlTariff.Value = tariffIntModel.Tariff;
tbxHandlingFee.Value = tariffIntModel.HandlingFee ?? 0;
((ShipmentModel)CurrentModel).CurrencyId = tariffIntModel.CurrencyId;
using (var currencyDm = new CurrencyDataManager())
{
var currencyModel =
currencyDm.GetFirst <CurrencyModel>(WhereTerm.Default(tariffIntModel.CurrencyId, "id"));
if (currencyModel != null)
{
((ShipmentModel)CurrentModel).Currency = currencyModel.Name;
((ShipmentModel)CurrentModel).CurrencyRate = currencyModel.Rate;
}
}
RefreshGrandTotal();
return;
}
}
}
else
{
using (var currencyDm = new CurrencyDataManager())
{
var currencyModel =
currencyDm.GetFirst <CurrencyModel>(WhereTerm.Default(CURRENCY_IDR, "code"));
if (currencyModel != null)
{
((ShipmentModel)CurrentModel).CurrencyId = currencyModel.Id;
((ShipmentModel)CurrentModel).Currency = currencyModel.Name;
((ShipmentModel)CurrentModel).CurrencyRate = currencyModel.Rate;
}
}
}
using (var customerTariffDataManager = new CustomerTariffDataManager())
{
if (lkpDestination.Value != null)
{
var customerTariffModel = customerTariffDataManager.GetTariff(
BaseControl.CityId,
(int)lkpDestination.Value,
lkpService.Value ?? 0,
lkpPackage.Value ?? 0,
BaseControl.CorporateId,
tbxTtlChargeable.Value
);
if (customerTariffModel != null)
{
tbxTariff.Value = customerTariffModel.Tariff;
tbxHandlingFee.Value = customerTariffModel.HandlingFee;
cbxRa.Checked = customerTariffModel.Ra ?? false;
MinWeight = customerTariffModel.MinWeight;
if (MinWeight > 0 && tbxTtlGrossWeight.Value < MinWeight)
{
tbxTtlGrossWeight.Value = MinWeight;
}
RefreshGrandTotal();
return;
}
}
}
using (var tariffDataManager = new TariffDataManager())
{
if (lkpDestination.Value != null)
{
var tariffModel = tariffDataManager.GetTariff(
BaseControl.CityId,
(int)lkpDestination.Value,
lkpService.Value ?? 0,
lkpPackage.Value ?? 0,
tbxTtlChargeable.Value
);
if (tariffModel != null)
{
tbxTariff.Value = tariffModel.Tariff;
tbxHandlingFee.Value = tariffModel.HandlingFee;
cbxRa.Checked = tariffModel.Ra ?? false;
MinWeight = tariffModel.MinWeight;
if (MinWeight > 0 && tbxTtlGrossWeight.Value < MinWeight)
{
tbxTtlGrossWeight.Value = MinWeight;
}
RefreshGrandTotal();
return;
}
}
}
tbxTariff.Text = @"0";
tbxHandlingFee.Text = @"0";
MinWeight = 0;
RefreshGrandTotal();
}
public void Remove(WhereTerm val)
{
base.List.Remove(val);
}
public void Insert(int index, WhereTerm val)
{
base.List.Insert(index, val);
}
/// <summary>
/// Renders bitwise and
/// </summary>
/// <param name="builder"></param>
/// <param name="term"></param>
protected virtual void BitwiseAnd(StringBuilder builder, WhereTerm term)
{
builder.Append("(");
Expression(builder, term.Expr1);
builder.Append(" & ");
Expression(builder, term.Expr2);
builder.Append(") > 0");
}
private void Print(object sender, EventArgs e)
{
int hal = 1;
string print = HeaderDotMetrix(hal);
var reg = new Regex(@"#(.+?)#");
var result = reg.Match(print).Groups[0].Value;
if (result != "")
{
var table = string.Empty;
var pattern = result.Replace("#", "");
var patterns = pattern.Split(' ');
var no = 1;
var row = 1;
var grandPcs = 0;
decimal grandGw = 0;
decimal grandTtl = 0;
var dataSource = GridShipment.DataSource as List <SISCO.Models.ShipmentModel.ShipmentReportRow>;
for (var i = 0; i < dataSource.Count(); i++)
{
table += string.Format("{0} ", no.ToString("#").PadLeft(patterns[0].Length, ' '));
table += string.Format("{0} ", dataSource[i].Code != null ? dataSource[i].Code.PadRight(patterns[1].Length, ' ').Substring(0, patterns[1].Length) : " ".PadRight(patterns[1].Length, ' '));
table += string.Format("{0} ", dataSource[i].DateProcess.ToString("dd-MM-yyyy").PadRight(patterns[2].Length, ' ').Substring(0, patterns[2].Length));
table += string.Format("{0} ", dataSource[i].ShipperName != null ? dataSource[i].ShipperName.PadRight(patterns[3].Length, ' ').Substring(0, patterns[3].Length) : " ".PadRight(patterns[3].Length, ' '));
table += string.Format("{0} ", dataSource[i].ConsigneeName != null ? dataSource[i].ConsigneeName.PadRight(patterns[4].Length, ' ').Substring(0, patterns[4].Length) : " ".PadRight(patterns[4].Length, ' '));
table += string.Format("{0} ", dataSource[i].DestCity != null ? dataSource[i].DestCity.PadRight(patterns[5].Length, ' ').Substring(0, patterns[5].Length) : " ".PadRight(patterns[5].Length, ' '));
table += string.Format("{0} ", dataSource[i].PaymentMethod != null ? dataSource[i].PaymentMethod.PadRight(patterns[6].Length, ' ').Substring(0, patterns[6].Length) : " ".PadRight(patterns[6].Length, ' '));
table += string.Format("{0} ", dataSource[i].PackageType != null ? dataSource[i].PackageType.PadRight(patterns[7].Length, ' ').Substring(0, patterns[7].Length) : " ".PadRight(patterns[7].Length, ' '));
table += string.Format("{0} ", dataSource[i].TtlPiece.ToString("#0").PadLeft(patterns[8].Length, ' '));
table += string.Format("{0} ", dataSource[i].TtlGrossWeight.ToString("#0").PadLeft(patterns[9].Length, ' '));
table += string.Format("{0} ", dataSource[i].Total > 0 ? dataSource[i].Total.ToString("#,#0").PadLeft(patterns[10].Length, ' ').Substring(0, patterns[10].Length) : " ".PadRight(patterns[10].Length, ' '));
table += "\n";
no++;
row++;
grandPcs += dataSource[i].TtlPiece;
grandGw += dataSource[i].TtlGrossWeight;
grandTtl += dataSource[i].Total;
if (row == 55)
{
print = print.Replace(result, table);
var regPcs = new Regex(@"<(.+?)>");
var gPcs = regPcs.Match(print).Groups[0].Value;
var regGw = new Regex(@"{(.+?)}");
var gGw = regGw.Match(print).Groups[0].Value;
var regTtl = new Regex(@"\|(.+?)\|");
var gTtl = regTtl.Match(print).Groups[0].Value;
print = print.Replace(gPcs, grandPcs.ToString("#0").PadLeft(gPcs.Length, ' '));
print = print.Replace(gGw, grandGw.ToString("#0").PadLeft(gGw.Length, ' '));
print = print.Replace(gTtl, grandTtl.ToString("#,#0").PadLeft(gTtl.Length, ' '));
if (BaseControl.UserId > 0)
{
var user = new EmployeeDataManager().GetFirst <EmployeeModel>(WhereTerm.Default((int)BaseControl.UserId, "user_id", EnumSqlOperator.Equals));
print = print.Replace("{PRINTED}",
string.Format("{0} ({1}) {2}", user.Name, user.Code, DateTime.Now.ToString("d-M-yyyy HH:mm")) +
string.Format("{0}", (char)18));
}
table = string.Empty;
hal++;
row = 1;
grandPcs = 0;
grandGw = 0;
grandTtl = 0;
print += string.Format("{0}", (char)12);
print += HeaderDotMetrix(hal);
}
}
print = print.Replace(result, table);
var rPcs = new Regex(@"<(.+?)>");
var grnPcs = rPcs.Match(print).Groups[0].Value;
var rGw = new Regex(@"{(.+?)}");
var grdGw = rGw.Match(print).Groups[0].Value;
var rTtl = new Regex(@"\|(.+?)\|");
var grdTtl = rTtl.Match(print).Groups[0].Value;
print = print.Replace(grnPcs, grandPcs.ToString("#0").PadLeft(grnPcs.Length, ' '));
print = print.Replace(grdGw, grandGw.ToString("#0").PadLeft(grdGw.Length, ' '));
print = print.Replace(grdTtl, grandTtl.ToString("#,#0").PadLeft(grdTtl.Length, ' '));
}
if (BaseControl.UserId > 0)
{
var user = new EmployeeDataManager().GetFirst <EmployeeModel>(WhereTerm.Default((int)BaseControl.UserId, "user_id", EnumSqlOperator.Equals));
print = print.Replace("{PRINTED}",
string.Format("{0} ({1}) {2}", user.Name, user.Code, DateTime.Now.ToString("d-M-yyyy HH:mm")) +
string.Format("{0}", (char)18));
}
var printDialog = new PrintDialog();
printDialog.PrinterSettings = new PrinterSettings();
printDialog.PrinterSettings.PrinterName = BaseControl.PrinterSetting.DotMatrix;
RawPrinterHelper.SendStringToPrinter(printDialog.PrinterSettings.PrinterName, print);
}
private void Print(object sender, ItemClickEventArgs e)
{
var print = new PickupPrint();
using (var printTool = new ReportPrintTool(print))
{
var ds = new FranchisePickupDetailDataManager().GetPickupDetailPrint(CurrentModel.Id);
print.DataSource = ds;
var model = CurrentModel as FranchisePickupModel;
var curModel = new FranchisePickupDataManager().GetFirst <FranchisePickupModel>(WhereTerm.Default(CurrentModel.Id, "id"));
if (curModel != null)
{
if (!curModel.IsPrint)
{
foreach (var obj in ds)
{
InsertTracking = true;
PodStatusModel.ShipmentId = obj.ShipmentId;
PodStatusModel.TrackingStatusId = (int)EnumTrackingStatus.Pickup;
PodStatusModel.EmployeeId = model.MessengerId;
FormTrackingStatus = EnumTrackingStatus.Pickup;
PodStatusModel.PositionStatusId = BaseControl.BranchId;
PodStatusModel.PositionStatus = EnumPositionStatus.Agent.ToString();
ShipmentStatusUpdate();
}
}
curModel.IsPrint = true;
curModel.ModifiedPc = Environment.MachineName;
curModel.Modifiedby = BaseControl.UserLogin;
curModel.Modifieddate = DateTime.Now;
new FranchisePickupDataManager().Update <FranchisePickupModel>(curModel);
}
print.RequestParameters = false;
print.Parameters.Add(new Parameter
{
Name = "Code",
Value = ((FranchisePickupModel)CurrentModel).Code,
Visible = false
});
print.Parameters.Add(new Parameter
{
Name = "DateProcess",
Value = ((FranchisePickupModel)CurrentModel).DateProcess,
Visible = false
});
var franchise = new FranchiseDataManager().GetFirst <FranchiseModel>(WhereTerm.Default(BaseControl.FranchiseId, "id"));
print.Parameters.Add(new Parameter
{
Name = "FranchiseName",
Value = string.Format("{0} {1}", franchise.Code, BaseControl.FranchiseName),
Visible = false
});
print.Parameters.Add(new Parameter
{
Name = "Setoran",
Value = ((FranchisePickupModel)CurrentModel).PaymentTypeAgent == 0 ? "CASH" : "BANK TRANSFER",
Visible = false
});
print.Parameters.Add(new Parameter
{
Name = "Printed",
Value = string.Format("{0} {1}", BaseControl.UserLogin, DateTime.Now.ToString("d-MMM-yyyy HH:mm")),
Visible = false
});
print.CreateDocument();
printTool.PrintingSystem.StartPrint += (o, args) =>
{
args.PrintDocument.PrinterSettings.PrinterName = BaseControl.PrinterSetting.InkJet;
};
printTool.Print();
}
}
private void FormLoad(object sender, EventArgs e)
{
lkpDestination.LookupPopup = new CityPopup();
lkpDestination.AutoCompleteDataManager = new CityServices();
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) };
lkpDestination.EditValueChanged += lkpDestination_EditValueChanged;
lkpPackage.LookupPopup = new PackageTypePopup();
lkpPackage.AutoCompleteDataManager = new PackageTypeServices();
lkpPackage.AutoCompleteDisplayFormater = model => ((PackageTypeModel)model).Name;
lkpPackage.AutoCompleteWheretermFormater = s => new IListParameter[]
{
WhereTerm.Default(s, "name", EnumSqlOperator.BeginWith)
};
lkpPackage.FieldLabel = "Package Type";
lkpPackage.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
lkpPackage.EditValueChanged += lkpPackageType_EditValueChanged;
lkpService.LookupPopup = new ServiceTypePopup("name.Equals(@0) OR name.Equals(@1) OR name.Equals(@2)", "ECO", "ONS", "SUPER ECONOMI");
lkpService.AutoCompleteDataManager = new ServiceTypeServices();
lkpService.AutoCompleteDisplayFormater = model => ((ServiceTypeModel)model).Name;
lkpService.AutoCompleteWhereExpression = (s, p) =>
p.SetWhereExpression("name.StartsWith(@0) AND (name.Equals(@1) OR name.Equals(@2) OR name.Equals(@3))", s, "ECO", "ONS", "SUPER ECONOMI");
lkpService.FieldLabel = "Service Type";
lkpService.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
lkpService.EditValueChanged += lkpServiceType_EditValueChanged;
tbxName.FieldLabel = "Shipper Name";
tbxName.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxAddress.FieldLabel = "Shipper Address";
tbxAddress.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxPhone.FieldLabel = "Shipper Phone";
tbxPhone.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxConsigneeName.FieldLabel = "Consignee Name";
tbxConsigneeName.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxConsigneeAddress.FieldLabel = "Consignee Address";
tbxConsigneeAddress.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxConsigneePhone.FieldLabel = "Consignee Phone";
tbxConsigneePhone.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxTtlPiece.EditMask = "###,##0";
tbxTtlPiece.FieldLabel = "Total Piece";
tbxTtlPiece.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxTtlGrossWeight.EditMask = "###,##0.0";
tbxTtlGrossWeight.FieldLabel = "Total Weight";
tbxTtlGrossWeight.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxTtlChargeable.EditMask = "###,##0.0";
tbxTtlChargeable.FieldLabel = "Chargeable Weight";
tbxTtlChargeable.ValidationRules = new[] { new ComponentValidationRule(EnumComponentValidationRule.Mandatory) };
tbxTtlChargeable.EditValueChanged += lkpDestination_EditValueChanged;
tbxDiscount.EditMask = "#0.0%%";
tbxName.CharacterCasing = CharacterCasing.Upper;
tbxAddress.CharacterCasing = CharacterCasing.Upper;
tbxPhone.CharacterCasing = CharacterCasing.Upper;
tbxConsigneeName.CharacterCasing = CharacterCasing.Upper;
tbxConsigneeAddress.CharacterCasing = CharacterCasing.Upper;
tbxConsigneePhone.CharacterCasing = CharacterCasing.Upper;
tbxRef.CharacterCasing = CharacterCasing.Upper;
tbxNote.CharacterCasing = CharacterCasing.Upper;
tbxNatureOfGood.CharacterCasing = CharacterCasing.Upper;
tbxName.MaxLength = 100;
tbxAddress.MaxLength = 254;
tbxPhone.MaxLength = 50;
tbxConsigneeName.MaxLength = 100;
tbxConsigneeAddress.MaxLength = 254;
tbxConsigneePhone.MaxLength = 50;
tbxRef.MaxLength = 50;
tbxNote.MaxLength = 100;
tbxNatureOfGood.MaxLength = 50;
tbxTtlGrossWeight.TextChanged += GrossWeightChange;
FormTrackingStatus = EnumTrackingStatus.FranchiseDataEntry;
cbxMobilePoint.Click += (s, o) =>
{
if (cbxMobilePoint.Checked)
{
tbxEmailPoint.Focus();
tbxEmailPoint.Enabled = true;
}
else
{
tbxEmailPoint.Clear();
tbxEmailPoint.Enabled = false;
}
};
btnSave.Click += (s, o) =>
{
if (Save())
{
NoResi = tbxResi.Text;
form.Close();
}
};
btnSavePrint.Click += (s, o) =>
{
if (string.IsNullOrEmpty(BaseControl.PrinterSetting.InkJet))
{
MessageBox.Show("Lakukan setting ulang printer di menu Preference/Printer Preference");
return;
}
if (Save())
{
NoResi = tbxResi.Text;
var printout = new EConnotePrintout
{
DataSource = GetPrintDataSource()
};
# if (DEBUG)
printout.PrintPreview();
# else
printout.Print();
# endif
protected override FranchisePickupModel Find(string searchTerm)
{
return(DataManager.GetFirst <FranchisePickupModel>(WhereTerm.Default(searchTerm, "code")));
}
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);
}
public WhereTermCollection(WhereTerm[] val)
{
this.AddRange(val);
}
protected override void OnLoaded()
{
base.OnLoaded();
AppearanceReadOnly.TextOptions.HAlignment = HorzAlignment.Near;
_autocompleteCache = new Dictionary <int, string>();
ButtonClick += (sender, args) =>
{
var dLookup = sender as dLookupF;
if (dLookup != null && dLookup.Enabled)
{
dLookup.OpenLookupPopup();
}
};
CustomDisplayText += (sender, args) =>
{
int output;
if (args.Value != null && int.TryParse(args.Value.ToString(), out output))
{
var model = AutoCompleteDataManager.GetFirst <IBaseModel>(WhereTerm.Default(output, "id"));
args.DisplayText = model != null?AutoCompleteDisplayFormater(model) : string.Empty;
_autocompleteCache.Clear();
_autocompleteCache.Add(output, args.DisplayText);
}
};
ParseEditValue += (sender, args) =>
{
if (_parsingEditValue)
{
return;
}
if (_skipNextEditValueParsing)
{
_skipNextEditValueParsing = false;
return;
}
_parsingEditValue = true;
int output;
var lookup = sender as dLookupF;
if (lookup == null)
{
return;
}
if (args.Value != null && int.TryParse(args.Value.ToString(), out output))
{
if (!_autocompleteCache.ContainsKey(output))
{
lookup.DefaultValue = new IListParameter[] { WhereTerm.Default(output, "id") };
args.Value = lookup.DisplayString;
_previousDisplayString = lookup.DisplayString;
_autocompleteCache.Add(output, lookup.DisplayString);
}
else
{
lookup.Value = output;
args.Value = _autocompleteCache[output];
}
}
else if (lookup.Value != null && int.TryParse(lookup.Value.ToString(), out output))
{
if (args.Value != null && !args.Value.Equals(_previousDisplayString))
{
_skipNextEditValueParsing = true;
}
args.Value = output;
}
_skipNextEditValueParsing = true;
args.Handled = true;
_parsingEditValue = false;
};
FormatEditValue += (sender, args) =>
{
if (_formattingEditValue)
{
return;
}
_formattingEditValue = true;
int output;
if (args.Value != null && int.TryParse(args.Value.ToString(), out output))
{
if (!_autocompleteCache.ContainsKey(output))
{
var model = AutoCompleteDataManager.GetFirst <IBaseModel>(WhereTerm.Default(output, "id"));
args.Value = model != null?AutoCompleteDisplayFormater(model) : string.Empty;
_autocompleteCache.Add(output, args.Value.ToString());
}
else
{
args.Value = _autocompleteCache[output];
}
}
args.Handled = true;
_formattingEditValue = false;
};
}
public bool Contains(WhereTerm val)
{
return base.List.Contains(val);
}
/// <summary>
/// Renders a single WhereTerm
/// </summary>
/// <param name="builder"></param>
/// <param name="term"></param>
protected virtual void WhereClause(StringBuilder builder, WhereTerm term)
{
if (term.Type == WhereTermType.Compare && term.Op == CompareOperator.BitwiseAnd)
{
BitwiseAnd(builder, term);
}
else if (term.Type == WhereTermType.Compare)
{
Expression(builder, term.Expr1);
builder.Append(" ");
Operator(builder, term.Op);
builder.Append(" ");
Expression(builder, term.Expr2);
}
else if (term.Type == WhereTermType.In || term.Type == WhereTermType.NotIn ||
term.Type == WhereTermType.InSubQuery || term.Type == WhereTermType.NotInSubQuery)
{
Expression(builder, term.Expr1);
if (term.Type == WhereTermType.NotIn || term.Type == WhereTermType.NotInSubQuery)
{
builder.Append(" not");
}
builder.Append(" in (");
if (term.Type == WhereTermType.InSubQuery || term.Type == WhereTermType.NotInSubQuery)
{
builder.Append(term.SubQuery);
}
else
{
ConstantList(builder, term.Values);
}
builder.Append(")");
}
else if (term.Type == WhereTermType.Exists || term.Type == WhereTermType.NotExists)
{
if (term.Type == WhereTermType.NotExists)
{
builder.Append(" not");
}
builder.Append(" exists (");
builder.Append(term.SubQuery);
builder.Append(")");
}
else if (term.Type == WhereTermType.Between)
{
Expression(builder, term.Expr1);
builder.AppendFormat(" between ");
Expression(builder, term.Expr2);
builder.AppendFormat(" and ");
Expression(builder, term.Expr3);
}
else if (term.Type == WhereTermType.IsNull || term.Type == WhereTermType.IsNotNull)
{
Expression(builder, term.Expr1);
builder.Append(" is ");
if (term.Type == WhereTermType.IsNotNull)
{
builder.Append("not ");
}
builder.Append(" null ");
}
}
public void CopyTo(WhereTerm[] array, int index)
{
base.List.CopyTo(array, index);
}
/// <summary>
/// Renders a single WhereTerm
/// </summary>
/// <param name="builder"></param>
/// <param name="term"></param>
protected virtual void WhereClause(StringBuilder builder, WhereTerm term)
{
if (term.Type == WhereTermType.Compare && term.Op == CompareOperator.BitwiseAnd)
{
BitwiseAnd(builder, term);
}
else if (term.Type == WhereTermType.Compare)
{
Expression(builder, term.Expr1);
builder.Append(" ");
Operator(builder, term.Op);
builder.Append(" ");
Expression(builder, term.Expr2);
}
else if (term.Type == WhereTermType.In || term.Type == WhereTermType.NotIn ||
term.Type == WhereTermType.InSubQuery || term.Type == WhereTermType.NotInSubQuery)
{
Expression(builder, term.Expr1);
if (term.Type == WhereTermType.NotIn || term.Type == WhereTermType.NotInSubQuery)
{
builder.Append(" not");
}
builder.Append(" in (");
if (term.Type == WhereTermType.InSubQuery || term.Type == WhereTermType.NotInSubQuery)
{
builder.Append(term.SubQuery);
}
else
{
ConstantList(builder, term.Values);
}
builder.Append(")");
}
else if (term.Type == WhereTermType.Exists || term.Type == WhereTermType.NotExists)
{
if (term.Type == WhereTermType.NotExists)
{
builder.Append(" not");
}
builder.Append(" exists (");
builder.Append(term.SubQuery);
builder.Append(")");
}
else if (term.Type == WhereTermType.Between)
{
Expression(builder, term.Expr1);
builder.AppendFormat(" between ");
Expression(builder, term.Expr2);
builder.AppendFormat(" and ");
Expression(builder, term.Expr3);
}
else if (term.Type == WhereTermType.IsNull || term.Type == WhereTermType.IsNotNull)
{
Expression(builder, term.Expr1);
builder.Append(" is ");
if (term.Type == WhereTermType.IsNotNull)
{
builder.Append("not ");
}
builder.Append(" null ");
}
}
public int IndexOf(WhereTerm val)
{
return base.List.IndexOf(val);
}
