public IList <BranchBuilding> SelectAll(string strValues)
{
string[] strArray = strValues.ToString().Split('/');
int CompanyCode = Convert.ToInt32(strArray[0]);
int BranchCode = Convert.ToInt32(strArray[1]);
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.BranchBuilding.Where(s => s.CompanyCode == CompanyCode && s.BranchCode == BranchCode).ToList());
}
public JsonResult generateVoucherNumber(int companyCode, int branchCode, int voucherCode, DateTime voucherDate)
{
using (SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB())
{
var voucherTypes = db.Database.SqlQuery <VoucherTypeVM>("select CAST( RANK() over (order by AccountCode,VoucherCode ) AS int) as VoucherTypeRowNumber, VoucherCode,VoucherName,AccountCode,AccountTitle,TransactionType, Category,Frequency,CompanyCode,BranchCode from LOV_VoucherType")
.Where(x => x.CompanyCode == companyCode && x.BranchCode == branchCode).ToList();
var voucherType = voucherTypes.Where(x => x.VoucherCode == voucherCode).FirstOrDefault();
var assignAccountCodeDisable = voucherType.TransactionType;
int voucherNumber = new hdlVoucherMaster().getVoucherNumber(companyCode, branchCode, voucherCode, voucherDate);
Dictionary <int, string> voucherTypeAccount = new Dictionary <int, string>();
voucherTypeAccount.Add(1, "Bank");
voucherTypeAccount.Add(2, "Cash");
return(Json(new
{
VoucherNumber = voucherNumber,
AccountCode = voucherType.TransactionType.Contains(voucherTypeAccount.Values.ToString()) ? voucherType.AccountCode:null,
AccountTitle = voucherType.TransactionType.Contains(voucherTypeAccount.Values.ToString()) ? voucherType.AccountTitle : null
}, JsonRequestBehavior.AllowGet));
}
}
public JsonResult ValidateInstrumentNumber(int companyCode, int branchCode, int instrumentRowNumber, int voucherTypeRowNumber, int instrumentNumber)
{
using (
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB())
{
var voucherTypes =
db.Database.SqlQuery <VoucherTypeVM>(
"select CAST( RANK() over (order by AccountCode,VoucherCode ) AS int) as VoucherTypeRowNumber, VoucherCode,VoucherName,AccountCode,AccountTitle,TransactionType, Category,Frequency,CompanyCode,BranchCode from LOV_VoucherType")
.Where(x => x.CompanyCode == companyCode && x.BranchCode == branchCode).ToList();
var voucherType =
voucherTypes.Where(x => x.VoucherTypeRowNumber == voucherTypeRowNumber).FirstOrDefault();
var accountCode = "";
if (voucherType != null)
{
accountCode = voucherType.AccountCode;
}
var InstrumentTypes =
db.Database.SqlQuery <InstrumentTypeVM>(
"select CAST(RANK() over (order by AccountCode) AS int) as InstrumentTypeRowNumber, AccountCode,InstrumentTypeCode,InstrumentName,CompanyCode,BranchCode from lov_instrument")
.Where(x => x.CompanyCode == companyCode && x.BranchCode == branchCode).ToList();
var InstrumentType =
InstrumentTypes.Where(x => x.InstrumentTypeRowNumber == instrumentRowNumber).FirstOrDefault();
var instrumentCode = 0;
if (InstrumentType != null)
{
instrumentCode = InstrumentType.InstrumentTypeCode;
}
if (accountCode != "" || instrumentCode != 0)
{
bool ValidNotValid = new hdlVoucherMaster().ValidateInstrumntNumber(companyCode, branchCode,
accountCode, instrumentCode, instrumentNumber);
return(Json(ValidNotValid, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
//public IList<Branch> SelectAll()
//{
// SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
// return db.Branch.ToList();
//}
//public IList<Branch> SelectActiveBranches()
//{
// SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
// return db.Branch.Where(s=>s.Status == true).ToList();
//}
public IList <Branch> SelectAll(int companycode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Branch.Where(s => s.CompanyCode == companycode).ToList());
}
public IList<Nationality> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return db.Nationality.ToList();
}
public IList <Department> SelectAll(int companycode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Department.Where(a => a.CompanyCode == companycode).ToList());
}
public IList <SeatType> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.SeatType.ToList());
}
public IList <Party> SelectAll(int companycode, int branchCode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Party.Where(s => s.CompanyCode == companycode && s.BranchCode == branchCode).ToList());
}
public IList <Class> SelectAllActive(int CompanyCode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Classes.Where(s => s.Status == true && s.CompanyCode == CompanyCode).ToList());
}
public IList <FeeParticularRecurringType> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.FeeParticularRecurringType.ToList());
}
public IList <FeeParticular> SelectAll(int CompanyCode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.FeeParticular.Where(s => s.CompanyCode == CompanyCode).ToList());
}
public IList <FeeParticular> SelectAllActive(int CompanyCode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.FeeParticular.Where(s => s.Status == true && s.Optional == true && s.CompanyCode == CompanyCode).ToList());
}
public IList <FeeParticular> SelectAllActive()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.FeeParticular.Where(s => s.Status == true).ToList());
}
public IList <COALevels> SelectCOALevels(int CompanyCode)
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.COALevels.ToList().Where(s => s.CompanyCode == CompanyCode).ToList());
}
public IList <MarketingReference> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.MarketingReference.ToList());
}
public IList <Religion> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Religion.ToList());
}
public IList <Class> SelectAll()
{
SmsMis.Models.Console.Handlers.Admin.SmsMisDB db = new SmsMis.Models.Console.Handlers.Admin.SmsMisDB();
return(db.Classes.ToList());
}
