public void TestMethod1()
{
//Arrange
var domainsList = new List <IDomain> {
//new RangeDomain { LowBound = 1, HighBound = 3},
new RangeDomain {
LowBound = 4, HighBound = 6
}
};
var x = new Variable {
Domains = domainsList
};
var rule = new SmallerThan {
Operand1 = new Constant(5), Operand2 = x
};
var context = new CPContext();
context.Add(x);
context.Add(rule);
//Act
var xAssignments = context.Evaluate();
//Assert
Assert.AreEqual(6, x.Values()[0]);
}
private void button5_Click(object sender, EventArgs e)
{
using (var context = new CPContext())
{
SqlParameter id = new SqlParameter("@Id", 3);
var res = context.Database.SqlQuery <int>("p_GetStudentAge @Id", id).SingleOrDefault();
MessageBox.Show("Result: " + res);
}
}
public void GetIdNames()
{
//DataTable Dats = new DataTable();
using (var context = new CPContext())
{
context.Nomenclaturas.Load();
var fff = context.Nomenclaturas.Local;
}
}
public List <ConfigerationPanel> Get_()
{
CPContext context;
using (context = new CPContext())
{
context.ConfigerationPanels.Load();
}
return(context.ConfigerationPanels.Local.ToList());
}
private void button2_Click(object sender, EventArgs e)
{
try
{
CPContext context = new CPContext();
int scount = context.Schools.Count();
int stdcount = context.Students.Count();
MessageBox.Show($"Schools: {scount}, Students {stdcount}");
}
catch (Exception ex)
{
MessageBox.Show("Can not open connection ! " + ex.Message);
}
}
private void button4_Click(object sender, EventArgs e)
{
var school = new School
{
Id = 5,
Name = "Hitachi School"
};
using (var context = new CPContext())
{
context.Schools.Add(school);
context.SaveChanges();
}
MessageBox.Show("New School created.");
}
private void button3_Click(object sender, EventArgs e)
{
Student student = new Student
{
SchoolId = 5,
Name = "Test student",
DOB = DateTime.Now,
Address = "Bangalore"
};
using (var context = new CPContext())
{
context.Students.Add(student);
context.SaveChanges();
}
MessageBox.Show("New student created.");
}
private void button6_Click(object sender, EventArgs e)
{
using (var context = new CPContext())
{
var res = context.Database.SqlQuery <Student>("p_GetStudent").ToList();
var res2 = res.Where(x => x.Id > 2);
var students = from s in res
where s.SchoolId == 2
select new SudentDTO
{
Id = s.Id,
Name = s.Name,
Address = s.Address,
DOB = s.DOB
};
DataBind(students.ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
using (CPContext db = new CPContext())
{
var query = (from p in db.CPT_SkillsMaster
where p.IsActive == true
select new
{
SkillID = p.SkillsMasterID,
SkillName = p.SkillsName
}
).ToList();
rptSkillSelect.DataSource = query;
rptSkillSelect.DataBind();
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, CPContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
}
public EventRepo(CPContext context)
{
_context = context;
}
public EFUnitOfWork(CPContext dbContext)
{
_dbContext = dbContext;
}
public RepositoryBase(CPContext dbContext)
{
Context = dbContext;
DbSet = Context.Set <TEntity>();
}
protected void btnAllocate_Resource_Click(object sender, EventArgs e)
{
try
{
CPT_ResourceDemand resourceDemandDetails = new CPT_ResourceDemand();
List <CPT_ResourceMaster> lstdetils = new List <CPT_ResourceMaster>();
lstdetils = (List <CPT_ResourceMaster>)Session["UserDetails"];
myDIV.Style.Add("display", "block");
Button theButton = sender as Button;
requestDetailID = Convert.ToInt32(theButton.CommandArgument);
using (CPContext db = new CPContext())
{
var query = (from p in db.CPT_ResourceDetails
where p.RequestDetailID == requestDetailID
select p).ToList();
roleID = query[0].ResourceTypeID;
StartDate = query[0].StartDate.ToShortDateString();
EndDate = query[0].EndDate.ToShortDateString();
skillID = query[0].SkillID.Split(',').ToList();
if (skillID.Count == 1)
{
skillID.Clear();
skillID.Add(query[0].SkillID);
skillID.Add(query[0].SkillID);
skillID.Add(query[0].SkillID);
}
}
RepeaterItem item = (sender as Button).NamingContainer as RepeaterItem;
Label lblNoOfResources = (Label)item.FindControl("lblNoOfResources");
float utilization = 0;
if (float.Parse(lblNoOfResources.Text) < 1)
{
utilization = float.Parse(lblNoOfResources.Text);
}
else
{
utilization = 1;
}
ViewState["utilization"] = utilization;
lblStartDate.Text = StartDate;
lblEndDate.Text = EndDate;
if (lstdetils[0].RolesID == 20 || lstdetils[0].RolesID == 25)
{
//AccordingToRoleSearch();
SearchAvailability();
}
else
{
SearchAvailability();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public StudentRepository(CPContext dbContext)
: base(dbContext)
{
}
private KeystoneAuthUserMsg GetAuthUser(string userName, string domain)
{
KeystoneAuthUserMsg authUser = new KeystoneAuthUserMsg();
authUser.CompanyCode = CPConfig.Application.BusinessCode;
authUser.Domain = domain;
authUser.UserName = userName;
authUser.CompanyName = "NeweggSoft";
UserInfo user = CPContext.GetUserInfoFromAD(userName, domain);
if (!string.IsNullOrWhiteSpace(user.FullName))
{
authUser.DisplayName = user.FullName;
authUser.EmailAddress = user.EmailAddress;
authUser.DepartmentName = user.Department;
authUser.DepartmentNumber = user.Department;
}
else
{
authUser.DisplayName = userName;
}
if (CPConfig.ECCentral != null)
{
string serviceUrl = CPConfig.ECCentral.ServiceURL;
if (!string.IsNullOrEmpty(serviceUrl))
{
serviceUrl = serviceUrl.TrimEnd('/');
string url = serviceUrl + "/CommonService/User/{0}";
url = string.Format(url, userName);
WebClient web = new WebClient();
web.Encoding = Encoding.UTF8;
string resultString = web.DownloadString(new Uri(url));
int userSysNo = -1;
int.TryParse(resultString, out userSysNo);
if (userSysNo != -1)
{
authUser.UserSysNo = int.Parse(resultString);
}
else
{
throw new Exception("Don't found this user system number by current account!");
}
}
else
{
authUser.UserSysNo = -1;
}
}
else
{
authUser.UserSysNo = -1;
}
return(authUser);
}
public List <ConfigerationPanel> GetLists()
{
var context = new CPContext();
return(context.ConfigerationPanels.Local.ToList());
}
public LocationRepo(CPContext context)
{
_context = context;
}
public CourseTypeRepository(CPContext dbContext)
: base(dbContext)
{
}
public CustomerRepo(CPContext context)
{
_context = context;
}
