/// <summary>
/// Deletes the purchasePurpose.
/// </summary>
/// <param name="purchasePurpose">The purchasePurpose.</param>
/// <returns>System.String.</returns>
public string DeletePurchasePurpose(PurchasePurposeEntity purchasePurpose)
{
const string sql = @"uspDelete_PurchasePurpose";
object[] parms = { "@PurchasePurposeID", purchasePurpose.PurchasePurposeId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified purchasePurpose.
/// </summary>
/// <param name="purchasePurpose">The purchasePurpose.</param>
/// <returns></returns>
private object[] Take(PurchasePurposeEntity purchasePurpose)
{
return(new object[]
{
"@PurchasePurposeID", purchasePurpose.PurchasePurposeId,
"@PurchasePurposeCode", purchasePurpose.PurchasePurposeCode,
"@PurchasePurposeName", purchasePurpose.PurchasePurposeName,
"@Description", purchasePurpose.Description,
"@IsSystem", purchasePurpose.IsSystem,
"@IsActive", purchasePurpose.IsActive
});
}
/// <summary>
/// Inserts the purchase purpose.
/// </summary>
/// <param name="purchasePurposeEntity">The purchase purpose entity.</param>
/// <returns></returns>
public PurchasePurposeResponse InsertPurchasePurpose(PurchasePurposeEntity purchasePurposeEntity)
{
var response = new PurchasePurposeResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!purchasePurposeEntity.Validate())
{
foreach (var error in purchasePurposeEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
using (var scope = new TransactionScope())
{
purchasePurposeEntity.PurchasePurposeId = Guid.NewGuid().ToString();
response.Message = PurchasePurposeDao.InsertPurchasePurpose(purchasePurposeEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
scope.Complete();
}
response.PurchasePurposeId = purchasePurposeEntity.PurchasePurposeId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
public List <PurchasePurposeEntity> GetPurchasePurpose(string connectionString)
{
List <PurchasePurposeEntity> listPurchasePurpose = new List <PurchasePurposeEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.PurchasePurposes.ToList();
foreach (var result in categories)
{
var purchasePurpose = new PurchasePurposeEntity();
purchasePurpose.PurchasePurposeId = result.PurchasePurposeID.ToString();
purchasePurpose.PurchasePurposeCode = result.PurchasePurposeCode;
purchasePurpose.PurchasePurposeName = result.PurchasePurposeName;
purchasePurpose.Description = result.Description;
purchasePurpose.IsSystem = result.IsSystem;
purchasePurpose.IsActive = result.Inactive == true?false:true;
listPurchasePurpose.Add(purchasePurpose);
}
}
return(listPurchasePurpose);
}
/// <summary>
/// Updates the purchasePurpose.
/// </summary>
/// <param name="purchasePurpose">The purchasePurpose.</param>
/// <returns></returns>
public string UpdatePurchasePurpose(PurchasePurposeEntity purchasePurpose)
{
const string sql = @"uspUpdate_PurchasePurpose";
return(Db.Update(sql, true, Take(purchasePurpose)));
}
/// <summary>
/// Inserts the purchasePurpose.
/// </summary>
/// <param name="purchasePurpose">The purchasePurpose.</param>
/// <returns></returns>
public string InsertPurchasePurpose(PurchasePurposeEntity purchasePurpose)
{
const string sql = @"uspInsert_PurchasePurpose";
return(Db.Insert(sql, true, Take(purchasePurpose)));
}
