public ActionResult NewAllowances(AllowancesModel All)
{
if (ModelState.IsValid)
{
using (context = new BPOContext())
{
Allowances all = new Allowances()
{
Allowance_Name = All.Allowance_Name,
Amount = All.Amount,
Emp_ID = All.Emp_ID,
ID = All.ID
};
context.Allowances.Add(all);
context.SaveChanges();
var obj = context.Employee.ToList();
ViewBag.employee = obj;
}
}
return(View());
}
public dynamic GetIndemnityModel()
{
dynamic Model = new ExpandoObject();
Model.EOSBAllowances = Allowances.Where(x => x.Dimension_1_Value.ToUpper() == "TRUE").ToList();
Model.EOSBDS = null;
return(Model);
}
public dynamic GetSIReportModel()
{
dynamic Model = new ExpandoObject();
List <SIContributionCategory_Dto> SIContributionCategories = Model.SIContributionCategories; Model.SIContributionCategories = SIContributionCategories;
Model.SIAllowances = Allowances.Where(x => x.Dimension_2_Value.ToUpper() == "TRUE").ToList();
Model.SIDS = null;
return(Model);
}
/// <summary>
/// 根据ID获取补助标准
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public Allowances GetAloneAllowances(int Id)
{
using (MySqlConnection conn = DapperHelper.GetConnString())
{
conn.Open();
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", Id, null, null, null);
string sql = "SELECT Id, WeekDaysSubsidy,EvectionSubsidy,HolidaysOverTime,HolidaysRest,ExchangeSubsidy,MealSubsidy,ReleaseTime,ModificationTime,HistoricalInformation,HistoricalInformationNum,IsReadOnly FROM allowances WHERE Id=@Id";
Allowances allowances = conn.Query <Allowances>(sql, parameters).FirstOrDefault();
return(allowances);
}
}
internal AllowancesBLL MapAllowance(Allowances item)
{
return(item != null ?
new AllowancesBLL()
{
AllowanceID = item.AllowanceID,
AllowanceName = item.AllowanceName,
AllowanceAmountType = new AllowancesAmountTypesBLL().MapAllowanceAmountType(item.AllowancesAmountTypes),
AllowanceCalculationType = new AllowancesCalculationTypesBLL().MapAllowanceCalculationType(item.AllowancesCalculationTypes),
AllowanceAmount = item.AllowanceAmount,
IsActive = item.IsActive
}
: null);
}
public virtual Result Update()
{
Result result = new Result();
Allowances Allowance = new Allowances();
Allowance.AllowanceID = this.AllowanceID;
Allowance.AllowanceName = this.AllowanceName;
Allowance.AllowanceAmountTypeID = this.AllowanceAmountType.AllowanceAmountTypeID;
Allowance.AllowanceCalculationTypeID = this.AllowanceCalculationType.AllowanceCalculationTypeID;
Allowance.AllowanceAmount = this.AllowanceAmount;
Allowance.IsActive = this.IsActive;
Allowance.LastUpdatedDate = DateTime.Now;
Allowance.LastUpdatedBy = this.LoginIdentity.EmployeeCodeID;
this.AllowanceID = new AllowancesDAL().Update(Allowance);
if (this.AllowanceID != 0)
{
result.Entity = this;
result.EnumType = typeof(LookupsValidationEnum);
result.EnumMember = LookupsValidationEnum.Done.ToString();
}
return(result);
}
public void SetAllowed(RecipeDef recipeDef, bool allowed)
{
//Log.Message( string.Format( "{0}.SetAllowed( {1}, {2} )", this.ThingID, recipeDef == null ? "null" : recipeDef.defName, allowed ) );
var inAllowed = allowed;
var product = recipeDef.products[0].thingDef;
allowed &= (
(recipeDef.researchPrerequisite == null) ||
(recipeDef.researchPrerequisite.IsFinished)
);
Allowances allowance;
if (productionAllowances.TryGetValue(product, out allowance))
{
allowance.allowed = allowed;
productionAllowances[product].allowed = allowed;
}
else
{
allowance = new Allowances(recipeDef, allowed);
productionAllowances.Add(product, allowance);
}
}
/// <summary>
/// 添加补助标准
/// </summary>
/// <param name="addAllowances"></param>
/// <returns></returns>
public int AddAllowances(Allowances addAllowances)
{
using (MySqlConnection conn = DapperHelper.GetConnString())
{
conn.Open();
addAllowances.ModificationTime = DateTime.Now;
//addAllowances.IsReadOnly = 0;
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@WeekDaysSubsidy", addAllowances.WeekDaysSubsidy, null, null, null);
parameters.Add("@EvectionSubsidy", addAllowances.EvectionSubsidy, null, null, null);
parameters.Add("@HolidaysOverTime", addAllowances.HolidaysOverTime, null, null, null);
parameters.Add("@HolidaysRest", addAllowances.HolidaysRest, null, null, null);
parameters.Add("@ExchangeSubsidy", addAllowances.ExchangeSubsidy, null, null, null);
parameters.Add("@MealSubsidy", addAllowances.MealSubsidy, null, null, null);
parameters.Add("@ReleaseTime", addAllowances.ReleaseTime, null, null, null);
parameters.Add("@ModificationTime", addAllowances.ModificationTime, null, null, null);
parameters.Add("@HistoricalInformation", addAllowances.HistoricalInformation, null, null, null);
parameters.Add("@HistoricalInformationNum", addAllowances.HistoricalInformationNum, null, null, null);
parameters.Add("@IsReadOnly", addAllowances.IsReadOnly, null, null, null);
string sql = "INSERT INTO allowances(WeekDaysSubsidy,EvectionSubsidy,HolidaysOverTime,HolidaysRest,ExchangeSubsidy,MealSubsidy,ReleaseTime,ModificationTime,HistoricalInformation,HistoricalInformationNum,IsReadOnly) VALUES(@WeekDaysSubsidy,@EvectionSubsidy,@HolidaysOverTime,@HolidaysRest,@ExchangeSubsidy,@MealSubsidy,@ReleaseTime,@ModificationTime,@HistoricalInformation,@HistoricalInformationNum,@IsReadOnly)";
int i = conn.Execute(sql, parameters);
return(i);
}
}
/// <summary>
/// 修改补助标准
/// </summary>
/// <param name="uptAllowances"></param>
/// <returns></returns>
public int UpdateAllowances(Allowances uptAllowances)
{
using (MySqlConnection conn = DapperHelper.GetConnString())
{
conn.Open();
uptAllowances.ModificationTime = DateTime.Now;
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@WeekDaysSubsidy", uptAllowances.WeekDaysSubsidy, null, null, null);
parameters.Add("@EvectionSubsidy", uptAllowances.EvectionSubsidy, null, null, null);
parameters.Add("@HolidaysOverTime", uptAllowances.HolidaysOverTime, null, null, null);
parameters.Add("@HolidaysRest", uptAllowances.HolidaysRest, null, null, null);
parameters.Add("@ExchangeSubsidy", uptAllowances.ExchangeSubsidy, null, null, null);
parameters.Add("@MealSubsidy", uptAllowances.MealSubsidy, null, null, null);
parameters.Add("@ReleaseTime", uptAllowances.ReleaseTime, null, null, null);
parameters.Add("@ModificationTime", uptAllowances.ModificationTime, null, null, null);
parameters.Add("@HistoricalInformation", uptAllowances.HistoricalInformation, null, null, null);
parameters.Add("@HistoricalInformationNum", uptAllowances.HistoricalInformationNum, null, null, null);
parameters.Add("@IsReadOnly", uptAllowances.IsReadOnly, null, null, null);
parameters.Add("@Id", uptAllowances.Id, null, null, null);
string sql = "UPDATE allowances SET WeekDaysSubsidy=@WeekDaysSubsidy,EvectionSubsidy=@EvectionSubsidy,HolidaysOverTime=@HolidaysOverTime,HolidaysRest=@HolidaysRest,ExchangeSubsidy=@ExchangeSubsidy,MealSubsidy=@MealSubsidy,ReleaseTime=@ReleaseTime,ModificationTime=@ModificationTime,HistoricalInformation=@HistoricalInformation,HistoricalInformationNum=@HistoricalInformationNum,IsReadOnly=@IsReadOnly WHERE Id=@Id";
int i = conn.Execute(sql, parameters);
return(i);
}
}
public SelfEmploymentAnnualSummaryResponse()
{
adjustments = new Adjustments();
allowances = new Allowances();
nonFinancials = new Nonfinancials();
}
public int AddAllowances(Allowances addAllowances)
{
int i = IallowancesServices.AddAllowances(addAllowances);
return(i);
}
public int UpdateAllowances(Allowances uptAllowances)
{
int i = IallowancesServices.UpdateAllowances(uptAllowances);
return(i);
}
