public IQueryable <Country> GetCountries(int pageNumber, int?countryId, string description)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <Country> query = db.Countries;
query = query.Where(p => (description == null | (p.Description.StartsWith(description))) & (countryId == null | (p.CountryID == countryId)))
.OrderBy(p => p.CountryID).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public IQueryable <ProductionUnit> GetProductionUnits(int pageNumber, int?ProductionUnitId, int?AreaId, int?CompanyId, int?SectorId)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <ProductionUnit> query = db.ProductionUnits;
query = query.Where(p => (AreaId == 0 | (p.AreaID == AreaId)) & (CompanyId == 0 | (p.CompanyID == CompanyId)) & (SectorId == 0 | (p.SectorID == SectorId)) & (ProductionUnitId == null | (p.ProductionUnitID == ProductionUnitId)))
.OrderBy(p => p.ProductionUnitID).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public static IQueryable <User> GetUsers(int pageNumber, string userName, string firstName, bool?isLocked)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <User> query = db.Users;
query = query.Where(p => (isLocked == null | p.IsLockedOut == isLocked) & (userName == null | (p.Username == userName)) & (firstName == null | (p.FirstName == firstName)))
.OrderBy(p => p.Username).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public IQueryable <Role> GetRoles(int pageNumber, string roleName)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <Role> query = db.Roles;
query = query.Where(p => (roleName == null | (p.RoleName == roleName)))
.OrderBy(p => p.RoleId).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public IQueryable <Sector> GetSectors(int?SectorId, string SmallDescription, string description)
{
//int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <Sector> query = db.Sectors;
query = query.Where(p => (SmallDescription == null | (p.SmallDescription == SmallDescription)) & (description == null | (p.Description == description)) & (SectorId == null | (p.SectorID == SectorId)))
.OrderBy(p => p.SectorID);
return(query);
}
public IQueryable <Company> GetCompanies(int?CompanyId, string CompanyName, string description)
{
//int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <Company> query = db.Companies;
query = query.Where(p => (CompanyName == null | (p.CompanyName == CompanyName)) & (description == null | (p.Description == description)) & (CompanyId == null | (p.CompanyID == CompanyId)))
.OrderBy(p => p.CompanyID);
return(query);
}
public IQueryable <Area> GetAreas(int pageNumber, int?AreaId, string SmallDescription, string description)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <Area> query = db.Areas;
query = query.Where(p => (SmallDescription == null | (p.SmallDescription.StartsWith(SmallDescription))) & (description == null | (p.Description == description)) & (AreaId == null | (p.AreaID == AreaId)))
.OrderBy(p => p.AreaID).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public static IQueryable <FinancialForm> GetForms(int pageNumber, int?companyId, int?productionUnitId)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <FinancialForm> query = db.FinancialForms;
query = query.Where(p => (companyId == 0 | (p.ProductionUnit.CompanyID == companyId)) & (productionUnitId == 0 | (p.ProductionUnitID == productionUnitId)))
.OrderBy(p => p.FormID).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
public static void Insert(Guid userId, int productionUnitID)
{
using (var db = new Models.SmizeeContext())
{
UserProductionUnit entity = new UserProductionUnit();
entity.UserID = userId;
entity.ProductionUnitID = productionUnitID;
db.UserProductionUnits.Add(entity);
db.SaveChanges();
}
}
public static IQueryable <OperationalForm> GetForms(int pageNumber, int?year, int?periodicity, int?functionalAreaId)
{
int numberOfObjectsPerPage = 10;
var db = new Models.SmizeeContext();
IQueryable <OperationalForm> query = db.OperationalForms;
query = query.Where(p => (functionalAreaId == 0 | p.Form.FormType.FunctionalAreaID == functionalAreaId) &
((year == null | p.FormDate.Year == year) | (periodicity == 0 | (p.Form.PeriodicityID == periodicity))))
.OrderBy(p => p.FormID).Skip(numberOfObjectsPerPage * (pageNumber - 1)).Take(numberOfObjectsPerPage + 1);
return(query);
}
private void BindFormTypes()
{
var db = new Models.SmizeeContext();
IQueryable <FormType> formTypes = db.FormTypes;
List <FormType> listEntities = formTypes.ToList();
ddlFormType.DataSource = listEntities;
ddlFormType.DataTextField = "Description";
ddlFormType.DataValueField = "FormTypeID";
ddlFormType.DataBind();
ddlFormType.Items.Insert(0, new ListItem(Resources.Resource.lSelectOne, "0"));
}
public void BindServcies()
{
var db = new Models.SmizeeContext();
IQueryable <Service> services = db.Services;
List <Service> listEntities = services.ToList();
ApplicationPageSearchInput.DataSource = listEntities;
ApplicationPageSearchInput.DataTextField = "Description";
ApplicationPageSearchInput.DataValueField = "ApplicationPage";
ApplicationPageSearchInput.DataBind();
ApplicationPageSearchInput.Items.Insert(0, new ListItem(Resources.Resource.lSelectOne, "0"));
}
private void CreateRecord(int formId, int productionUnitId)
{
decimal?salesNetAmount = GetDecimalValueFromInput(SalesNetAmountInput.Text, true);
decimal?serviceDeliveryNetAmount = GetDecimalValueFromInput(ServiceDeliveryNetAmountInput.Text, true);
decimal?costTotalAmount = GetDecimalValueFromInput(CostTotalAmountInput.Text, true);
decimal?operacionalCostAmount = GetDecimalValueFromInput(OperacionalCostAmountInput.Text, true);
decimal?productSalesNetAmountBudgeted = GetDecimalValueFromInput(ProductSalesNetAmountBudgetedInput.Text, true);
decimal?serviceSalesNetAmountBudgeted = GetDecimalValueFromInput(ServiceSalesNetAmountBudgetedInput.Text, true);
decimal?businessAmount = GetDecimalValueFromInput(BusinessAmountInput.Text, true);
decimal?trainingAmount = GetDecimalValueFromInput(TrainingAmountInput.Text, true);
decimal?salaryAmount = GetDecimalValueFromInput(SalaryAmountInput.Text, true);
decimal?socialExpensesAmount = GetDecimalValueFromInput(SocialExpensesAmountInput.Text, true);
decimal?otherPersonelCostsAmount = GetDecimalValueFromInput(OtherPersonelCostsAmountInput.Text, true);
decimal?directLabourCostsAmount = GetDecimalValueFromInput(DirectLabourCostsAmountInput.Text, true);
decimal?investmentValue = GetDecimalValueFromInput(InvestmentValueInput.Text, true);
decimal?technologyInvestmentValue = GetDecimalValueFromInput(TechnologyInvestmentValueInput.Text, true);
int productionAutomatedControlSystem = ddlProductionAutomatedControlSystem.SelectedValue == "1" ? 1 : 0;
using (var db = new Models.SmizeeContext())
{
FinancialForm entity = new FinancialForm();
entity.StateID = 1;
entity.FormID = formId;
entity.SalesNetAmount = salesNetAmount;
entity.ServiceDeliveryNetAmount = serviceDeliveryNetAmount;
entity.CostTotalAmount = costTotalAmount;
entity.OperacionalCostAmount = operacionalCostAmount;
entity.ProductSalesNetAmountBudgeted = productSalesNetAmountBudgeted;
entity.ServiceSalesNetAmountBudgeted = serviceSalesNetAmountBudgeted;
entity.BusinessAmount = businessAmount;
entity.TrainingAmount = trainingAmount;
entity.SalaryAmount = salaryAmount;
entity.SocialExpensesAmount = socialExpensesAmount;
entity.OtherPersonelCostsAmount = otherPersonelCostsAmount;
entity.DirectLabourCostsAmount = directLabourCostsAmount;
entity.InvestmentValue = investmentValue;
entity.TechnologyInvestmentValue = technologyInvestmentValue;
entity.ProductionAutomatedControlSystem = productionAutomatedControlSystem;
entity.SubmitDate = DateTime.Now;
//entity.ApprovalDate = DateTime.Parse("01/01/2000 00:00:00");
entity.SubmitUserName = User.Identity.Name;
db.FinancialForms.Add(entity);
db.SaveChanges();
}
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mCreateOK);
}
private void ShowCurrentForm(int formId)
{
using (var db = new Models.SmizeeContext())
{
var entity = (from c in db.FinancialForms where c.FinancialFormID == formId select c).First();
if (entity != null)
{
ProductSalesNetAmountBudgetedInput.Text = GetStringValue(entity.ProductSalesNetAmountBudgeted);
ServiceSalesNetAmountBudgetedInput.Text = GetStringValue(entity.ServiceSalesNetAmountBudgeted);
CostTotalAmountInput.Text = GetStringValue(entity.CostTotalAmount);
DirectLabourCostsAmountInput.Text = GetStringValue(entity.DirectLabourCostsAmount);
BusinessAmountInput.Text = GetStringValue(entity.BusinessAmount);
OperacionalCostAmountInput.Text = GetStringValue(entity.OperacionalCostAmount);
OtherPersonelCostsAmountInput.Text = GetStringValue(entity.OtherPersonelCostsAmount);
SalaryAmountInput.Text = GetStringValue(entity.SalaryAmount);
SalesNetAmountInput.Text = GetStringValue(entity.SalesNetAmount);
ServiceDeliveryNetAmountInput.Text = GetStringValue(entity.ServiceDeliveryNetAmount);
SocialExpensesAmountInput.Text = GetStringValue(entity.SocialExpensesAmount);
TrainingAmountInput.Text = GetStringValue(entity.TrainingAmount);
ProductSalesNetAmountBudgetedInput.Text = GetStringValue(entity.ProductSalesNetAmountBudgeted);
ServiceSalesNetAmountBudgetedInput.Text = GetStringValue(entity.ServiceSalesNetAmountBudgeted);
InvestmentValueInput.Text = GetStringValue(entity.InvestmentValue);
TechnologyInvestmentValueInput.Text = GetStringValue(entity.TechnologyInvestmentValue);
int?x = entity.ProductionAutomatedControlSystem;
if (x == null)
{
ddlProductionAutomatedControlSystem.SelectedIndex = 0;
}
else
{
ddlProductionAutomatedControlSystem.SelectedIndex = (int)x;
}
}
}
switch (currentOption)
{
case "QRY": ConfirmButtonPanel.Visible = false;
DetailPanel.Enabled = false;
BackPanel.Visible = true;
break;
case "DEL": DetailPanel.Enabled = false;
break;
case "UPD": break;
case "CRE": break;
}
}
private void BindRoles()
{
var db = new Models.SmizeeContext();
IQueryable <Role> query = db.Roles;
List <Role> listEntities = query.ToList();
ddlMembershipRole.DataSource = listEntities;
ddlMembershipRole.DataTextField = "RoleName";
ddlMembershipRole.DataValueField = "RoleId";
ddlMembershipRole.DataBind();
ddlMembershipRole.Items.Insert(0, new ListItem(Resources.Resource.lSelectOne, "0"));
}
public static void Delete(int financialExportFormID)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
//db.Database.ExecuteSqlCommand("delete from FinancialExportForms where FinancialExportFormId={0}", code);
IQueryable <FinancialExportFormCountry> myItem = from c in db.FinancialExportFormCountries where c.FinancialExportFormID == financialExportFormID select c;
foreach (FinancialExportFormCountry ec in myItem)
{
db.FinancialExportFormCountries.Remove(ec);
}
db.SaveChanges();
}
}
private void CreateRecord(string userName, string password, string email, string firstName, string lastName, int?companyID, int?functionalAreaID, Boolean?isManager, Boolean?isExecutive, Boolean?isLockedOut)
{
MembershipCreateStatus status = WebSecurity.Register(userName, password, email, true, firstName, lastName, companyID == 0 ? null : companyID, functionalAreaID == 0 ? null : functionalAreaID, isManager, isExecutive);
if (status == MembershipCreateStatus.Success)
{
WebSecurity.LockUser(userName, (bool)isLockedOut);
if (ddlMembershipRole.SelectedValue.Equals("0"))
{
System.Web.Security.Roles.AddUserToRole(userName, "User");
}
else
{
System.Web.Security.Roles.AddUserToRole(userName, ddlMembershipRole.SelectedItem.Text);
}
GridView gv = ProductionUnitGrid.GetGridView();
CheckBox selected = null;
HiddenField pid = null;
UserProductionUnit upu = null;
Guid userId = WebSecurity.GetUserId(userName);
using (var db = new Models.SmizeeContext())
{
foreach (GridViewRow currentRow in gv.Rows)
{
selected = currentRow.FindControl("SelectRowCheckBox") as CheckBox;
if (selected.Checked)
{
pid = currentRow.FindControl("ProductionUnitIDHidden") as HiddenField;
upu = new UserProductionUnit();
upu.UserID = userId;
upu.ProductionUnitID = int.Parse(pid.Value);
db.UserProductionUnits.Add(upu);
}
}
db.SaveChanges();
}
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mUserCreateOK);
}
else
{
ShowError(ErrorPanel, status.ToString());
}
}
public static void DeleteRecord(int code)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
db.Database.ExecuteSqlCommand("delete from States where StateId={0}", code);
//var myItem = (from c in db.Companies where c.CompanyID == code select c).First();
//if (myItem != null)
//{
// db.Companies.Remove(myItem);
// db.SaveChanges();
//}
}
}
public static void UpdateRecord(int periodicityId, string description, string code)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
var myItem = (from c in db.Periodicities where c.PeriodicityID == periodicityId select c).First();
if (myItem != null)
{
myItem.Description = description;
myItem.Code = code;
db.SaveChanges();
}
}
}
public static void DeleteRecord(int code)
{
//Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
//db.Database.ExecuteSqlCommand("delete from OperationalForms where OperationalFormId={0}", code);
var entity = (from c in db.OperationalForms where c.OperationalFormID == code select c).First();
if (entity != null)
{
db.OperationalForms.Remove(entity);
db.SaveChanges();
}
}
}
public static void UpdateRecord(int code, string SmallDescription, string description)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
var myItem = (from c in db.States where c.StateID == code select c).First();
if (myItem != null)
{
myItem.SmallDescription = SmallDescription;
myItem.Description = description;
db.SaveChanges();
}
}
}
public static void Delete(int operationalLicensesFormID)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
//db.Database.ExecuteSqlCommand("delete from FinancialExportForms where FinancialExportFormId={0}", code);
IQueryable <OperationalLicensesFormPhase> myItem = from c in db.OperationalLicensesFormPhases where c.OperationalLicensesFormID == operationalLicensesFormID select c;
foreach (OperationalLicensesFormPhase ec in myItem)
{
db.OperationalLicensesFormPhases.Remove(ec);
}
db.SaveChanges();
}
}
public static void CreateRecord(int formId, string userName)
{
using (var db = new Models.SmizeeContext())
{
OperationalLicensesForm entity = new OperationalLicensesForm();
entity.StateID = 1;
entity.FormID = formId;
entity.SubmitDate = DateTime.Now;
entity.SubmitUserName = userName;
db.OperationalLicensesForms.Add(entity);
db.SaveChanges();
}
}
public static void UpdateRecord(int code, string companyName, string description)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
var entity = (from c in db.Companies where c.CompanyID == code select c).First();
if (entity != null)
{
entity.CompanyName = companyName;
entity.Description = description;
db.SaveChanges();
}
}
}
public static void Delete(Guid userId)
{
//Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
//db.Database.ExecuteSqlCommand("delete from UserProductionUnits where UserId={0}", userId);
IQueryable <UserProductionUnit> myItem = from c in db.UserProductionUnits where c.UserID == userId select c;
foreach (UserProductionUnit ec in myItem)
{
db.UserProductionUnits.Remove(ec);
}
db.SaveChanges();
}
}
public static void UpdateRecord(int countryId, string smallDescription, string description, string isoCode)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
var myItem = (from c in db.Countries where c.CountryID == countryId select c).First();
if (myItem != null)
{
myItem.Description = description;
myItem.SmallDescription = smallDescription;
myItem.ISOCode = isoCode;
db.SaveChanges();
}
}
}
public static void CreateFormPhaseRecord(int operationalLicensesFormID, string userName, int formState, int devPhase, int PUN)
{
OperationalLicensesFormPhase olfp;
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
olfp = new OperationalLicensesFormPhase();
olfp.DevelopmentPhaseID = devPhase;
olfp.ProductionUnitsNumber = PUN;
olfp.OperationalLicensesFormID = operationalLicensesFormID;
db.OperationalLicensesFormPhases.Add(olfp);
db.SaveChanges();
}
}
public static void UpdateRecord(int code, string SmallDescription, string description, int?hectares)
{
// Query the database for the rows to be deleted.
using (var db = new Models.SmizeeContext())
{
var entity = (from c in db.Areas where c.AreaID == code select c).First();
if (entity != null)
{
entity.SmallDescription = SmallDescription;
entity.Description = description;
entity.Hectares = hectares;
db.SaveChanges();
}
}
}
private void CreateRecord(string description)
{
using (var db = new Models.SmizeeContext())
{
Company entity = new Company();
entity.CompanyName = description;
entity.Description = description;
db.Companies.Add(entity);
db.SaveChanges();
}
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mCreateOK);
}
private void CreateRecord(string SmallDescription, string description)
{
using (var db = new Models.SmizeeContext())
{
FunctionalArea entity = new FunctionalArea();
entity.SmallDescription = SmallDescription;
entity.Description = description;
db.FunctionalAreas.Add(entity);
db.SaveChanges();
}
BackPanel.Visible = true;
ConfirmButtonPanel.Visible = false;
DetailPanel.Visible = false;
ShowInfo(MessagePanel, Resources.Resource.mRecordCreateOK);
}
