protected virtual int ExecuteAction(MyCompany.Models.CoaDetail theCoaDetail, MyCompany.Models.CoaDetail original_CoaDetail, string lastCommandName, string commandName, string dataView)
{
ActionArgs args = new ActionArgs();
args.Controller = "CoaDetail";
args.View = dataView;
args.Values = CreateFieldValues(theCoaDetail, original_CoaDetail);
args.LastCommandName = lastCommandName;
args.CommandName = commandName;
ActionResult result = ControllerFactory.CreateDataController().Execute("CoaDetail", dataView, args);
result.RaiseExceptionIfErrors();
result.AssignTo(theCoaDetail);
return(result.RowsAffected);
}
protected virtual FieldValue[] CreateFieldValues(MyCompany.Models.CoaDetail theCoaDetail, MyCompany.Models.CoaDetail original_CoaDetail)
{
List <FieldValue> values = new List <FieldValue>();
values.Add(new FieldValue("CoaDetailID", original_CoaDetail.CoaDetailID, theCoaDetail.CoaDetailID, true));
values.Add(new FieldValue("AccFundID", original_CoaDetail.AccFundID, theCoaDetail.AccFundID));
values.Add(new FieldValue("AccFundCode", original_CoaDetail.AccFundCode, theCoaDetail.AccFundCode));
values.Add(new FieldValue("Acccode", original_CoaDetail.Acccode, theCoaDetail.Acccode));
values.Add(new FieldValue("AccName", original_CoaDetail.AccName, theCoaDetail.AccName));
values.Add(new FieldValue("AccDesc", original_CoaDetail.AccDesc, theCoaDetail.AccDesc));
values.Add(new FieldValue("AccTypeID", original_CoaDetail.AccTypeID, theCoaDetail.AccTypeID));
values.Add(new FieldValue("AccDestID", original_CoaDetail.AccDestID, theCoaDetail.AccDestID));
values.Add(new FieldValue("AccBalTypeID", original_CoaDetail.AccBalTypeID, theCoaDetail.AccBalTypeID));
values.Add(new FieldValue("AccCurrency", original_CoaDetail.AccCurrency, theCoaDetail.AccCurrency));
values.Add(new FieldValue("ConsTranCode", original_CoaDetail.ConsTranCode, theCoaDetail.ConsTranCode));
values.Add(new FieldValue("CoaControlID", original_CoaDetail.CoaControlID, theCoaDetail.CoaControlID));
values.Add(new FieldValue("CoaSubID", original_CoaDetail.CoaSubID, theCoaDetail.CoaSubID));
values.Add(new FieldValue("CoaMainID", original_CoaDetail.CoaMainID, theCoaDetail.CoaMainID));
values.Add(new FieldValue("TranCode", original_CoaDetail.TranCode, theCoaDetail.TranCode));
values.Add(new FieldValue("SubsYn", original_CoaDetail.SubsYn, theCoaDetail.SubsYn));
values.Add(new FieldValue("AccSubTypeID", original_CoaDetail.AccSubTypeID, theCoaDetail.AccSubTypeID));
values.Add(new FieldValue("OpenDate", original_CoaDetail.OpenDate, theCoaDetail.OpenDate));
values.Add(new FieldValue("OpenDebit", original_CoaDetail.OpenDebit, theCoaDetail.OpenDebit));
values.Add(new FieldValue("OpenCredit", original_CoaDetail.OpenCredit, theCoaDetail.OpenCredit));
values.Add(new FieldValue("AccCurrencyRate", original_CoaDetail.AccCurrencyRate, theCoaDetail.AccCurrencyRate));
values.Add(new FieldValue("Revenue", original_CoaDetail.Revenue, theCoaDetail.Revenue));
values.Add(new FieldValue("VariableCost", original_CoaDetail.VariableCost, theCoaDetail.VariableCost));
values.Add(new FieldValue("MonthlyExp", original_CoaDetail.MonthlyExp, theCoaDetail.MonthlyExp));
values.Add(new FieldValue("Budget", original_CoaDetail.Budget, theCoaDetail.Budget));
values.Add(new FieldValue("Annex", original_CoaDetail.Annex, theCoaDetail.Annex));
values.Add(new FieldValue("Dlt", original_CoaDetail.Dlt, theCoaDetail.Dlt));
values.Add(new FieldValue("IsCashNature", original_CoaDetail.IsCashNature, theCoaDetail.IsCashNature));
values.Add(new FieldValue("IsBankNature", original_CoaDetail.IsBankNature, theCoaDetail.IsBankNature));
values.Add(new FieldValue("AccSubTypeID1", original_CoaDetail.AccSubTypeID1, theCoaDetail.AccSubTypeID1));
values.Add(new FieldValue("AccSubTypeID2", original_CoaDetail.AccSubTypeID2, theCoaDetail.AccSubTypeID2));
values.Add(new FieldValue("BankName", original_CoaDetail.BankName, theCoaDetail.BankName));
values.Add(new FieldValue("BankAccNum", original_CoaDetail.BankAccNum, theCoaDetail.BankAccNum));
values.Add(new FieldValue("BranchName", original_CoaDetail.BranchName, theCoaDetail.BranchName));
values.Add(new FieldValue("BankAccType", original_CoaDetail.BankAccType, theCoaDetail.BankAccType));
values.Add(new FieldValue("AccTypeSetupID", original_CoaDetail.AccTypeSetupID, theCoaDetail.AccTypeSetupID));
values.Add(new FieldValue("AccNameBg", original_CoaDetail.AccNameBg, theCoaDetail.AccNameBg));
values.Add(new FieldValue("ColumnSerail", original_CoaDetail.ColumnSerail, theCoaDetail.ColumnSerail));
values.Add(new FieldValue("Slno", original_CoaDetail.Slno, theCoaDetail.Slno));
return(values.ToArray());
}
public virtual int Delete(MyCompany.Models.CoaDetail theCoaDetail)
{
return(ExecuteAction(theCoaDetail, theCoaDetail, "Select", "Delete", DeleteView));
}
public virtual int Insert(MyCompany.Models.CoaDetail theCoaDetail)
{
return(ExecuteAction(theCoaDetail, new CoaDetail(), "New", "Insert", InsertView));
}
public virtual int Update(MyCompany.Models.CoaDetail theCoaDetail)
{
return(Update(theCoaDetail, SelectSingle(theCoaDetail.CoaDetailID)));
}
public virtual int Update(MyCompany.Models.CoaDetail theCoaDetail, MyCompany.Models.CoaDetail original_CoaDetail)
{
return(ExecuteAction(theCoaDetail, original_CoaDetail, "Edit", "Update", UpdateView));
}
public List <MyCompany.Models.CoaDetail> Select(MyCompany.Models.CoaDetail qbe)
{
return(Select(qbe.CoaDetailID, qbe.AccFundID, qbe.AccFundCode, qbe.Acccode, qbe.AccName, qbe.AccDesc, qbe.AccTypeID, qbe.AccDestID, qbe.AccBalTypeID, qbe.AccCurrency, qbe.ConsTranCode, qbe.CoaControlID, qbe.CoaSubID, qbe.CoaMainID, qbe.TranCode, qbe.SubsYn, qbe.AccSubTypeID, qbe.OpenDate, qbe.OpenDebit, qbe.OpenCredit, qbe.AccCurrencyRate, qbe.Revenue, qbe.VariableCost, qbe.MonthlyExp, qbe.Budget, qbe.Annex, qbe.Dlt, qbe.IsCashNature, qbe.IsBankNature, qbe.AccSubTypeID1, qbe.AccSubTypeID2, qbe.BankName, qbe.BankAccNum, qbe.BranchName, qbe.BankAccType, qbe.AccTypeSetupID, qbe.AccNameBg, qbe.ColumnSerail, qbe.Slno));
}
