protected override void Insert()
{
HPS.BLL.StopFeeBLL.BLLStopFee_TFactory StopFeeFactory = new HPS.BLL.StopFeeBLL.BLLStopFee_TFactory();
try
{
HPS.BLL.StopFeeBLL.BLLStopFee_T StopFeeEntity = new HPS.BLL.StopFeeBLL.BLLStopFee_T();
StopFeeEntity.AllowedHoure_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(AllowedHoure_intNumericTextBox.NumericText, TypeCode.Int32);
StopFeeEntity.Fee_dec = (Decimal)Hepsa.Core.Common.PersentationController.GetEntityValue(Fee_decNumericTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.ExtraHour_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(ExtraHour_intNumericTextBox.NumericText, TypeCode.Int32);
StopFeeEntity.ExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(ExtraHourFee_decNumericTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.WithLadeExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(WithLadeExtraHourFee_decNumericTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.TrafficTypeID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficTypeID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.LaderPivotGroupID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(LaderPivotGroupID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.ServicesID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(ServicesID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.Tax_bit = Tax_bitcheckBox.Checked;
StopFeeEntity.TurnNotLadBillExtraHour_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(TurnNotLadBillExtraHour_intTextBox.Text, TypeCode.Int32);
StopFeeEntity.TurnNotLadBillExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(TurnNotLadBillExtraHourFee_decTextBox.NumericText, TypeCode.Decimal);
if (StartDate_nvcTextBox.Enabled && StartDate_nvcTextBox.Text.CompareTo(StopFeeFactory.ServerJalaliDate) < 0)
{
throw new ApplicationException("تاریخ شروع نمی تواند کوچکتر از تاریخ جاری باشد");
}
if (EndDate_nvcTextBox.Enabled && EndDate_nvcTextBox.Text.CompareTo(StopFeeFactory.ServerJalaliDate) < 0)
{
throw new ApplicationException("تاریخ اتمام نمی تواند کوچکتر از تاریخ جاری باشد");
}//, StopFeeEntity.ServicesID_int.HasValue ? StopFeeEntity.ServicesID_int.ToString() : "NULL" AND StopFee_T.ServicesID_int='{3}'
string Condition = string.Empty;
if (StopFeeEntity.WithLadeExtraHourFee_dec.HasValue == false)
{
Condition = string.Format("StopFee_T.TrafficTypeID_int='{0}' And StopFee_T.LaderPivotGroupID_int='{1}' AND StopFee_T.WithLadeExtraHourFee_dec is NULL ", StopFeeEntity.TrafficTypeID_int, StopFeeEntity.LaderPivotGroupID_int);
}
else
{
Condition = string.Format("StopFee_T.TrafficTypeID_int='{0}' And StopFee_T.LaderPivotGroupID_int='{1}' AND StopFee_T.WithLadeExtraHourFee_dec is not null ", StopFeeEntity.TrafficTypeID_int, StopFeeEntity.LaderPivotGroupID_int);
}
if (StopFeeEntity.ExtraHourFee_dec.HasValue)
{
Condition += string.Format(" AND StopFee_T.ExtraHourFee_dec IS NOT Null");
}
else
{
Condition += string.Format(" AND StopFee_T.ExtraHourFee_dec Is Null ");
}
if (StopFeeEntity.ServicesID_int.HasValue == false)
{
Condition += " AND StopFee_T.ServicesID_int Is Null";
}
else
{
Condition += string.Format(" AND StopFee_T.ServicesID_int={0}", StopFeeEntity.ServicesID_int);
}
List <HPS.BLL.StopFeeBLL.BLLStopFee_T> StopFeeDateList = StopFeeFactory.GetAllByCondition(Condition);
if (StopFeeDateList != null && StopFeeDateList.Count > 0)
{
foreach (HPS.BLL.StopFeeBLL.BLLStopFee_T item in StopFeeDateList)
{
if (!(StartDate_nvcTextBox.Text.CompareTo(item.EndDate_nvc) > 0 || EndDate_nvcTextBox.Text.CompareTo(item.StartDate_nvc) < 0))
{
throw new ApplicationException("براي تاريخ وارد شده حق پاركينگ تعريف شده است");
}
}
}
StopFeeEntity.StartDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(StartDate_nvcTextBox.Text, TypeCode.String).ToString();
StopFeeEntity.EndDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(EndDate_nvcTextBox.Text, TypeCode.String).ToString();
StopFeeEntity.Date_nvc = StopFeeFactory.ServerJalaliDate;
StopFeeEntity.Time_nvc = StopFeeFactory.ServerTime;
StopFeeEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
StopFeeFactory.BeginProc();
StopFeeFactory.Insert(StopFeeEntity);
StopFeeFactory.CommitProc();
if (DataTable != null)
{
DataRow dr = this.DataTable.NewRow();
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.StopFeeID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.StopFeeID_int, TypeCode.Int32);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.AllowedHoure_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.AllowedHoure_int, TypeCode.Int32);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Fee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Fee_dec, TypeCode.Decimal);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.ExtraHour_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.ExtraHour_int, TypeCode.Int32);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.ExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.ExtraHourFee_dec, TypeCode.Decimal);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.TrafficTypeID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.TrafficTypeID_int, TypeCode.Int32);
dr["TrafficTypeID_intTrafficType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(TrafficTypeID_intComboBox);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.LaderPivotGroupID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.LaderPivotGroupID_int, TypeCode.Int32);
dr["LaderPivotGroupID_intLaderPivotGroup_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(LaderPivotGroupID_intComboBox);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.StartDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.StartDate_nvc, TypeCode.String);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.EndDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.EndDate_nvc, TypeCode.String);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Date_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Date_nvc, TypeCode.String);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Time_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Time_nvc, TypeCode.String);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.UserName_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.UserName_nvc, TypeCode.String);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.WithLadeExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.WithLadeExtraHourFee_dec, TypeCode.Decimal);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.ServicesID_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.ServicesID_int, TypeCode.Int32);
dr["ServicesID_intServicesType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(ServicesID_intComboBox);
dr["Tax_bit"] = Hepsa.Core.Common.PersentationController.GetCheckBoxValue(Tax_bitcheckBox.Checked);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.TurnNotLadBillExtraHour_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.TurnNotLadBillExtraHour_int, TypeCode.Int32);
dr[HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.TurnNotLadBillExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.TurnNotLadBillExtraHourFee_dec, TypeCode.Decimal);
DataTable.Rows.Add(dr);
DataTable.AcceptChanges();
}
this.ClearForm(this);
}
catch (Exception ex)
{
StopFeeFactory.RollBackProc();
throw ex;
}
}
protected override void Edit()
{
HPS.BLL.StopFeeBLL.BLLStopFee_TFactory StopFeeFactory = new HPS.BLL.StopFeeBLL.BLLStopFee_TFactory();
try
{
HPS.BLL.StopFeeBLL.BLLStopFee_T StopFeeEntity = new HPS.BLL.StopFeeBLL.BLLStopFee_T();
StopFeeEntity.AllowedHoure_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(AllowedHoure_intNumericTextBox.NumericText, TypeCode.Int32);
StopFeeEntity.Fee_dec = (Decimal)Hepsa.Core.Common.PersentationController.GetEntityValue(Fee_decNumericTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.ExtraHour_int = (Int32)Hepsa.Core.Common.PersentationController.GetEntityValue(ExtraHour_intNumericTextBox.NumericText, TypeCode.Int32);
StopFeeEntity.ExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(ExtraHourFee_decNumericTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.TrafficTypeID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(TrafficTypeID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.LaderPivotGroupID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(LaderPivotGroupID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.ServicesID_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(ServicesID_intComboBox.SelectedValue, TypeCode.Int32);
StopFeeEntity.Tax_bit = Tax_bitcheckBox.Checked;
if (StartDate_nvcTextBox.Enabled && StartDate_nvcTextBox.Text.CompareTo(StopFeeFactory.ServerJalaliDate) < 0)
{
throw new ApplicationException("تاریخ شروع نمی تواند کوچکتر از تاریخ جاری باشد");
}
if (EndDate_nvcTextBox.Enabled && EndDate_nvcTextBox.Text.CompareTo(StopFeeFactory.ServerJalaliDate) < 0)
{
throw new ApplicationException("تاریخ اتمام نمی تواند کوچکتر از تاریخ جاری باشد");
}
string Condition = string.Format("StopFee_T.TrafficTypeID_int='{0}' And StopFee_T.LaderPivotGroupID_int='{1}' And StopFee_T.StopFeeID_int<>{2} AND StopFee_T.WithLadeExtraHourFee_dec={3} AND StopFee_T.ServicesID_int={4}", StopFeeEntity.TrafficTypeID_int, StopFeeEntity.LaderPivotGroupID_int, ((HPS.BLL.StopFeeBLL.BLLStopFee_TKeys)Key).StopFeeID_int.ToString(), StopFeeEntity.WithLadeExtraHourFee_dec.HasValue ? StopFeeEntity.WithLadeExtraHourFee_dec.ToString() : "NULL", StopFeeEntity.ServicesID_int.HasValue?StopFeeEntity.ServicesID_int.ToString():"NULL");
List <HPS.BLL.StopFeeBLL.BLLStopFee_T> StopFeeDateList = StopFeeFactory.GetAllByCondition(Condition);
if (StopFeeDateList != null && StopFeeDateList.Count > 0)
{
foreach (HPS.BLL.StopFeeBLL.BLLStopFee_T item in StopFeeDateList)
{
if (!(StartDate_nvcTextBox.Text.CompareTo(item.EndDate_nvc) > 0 || EndDate_nvcTextBox.Text.CompareTo(item.StartDate_nvc) < 0))
{
throw new ApplicationException("براي تاريخ وارد شده حق پاركينگ تعريف شده است");
}
}
}
StopFeeEntity.TurnNotLadBillExtraHour_int = (Nullable <Int32>)Hepsa.Core.Common.PersentationController.GetEntityValue(TurnNotLadBillExtraHour_intTextBox.Text, TypeCode.Int32);
StopFeeEntity.TurnNotLadBillExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(TurnNotLadBillExtraHourFee_decTextBox.NumericText, TypeCode.Decimal);
StopFeeEntity.StartDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(StartDate_nvcTextBox.Text, TypeCode.String).ToString();
StopFeeEntity.EndDate_nvc = Hepsa.Core.Common.PersentationController.GetEntityValue(EndDate_nvcTextBox.Text, TypeCode.String).ToString();
StopFeeEntity.Date_nvc = StopFeeFactory.ServerJalaliDate;
StopFeeEntity.Time_nvc = StopFeeFactory.ServerTime;
StopFeeEntity.UserName_nvc = HPS.Common.CurrentUser.user.UserName_nvc;
StopFeeEntity.WithLadeExtraHourFee_dec = (Nullable <Decimal>)Hepsa.Core.Common.PersentationController.GetEntityValue(WithLadeExtraHourFee_decNumericTextBox.NumericText, TypeCode.Decimal);
if (Hepsa.Core.Common.MessageBox.ConfirmMessage(HPS.Exceptions.ExceptionCs.EditMessage) == true)
{
StopFeeFactory.BeginProc();
StopFeeFactory.Update(StopFeeEntity, (HPS.BLL.StopFeeBLL.BLLStopFee_TKeys)Key);
StopFeeFactory.CommitProc();
if (DataTable != null)
{
DataRow[] dr = DataTable.Select(HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.StopFeeID_int.ToString() + "='" + ((HPS.BLL.StopFeeBLL.BLLStopFee_TKeys)Key).StopFeeID_int.ToString() + "'");
if (dr.Length > 0)
{
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.AllowedHoure_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.AllowedHoure_int, TypeCode.Int32);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Fee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Fee_dec, TypeCode.Decimal);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.ExtraHour_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.ExtraHour_int, TypeCode.Int32);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.ExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.ExtraHourFee_dec, TypeCode.Decimal);
dr[0]["TrafficTypeID_intTrafficType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(TrafficTypeID_intComboBox);
dr[0]["LaderPivotGroupID_intLaderPivotGroup_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(LaderPivotGroupID_intComboBox);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.StartDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.StartDate_nvc, TypeCode.String);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.EndDate_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.EndDate_nvc, TypeCode.String);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Date_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Date_nvc, TypeCode.String);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.Time_nvc.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.Time_nvc, TypeCode.String);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.WithLadeExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.WithLadeExtraHourFee_dec, TypeCode.Decimal);
dr[0]["ServicesID_intServicesType_nvc"] = Hepsa.Core.Common.PersentationController.GetComboBoxDisplayMember(ServicesID_intComboBox);
dr[0]["Tax_bit"] = Hepsa.Core.Common.PersentationController.GetCheckBoxValue(Tax_bitcheckBox.Checked);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.TurnNotLadBillExtraHour_int.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.TurnNotLadBillExtraHour_int, TypeCode.Int32);
dr[0][HPS.BLL.StopFeeBLL.BLLStopFee_T.StopFee_TField.TurnNotLadBillExtraHourFee_dec.ToString()] = Hepsa.Core.Common.PersentationController.GetEntityValueInDatabaseFormat(StopFeeEntity.TurnNotLadBillExtraHourFee_dec, TypeCode.Decimal);
}
DataTable.AcceptChanges();
}
}
}
catch (Exception ex)
{
StopFeeFactory.RollBackProc();
throw ex;
}
}