public bool UpdatePaymentType(PaymentTypeVM paymentTypeVM)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblPaymentType paymentType = unitOfWork.TblPaymentTypeRepository.GetByID(paymentTypeVM.PaymentTypeID);
paymentType.PaymentType = paymentTypeVM.PaymentTypeName;
paymentType.Description = paymentTypeVM.Description;
paymentType.ModifiedDate = DateTime.Now;
paymentType.ModifiedBy = paymentTypeVM.ModifiedBy;
unitOfWork.TblPaymentTypeRepository.Update(paymentType);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public bool DeletePaymentType(int paymentTypeID)
{
using (var dbTransaction = unitOfWork.dbContext.Database.BeginTransaction())
{
try
{
tblPaymentType paymentType = unitOfWork.TblPaymentTypeRepository.GetByID(paymentTypeID);
unitOfWork.TblPaymentTypeRepository.Delete(paymentType);
unitOfWork.Save();
//Complete the Transaction
dbTransaction.Commit();
return(true);
}
catch (Exception ex)
{
//Roll back the Transaction
dbTransaction.Rollback();
return(false);
}
}
}
public void InsertPaymentType()
{
try
{
using (KungFuEntities2 entities = new KungFuEntities2())
{
int ihdnPKID = int.Parse(hdnPKId.Value);
Int32 PaymentTypeID = 0;
if (ihdnPKID == 0)
{
PaymentTypeID = (from obj in entities.tblPaymentTypes
where obj.PAYMENT_TYPE == txtPaymentType.Text
select obj.PAYMENT_TYPE_ID).FirstOrDefault();
}
else
{
PaymentTypeID = (from obj in entities.tblPaymentTypes
where (obj.PAYMENT_TYPE == txtPaymentType.Text && obj.PAYMENT_TYPE_ID != ihdnPKID)
select obj.PAYMENT_TYPE_ID).FirstOrDefault();
}
if (PaymentTypeID == 0)
{
var objPaymentType = entities.tblPaymentTypes.Where(s => s.PAYMENT_TYPE_ID == ihdnPKID).OrderByDescending(s => s.PAYMENT_TYPE_ID).FirstOrDefault();
if (objPaymentType == null)
{
objPaymentType = new tblPaymentType();
}
objPaymentType.PAYMENT_TYPE = txtPaymentType.Text;
objPaymentType.PAYMENT_TYPE_CREATED_BY = entities.tblInstructors.AsEnumerable().FirstOrDefault().INSTRUCTOR_ID;
objPaymentType.PAYMENT_TYPE_CREATED_DATE = DateTime.Now;
objPaymentType.PAYMENT_TYPE_STATUS = chkIsApprove.Checked;
objPaymentType.PAYMENT_TYPE_AMOUNT = Convert.ToDecimal(txtAmount.Text);
if (objPaymentType.PAYMENT_TYPE_ID == 0)
{
entities.tblPaymentTypes.Add(objPaymentType);
}
else
{
objPaymentType.PAYMENT_TYPE_MODIFY_BY = entities.tblInstructors.Select(x => x.INSTRUCTOR_ID).FirstOrDefault();
objPaymentType.PAYMENT_TYPE_MODIFIED_DATE = DateTime.Now;
entities.Entry(objPaymentType).State = System.Data.Entity.EntityState.Modified;
}
entities.SaveChanges();
objPaymentType = null;
if (hdnPKId.Value != "0")
{
Response.Redirect("PaymentTypeList.aspx");
}
ResetControls();
divMessage.Visible = true;
divErrorMsg.Visible = false;
}
else
{
divErrorMsg.Visible = true;
divMessage.Visible = false;
return;
}
}
}
catch (Exception ex)
{
}
}