private static object[] Take(AutoBusinessParallelEntity autoBusinessParallelEntity)
{
return(new object[]
{
"@AutoBusinessParallelID", autoBusinessParallelEntity.AutoBusinessParallelId,
"@AutoBusinessCode", autoBusinessParallelEntity.AutoBusinessCode,
"@AutoBusinessName", autoBusinessParallelEntity.AutoBusinessName,
"@Description", autoBusinessParallelEntity.Description,
"@IsActive", autoBusinessParallelEntity.IsActive,
"@DebitAccount", autoBusinessParallelEntity.DebitAccount,
"@CreditAccount", autoBusinessParallelEntity.CreditAccount,
"@BudgetSourceID", autoBusinessParallelEntity.BudgetSourceId,
"@BudgetItemID", autoBusinessParallelEntity.BudgetItemId,
"@BudgetSubItemID", autoBusinessParallelEntity.BudgetSubItemId,
"@VoucherTypeID", autoBusinessParallelEntity.VoucherTypeId,
"@DebitAccountParallel", autoBusinessParallelEntity.DebitAccountParallel,
"@CreditAccountParallel", autoBusinessParallelEntity.CreditAccountParallel,
"@BudgetSourceIDParallel", autoBusinessParallelEntity.BudgetSourceIdParallel,
"@BudgetItemIDParallel", autoBusinessParallelEntity.BudgetItemIdParallel,
"@BudgetSubItemIDParallel", autoBusinessParallelEntity.BudgetSubItemIdParallel,
"@VoucherTypeIDParallel", autoBusinessParallelEntity.VoucherTypeIdParallel,
"@SortOrder", autoBusinessParallelEntity.SortOrder,
"@IsNegative", autoBusinessParallelEntity.IsNegative
});
}
public string DeleteAutoBusinessParallel(AutoBusinessParallelEntity autoBusinessParallel)
{
const string sql = @"uspDelete_AutoBusinessParallel";
object[] parms = { "@AutoBusinessParallelID", autoBusinessParallel.AutoBusinessParallelId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified autoBusinessParallel.
/// </summary>
/// <param name="autoBusinessParallelEntity">The automatic business parallel entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(AutoBusinessParallelEntity autoBusinessParallelEntity)
{
return(new object[]
{
"@AutoBusinessParallelID", autoBusinessParallelEntity.AutoBusinessParallelId,
"@AutoBusinessCode", autoBusinessParallelEntity.AutoBusinessCode,
"@AutoBusinessName", autoBusinessParallelEntity.AutoBusinessName,
"@Description", autoBusinessParallelEntity.Description,
"@IsActive", autoBusinessParallelEntity.IsActive,
"@DebitAccount", autoBusinessParallelEntity.DebitAccount,
"@CreditAccount", autoBusinessParallelEntity.CreditAccount,
"@BudgetSourceID", autoBusinessParallelEntity.BudgetSourceId,
"@BudgetChapterCode", autoBusinessParallelEntity.BudgetChapterCode,
"@BudgetKindItemCode", autoBusinessParallelEntity.BudgetKindItemCode,
"@BudgetSubKindItemCode", autoBusinessParallelEntity.BudgetSubKindItemCode,
"@BudgetItemCode", autoBusinessParallelEntity.BudgetItemCode,
"@BudgetSubItemCode", autoBusinessParallelEntity.BudgetSubItemCode,
"@MethodDistributeID", autoBusinessParallelEntity.MethodDistributeId,
"@CashWithDrawTypeID", autoBusinessParallelEntity.CashWithDrawTypeId,
"@DebitAccountParallel", autoBusinessParallelEntity.DebitAccountParallel,
"@CreditAccountParallel", autoBusinessParallelEntity.CreditAccountParallel,
"@BudgetSourceIDParallel", autoBusinessParallelEntity.BudgetSourceIdParallel,
"@BudgetChapterCodeParallel", autoBusinessParallelEntity.BudgetChapterCodeParallel,
"@BudgetKindItemCodeParallel", autoBusinessParallelEntity.BudgetKindItemCodeParallel,
"@BudgetSubKindItemCodeParallel", autoBusinessParallelEntity.BudgetSubKindItemCodeParallel,
"@BudgetItemCodeParallel", autoBusinessParallelEntity.BudgetItemCodeParallel,
"@BudgetSubItemCodeParallel", autoBusinessParallelEntity.BudgetSubItemCodeParallel,
"@MethodDistributeIDParallel", autoBusinessParallelEntity.MethodDistributeIdParallel,
"@CashWithDrawTypeIDParallel", autoBusinessParallelEntity.CashWithDrawTypeIdParallel,
"@SortOrder", autoBusinessParallelEntity.SortOrder,
});
}
public AutoBusinessParallelResponse InsertAutoBusinessParallelConvert(AutoBusinessParallelEntity autoBusinessEntity)
{
var response = new AutoBusinessParallelResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!autoBusinessEntity.Validate())
{
foreach (string error in autoBusinessEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.Message = AutoBusinessParallelDao.InsertAutoBusinessParallel(autoBusinessEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.AutoBusinessParallelId = autoBusinessEntity.AutoBusinessParallelId;
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
return(response);
}
}
public List <AutoBusinessParallelEntity> GetAutoBusinessPararellel(string connectionString)
{
List <AutoBusinessParallelEntity> listAutoBusinessPararell = new List <AutoBusinessParallelEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstAutoBusinessDetail = context.AutoBusinessDetails.ToList();
var lstAutoBusinessParallelDetail = context.AutoBusinessParalellDetails.ToList();
var lstAutoBusiness = context.AutoBusinesses.ToList().OrderBy(o => o.AutoBusinessID);
int i = 0;
foreach (var autoBusiness in lstAutoBusiness)
{
foreach (var autoBusinessDetail in autoBusiness.AutoBusinessDetails)
{
i = i + 1;
foreach (var autoBussinessParallel in autoBusiness.AutoBusinessParalellDetails)
{
var autoBusinessParallelDetail = new AutoBusinessParallelEntity();
autoBusinessParallelDetail.AutoBusinessParallelId = Guid.NewGuid().ToString();
autoBusinessParallelDetail.AutoBusinessCode = i.ToString();
autoBusinessParallelDetail.AutoBusinessName = autoBusiness.AutoBusinessName;
autoBusinessParallelDetail.Description = autoBussinessParallel.Description;
autoBusinessParallelDetail.IsActive = autoBusiness.Inactive == true ? false : true;
autoBusinessParallelDetail.DebitAccount = autoBusinessDetail.DebitAccount;
autoBusinessParallelDetail.CreditAccount = autoBusinessDetail.CreditAccount;
autoBusinessParallelDetail.BudgetSourceId = autoBusinessDetail.BudgetSourceID.ToString();
autoBusinessParallelDetail.BudgetChapterCode = autoBusinessDetail.BudgetChapterCode;
autoBusinessParallelDetail.BudgetKindItemCode = autoBusinessDetail.BudgetKindItemCode;
autoBusinessParallelDetail.BudgetSubKindItemCode = autoBusinessDetail.BudgetSubKindItemCode;
autoBusinessParallelDetail.BudgetItemCode = autoBusinessDetail.BudgetItemCode;
autoBusinessParallelDetail.BudgetSubItemCode = autoBusinessDetail.BudgetSubItemCode;
autoBusinessParallelDetail.MethodDistributeId = autoBusinessDetail.MethodDistributeID;
autoBusinessParallelDetail.CashWithDrawTypeId = autoBusinessDetail.CashWithDrawTypeID;
autoBusinessParallelDetail.DebitAccountParallel = autoBussinessParallel.DebitAccount;
autoBusinessParallelDetail.CreditAccountParallel = autoBussinessParallel.CreditAccount;
autoBusinessParallelDetail.BudgetSourceIdParallel = autoBussinessParallel.BudgetSourceID.ToString();
autoBusinessParallelDetail.BudgetChapterCodeParallel = autoBussinessParallel.BudgetChapterCode;
autoBusinessParallelDetail.BudgetKindItemCodeParallel = autoBussinessParallel.BudgetKindItemCode;
autoBusinessParallelDetail.BudgetSubKindItemCodeParallel = autoBussinessParallel.BudgetSubKindItemCode;
autoBusinessParallelDetail.BudgetItemCodeParallel = autoBussinessParallel.BudgetItemCode;
autoBusinessParallelDetail.BudgetSubItemCodeParallel = autoBussinessParallel.BudgetSubItemCode;
autoBusinessParallelDetail.MethodDistributeIdParallel = autoBussinessParallel.MethodDistributeID;
autoBusinessParallelDetail.CashWithDrawTypeIdParallel = autoBussinessParallel.CashWithDrawTypeID;
autoBusinessParallelDetail.SortOrder = autoBussinessParallel.SortOrder;
listAutoBusinessPararell.Add(autoBusinessParallelDetail);
}
}
}
}
return(listAutoBusinessPararell);
}
public AutoBusinessParallelResponse UpdateAutoBusinessParallel(AutoBusinessParallelEntity autoBusinessEntity)
{
var response = new AutoBusinessParallelResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!autoBusinessEntity.Validate())
{
foreach (string error in autoBusinessEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
var lstAutoBusinessParallels = AutoBusinessParallelDao.GetAutoBusinessParallels(autoBusinessEntity.AutoBusinessCode);
if (lstAutoBusinessParallels != null && lstAutoBusinessParallels.Where(w => w.AutoBusinessParallelId != autoBusinessEntity.AutoBusinessParallelId).Count() > 0)
{
response.Message = "Mã định khoản đồng thời '" + autoBusinessEntity.AutoBusinessCode + "' đã được sử dụng.";
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.Message = AutoBusinessParallelDao.UpdateAutoBusinessParallel(autoBusinessEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.AutoBusinessParallelId = autoBusinessEntity.AutoBusinessParallelId;
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
return(response);
}
}
public string UpdateAutoBusinessParallel(AutoBusinessParallelEntity autoBusinessParallel)
{
const string sql = @"uspUpdate_AutoBusinessParallel";
return(Db.Update(sql, true, Take(autoBusinessParallel)));
}
public int InsertAutoBusinessParallel(AutoBusinessParallelEntity autoBusinessParallel)
{
const string sql = @"uspInsert_AutoBusinessParallel";
return(Db.Insert(sql, true, Take(autoBusinessParallel)));
}
internal static AutoBusinessParallelModel FromDataTransferObject(AutoBusinessParallelEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <AutoBusinessParallelEntity, AutoBusinessParallelModel>(entity));
}
