//public FeeTerm SelectByIDs(int companyID)
//{
// SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
// return db.Branch.ToList().Where(s => s.CompanyCode == companyID).ToList();
//}
public void save(FeeTerm FeeTerm, string userId)
{
try
{
using (var context = new SmsMisDB())
{
var entry = context.Entry(FeeTerm);
if (entry != null)
{
FeeTerm.AddDateTime = DateTime.Now;
FeeTerm.AddByUserId = userId;
if (FeeTerm.FeeTermCode == 0)
{
FeeTerm.FeeTermCode = Functions.getNextPk("FeeTerm", FeeTerm.FeeTermCode, FeeTerm.CompanyCode);
entry.State = EntityState.Added;
}
else
{
entry.State = EntityState.Modified;
}
context.SaveChanges();
}
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
}
catch (Exception ex)
{
}
}
public bool Save(FeeTerm feeTerm, ref StringBuilder sbError)
{
var dbFlag = false;
if (feeTerm == null)
{
sbError.Append("fill in all fields");
return(false);
}
var term = _uofRepository.TermRepository.GetByID(feeTerm.TermID, ref dbFlag);
if (term == null)
{
sbError.Append("Term does not exist");
return(false);
}
if (term.Year >= (DateTime.Now.Year + 2))
{
sbError.Append("Enter a year less than :" + (DateTime.Now.Year + 2));
return(false);
}
if (term.Year <= (DateTime.Now.Year - 1))
{
sbError.Append("Enter a year greater than :" + (DateTime.Now.Year - 2));
return(false);
}
var feeType = _uofRepository.FeeTypeRepository.GetById(feeTerm.FeeTypeID, ref dbFlag);
if (feeType == null)
{
sbError.Append("Fee type does not exist");
return(false);
}
if (feeTerm.CurrencySymbol == null || feeTerm.CurrencySymbol?.Length >= 6)
{
sbError.Append("Fee term symbol should be less than 5 character");
return(false);
}
if (feeTerm.Amount <= 1)
{
sbError.Append("Fee amount should be greater than 1");
return(false);
}
if (feeTerm.Amount >= 10000000)
{
sbError.Append("Fee amount should be less than 10 000 000");
return(false);
}
var save = _uofRepository.FeeTermRepository.Save(feeTerm, _user.Username, ref dbFlag);
return(save);
}
public JsonResult deleteFeeTerm(FeeTerm FeeTerm)
{
try
{
new hdlFeeTerm().delete(FeeTerm);
}
catch (Exception ex)
{
Response.StatusCode = 500;
Content(JsonConvert.SerializeObject(new { error = ex.Message }));
}
return(getAllFeeTerm());
}
public JsonResult saveFeeTerm(FeeTerm FeeTerm)
{
try
{
new hdlFeeTerm().save(FeeTerm, Convert.ToString(Session["User"]));
}
catch (Exception ex)
{
Response.StatusCode = 500;
Content(JsonConvert.SerializeObject(new { error = ex.Message }));
}
return(getAllFeeTerm());
}
public bool Save(int year, int termNumber, string symbol, Guid feeTypeId, decimal fees, ref StringBuilder sbError)
{
bool dbFlag = false;
var term = _uofRepository.TermRepository.GetByTermNumberAndTermYearAndSchoolID(_user.SchoolID, termNumber, year, ref dbFlag);
if (term == null)
{
sbError.Append("Term does not exist");
return(false);
}
FeeTerm feeTerm = new FeeTerm();
feeTerm.TermID = (Guid)term.TermID;
feeTerm.CurrencySymbol = symbol;
feeTerm.Amount = fees;
feeTerm.FeeTypeID = feeTypeId;
return(Save(feeTerm, ref sbError));
}
public void delete(FeeTerm FeeTerm)
{
try
{
var context = new SmsMisDB();
context.FeeTerm.Attach(FeeTerm);
var entry = context.Entry(FeeTerm);
if (entry != null)
{
entry.State = EntityState.Deleted;
context.SaveChanges();
}
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
//throw SmsMis.Models.Console.Common.ExceptionTranslater.translate(ex);
throw ex;
}
catch (Exception ex)
{
//throw SmsMis.Models.Console.Common.ExceptionTranslater.translate(ex);
throw ex;
}
}
public bool Save(FeeTerm feeTerm, string modifiedBy, ref bool dbError)
{
try
{
using (var connection = GetConnection())
{
if (feeTerm.FeeTermID == null || Guid.Empty == feeTerm.FeeTermID)
{
var update = @"
INSERT INTO FeeTerm
(FeeTermID
,TermID
,FeeTypeID
,CurrencySymbol
,Amount , lastmodifiedBy)
VALUES
(@id
,@TermID
,@FeeTypeID
,@CurrencySymbol
,@Amount ,@modifiedBy)
";
var id = connection.Execute(update,
new
{
id = Guid.NewGuid(),
TermID = feeTerm.TermID,
FeeTypeID = feeTerm.FeeTypeID,
CurrencySymbol = feeTerm.CurrencySymbol,
Amount = feeTerm.Amount,
modifiedBy = modifiedBy
});
return(true);
}
else
{
var update = @"
UPDATE FeeTerm
SET TermID = @TermID
,FeeTypeID = @FeeTypeID
,CurrencySymbol = @CurrencySymbol
,Amount = @Amount
,LastmodifiedBy = @modifiedBy
WHERE FeeTermID = @FeeTermID AND ISDeleted IS NULL
";
var id = connection.Execute(update,
new
{
FeeTermID = feeTerm.FeeTermID,
TermID = feeTerm.TermID,
FeeTypeID = feeTerm.FeeTypeID,
CurrencySymbol = feeTerm.CurrencySymbol,
Amount = feeTerm.Amount,
modifiedBy = modifiedBy
});
return(true);
}
}
}
catch (Exception er)
{
dbError = true;
DbLog.Error(er);
return(false);
}
}
