/// <summary>
/// 编辑按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gv1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
sqlconn = SQLHelper.Connect();
/*try
* {*/
//暂时禁用外键关系
SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Department NOCHECK constraint all", sqlconn);
SqlCommand sqlCmd2NoCheck = new SqlCommand("alter table Employee NOCHECK constraint all", sqlconn);
sqlCmdNoCheck.ExecuteNonQuery();
sqlCmd2NoCheck.ExecuteNonQuery();
//实例化上下文对象
using (EMSEntities context = new EMSEntities())
{
//先删除后新增
int DptId = int.Parse(gv1.DataKeys[e.RowIndex].Values[0].ToString());
Department eqp = context.Department.Where <Department>(dpt => dpt.DptId == DptId).FirstOrDefault <Department>();
//告诉上下文要删除
context.Entry <Department>(eqp).State = System.Data.Entity.EntityState.Deleted;
//执行删除操作
context.SaveChanges();
Department depart = new Department
{
DptId = int.Parse((gv1.Rows[e.RowIndex].FindControl("txtId") as TextBox).Text.Trim()),
DptName = (gv1.Rows[e.RowIndex].FindControl("txtEqpName") as TextBox).Text.Trim(),
DptAdmin = int.Parse((gv1.Rows[e.RowIndex].FindControl("txtDptAdmin") as TextBox).Text.Trim())
};
//告诉上下文要进行添加操作
context.Entry <Department>(depart).State = System.Data.Entity.EntityState.Added;
//执行添加操作
context.SaveChanges();
}
//恢复外键关系
SqlCommand sqlComdCheck = new SqlCommand("alter table Department CHECK constraint all", sqlconn);
sqlComdCheck.ExecuteNonQuery();
SqlCommand sqlComd2Check = new SqlCommand("alter table Employee CHECK constraint all", sqlconn);
sqlComd2Check.ExecuteNonQuery();
gv1.EditIndex = -1;
PopulateGridView();
lblSuccessMessage.Text = "修改成功!";
lblErrorMessage.Text = "";
/*}
* catch (Exception ex)
* {
* lblSuccessMessage.Text = "";
* lblErrorMessage.Text = ex.Message;
* SQLHelper.Close(sqlconn);
* }
* SQLHelper.Close(sqlconn);*/
}
//insert method
public void saveProjectProgressDB(project_progress progress)
{
try
{
db.project_progress.Add(progress);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
//insert
public int saveProgressDB(emp_progresses progress)
{
try
{
db.emp_progresses.Add(progress);
return(db.SaveChanges());
}
catch (Exception)
{
throw;
}
}
//insert
public void saveProjectDB(project project)
{
try
{
db.projects.Add(project);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
sqlconn = SQLHelper.Connect();
try
{
//暂时禁用外键关系
SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Department NOCHECK constraint all", sqlconn);
SqlCommand sqlCmd2NoCheck = new SqlCommand("alter table Employee NOCHECK constraint all", sqlconn);
sqlCmdNoCheck.ExecuteNonQuery();
sqlCmd2NoCheck.ExecuteNonQuery();
//实例化上下文对象
using (EMSEntities context = new EMSEntities())
{
//先删除后新增
int EmpId = int.Parse(TextBox1.Text.ToString());
Employee emp = context.Employee.Where <Employee>(empl => empl.EmpId == EmpId).FirstOrDefault <Employee>();
//告诉上下文要删除
context.Entry <Employee>(emp).State = System.Data.Entity.EntityState.Deleted;
//执行删除操作
context.SaveChanges();
Employee empEdit = new Employee
{
EmpId = int.Parse(TextBox1.Text.Trim()),
EmpName = TextBox2.Text.Trim(),
Password = TextBox3.Text.Trim(),
EmpPhone = TextBox4.Text.Trim(),
DptId = int.Parse(TextBox6.Text.Trim()),
IsAdmin = int.Parse(TextBox7.Text.Trim())
};
//告诉上下文要进行添加操作
context.Entry <Employee>(empEdit).State = System.Data.Entity.EntityState.Added;
//执行添加操作
context.SaveChanges();
}
//恢复外键关系
SqlCommand sqlComdCheck = new SqlCommand("alter table Department CHECK constraint all", sqlconn);
SqlCommand sqlComd2Check = new SqlCommand("alter table Employee CHECK constraint all", sqlconn);
sqlComdCheck.ExecuteNonQuery();
sqlComd2Check.ExecuteNonQuery();
Label1.Visible = true;
Label1.Text = "修改成功！";
}
catch (Exception ex)
{
Label1.Visible = true;
Label1.Text = ex.Message;
SQLHelper.Close(sqlconn);
}
SQLHelper.Close(sqlconn);
}
public void addEvent(Event e)
{
this.e = e;
try
{
entities.Events.Add(e);
entities.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Something went horribly wrong.");
}
}
public void addActivity(Activity t)
{
this.t = t;
try
{
entities.Activities.Add(t);
entities.SaveChanges();
}
catch (Exception)
{
MessageBox.Show("Something went horribly wrong.");
}
}
public void UpdateMEnterprise(MEnterprise _enterprise)
{
EMSEntities entity = new EMSEntities();
if (_enterprise.MEnterpriseID == 0)
{
entity.MEnterprise.Add(_enterprise);
}
else
{
MEnterprise ishave = entity.MEnterprise.Where(m => m.MEnterpriseID == _enterprise.MEnterpriseID).First();
if (ishave != null)
{
//string brief = ishave.MEnterpriseBrief;
ishave.MEnterpriseAddress = _enterprise.MEnterpriseAddress;
ishave.MEnterpriseName = _enterprise.MEnterpriseName;
ishave.MEnterpriseRight = _enterprise.MEnterpriseRight;
ishave.MEnterpriseTelphoneNumber = _enterprise.MEnterpriseTelphoneNumber;
ishave.MEnterpriseLogo = _enterprise.MEnterpriseLogo;
ishave.MEnterpriseEmail = _enterprise.MEnterpriseEmail;
ishave.MEnterpriseBriefShort = _enterprise.MEnterpriseBriefShort;
//ishave.MEnterpriseBrief = brief;
}
}
entity.SaveChanges();
}
public static void EditEmployeeProjectRoleAssignmnet(Project_role Project_role)
{
EMSEntities datacontext = new EMSEntities();
try
{
if (Project_role != null)
{
int empl_status = EmployeeRepo.GetEmployeeStatusById(Project_role.employee_id);
ProjectModel proj = ProjectRepo.GetProjectDetailsById(Project_role.project_id);
int actual_resource_count = proj.resources_req;
List <Project_role_model> assigned_resource = ProjectRepo.GetAssignedProjectRoleList(0, proj.project_id, 0);
if ((empl_status == 1) && (proj != null) && (assigned_resource.Count <= actual_resource_count))
{
datacontext.Entry(Project_role).State = EntityState.Modified;
datacontext.SaveChanges();
}
else
{
throw new Exception("Check Project details , employee status and resource allocation count ");
}
}
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
Debug.WriteLine(exception.GetBaseException());
throw exception;
}
finally
{
datacontext.Dispose();
}
}
public static void InsertLeaveBalance(Employee employee, int[] arr)//arr constant array - contains manager , HR and TeamLead ID
{
EMSEntities datacontext = new EMSEntities();
try
{
for (int i = 0; i < arr.Length; i++)
{
Leavebalance_sheet leave_balance = new Leavebalance_sheet();
leave_balance.employee_id = employee.id;
leave_balance.leavetype_id = arr[i];
leave_balance.no_of_days = (decimal)Utils.LeaveCalculationBasedDOJ(employee.date_of_joining, arr[i]);
leave_balance.actual_balance = leave_balance.no_of_days;
datacontext.Leavebalance_sheet.Add(leave_balance);
}
datacontext.SaveChanges();
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
Debug.WriteLine(exception.GetBaseException());
throw exception;
}
finally
{
datacontext.Dispose();
}
}
/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
sqlconn = SQLHelper.Connect();
try
{
//暂时禁用外键关系
SqlCommand sqlCmdNoCheck = new SqlCommand("alter table Equipment NOCHECK constraint all", sqlconn);
sqlCmdNoCheck.ExecuteNonQuery();
using (EMSEntities context = new EMSEntities()) {
//找到要删除的id
int EqpId = int.Parse(gv1.DataKeys[e.RowIndex].Values[0].ToString());
Equipment eqp = context.Equipment.Where <Equipment>(equip => equip.EqpId == EqpId).FirstOrDefault <Equipment>();
//告诉上下文要删除
context.Entry <Equipment>(eqp).State = System.Data.Entity.EntityState.Deleted;
//执行删除操作
context.SaveChanges();
}
//恢复外键关系
SqlCommand sqlComdCheck = new SqlCommand("alter table Equipment CHECK constraint all", sqlconn);
sqlComdCheck.ExecuteNonQuery();
PopulateGridView();
lblSuccessMessage.Text = "删除成功!";
lblErrorMessage.Text = "";
}
catch (Exception ex)
{
lblSuccessMessage.Text = "";
lblErrorMessage.Text = ex.Message;
SQLHelper.Close(sqlconn);
}
SQLHelper.Close(sqlconn);
}
public static void InactiveEmployee(Employee existinginstance)
{
EMSEntities datacontext = new EMSEntities();
try
{
//var query = from employee in datacontext.Employees
// join user in datacontext.Users
// on employee.user_id equals user.id
// where employee.id == e_id && user.is_active ==1
// select user;
var query = from user in datacontext.Users
where existinginstance.user_id == user.id && user.is_active == 1
select user;
User user_details = query.FirstOrDefault();
user_details.is_active = 0;
datacontext.Entry(user_details).State = EntityState.Modified;
datacontext.SaveChanges();
//datacontext.Entry(query.FirstOrDefault()).State = EntityState.Deleted;
//datacontext.SaveChanges();
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
Debug.WriteLine(exception.GetBaseException());
throw exception;
}
finally
{
datacontext.Dispose();
}
}
public void DeleteMEnterriseMessage(int id)
{
EMSEntities entity = new EMSEntities();
MEnterpriseMessage item = entity.MEnterpriseMessage.SingleOrDefault(m => m.MessageID == id);
entity.MEnterpriseMessage.Remove(item);
entity.SaveChanges();
}
public void DeleteMEnterpriseCases(int cid)
{
EMSEntities entity = new EMSEntities();
MEnterpriseCases cases = entity.MEnterpriseCases.SingleOrDefault(m => m.MEnterpriseCasesID == cid);
entity.MEnterpriseCases.Remove(cases);
entity.SaveChanges();
}
public void DeleteEnterprise(int id)
{
EMSEntities entity = new EMSEntities();
Enterprise item = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == id);
entity.Enterprise.Remove(item);
entity.SaveChanges();
}
public void SetMEnterriseMessage(MEnterpriseMessage message)
{
EMSEntities entity = new EMSEntities();
entity.MEnterpriseMessage.Add(message);
entity.SaveChanges();
}
public void UpdateMEnterriseMessage(int id, bool read)
{
EMSEntities entity = new EMSEntities();
MEnterpriseMessage item = entity.MEnterpriseMessage.SingleOrDefault(m => m.MessageID == id);
item.MessageIsRead = read;
entity.SaveChanges();
}
//public IHttpActionResult GetAllGrps(string name)
//{
// IList<GroupChangeViewModel> gps = null;
// using (var ctx = new EMSEntities())
// {
// gps = ctx.GRPCHANGEs
// .Where(s => s.CHDATE.ToLower() == name.ToLower())
// .Select(s => new GroupChangeViewModel()
// {
// TRNNO = s.TRNNO,
// CHDATE = s.CHDATE,
// EM_TRNNO = s.EM_TRNNO,
// GRPMST_TRNNO = s.GRPMST_TRNNO
// }).ToList<GroupChangeViewModel>();
// }
// if (gps.Count == 0)
// {
// return NotFound();
// }
// return Ok(gps);
//}
public IHttpActionResult PostNewGrp(GroupChangeViewModel bp)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new EMSEntities())
{
int _trnno;
//int _sr = 1;
//db.Users.OrderByDescending(u => u.UserId).FirstOrDefault();
if (bp.TRNNO == 0)
{
_trnno = Convert.ToInt32(ctx.GRPCHANGEs.OrderByDescending(t => t.TRNNO).FirstOrDefault().TRNNO);
_trnno = _trnno + 1;
//_trnno = Convert.ToInt32(ctx.EMs.OrderByDescending(t => t.TRNNO).First().ToString());
}
else
{
_trnno = Convert.ToInt32(bp.TRNNO) + 1;
}
// int totalConunt = ctx.GRPCHANGEs.Count<GRPCHANGE>();
//bp.TRNNO = _trnno;
ctx.GRPCHANGEs.Add(new GRPCHANGE()
{
TRNNO = _trnno,
CHDATE = bp.CHDATE,
EM_TRNNO = bp.EM_TRNNO,
GRPMST_TRNNO = bp.GRPMST_TRNNO
});
try
{
ctx.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
return(Ok());
}
//insert
public int saveEmpDB(employee employee)
{
try
{
int flag = 0;
var result = db.employees.Where(e => e.emp_nic.Equals(employee.emp_nic)).FirstOrDefault();
if (result == null)
{
db.employees.Add(employee);
db.SaveChanges();
flag = 1;
}
return(flag);
}
catch (Exception)
{
throw;
}
}
public void InsertMEnterpriseCases(MEnterpriseCases cases)
{
EMSEntities entity = new EMSEntities();
if (!entity.MEnterpriseCases.Any(m => m.MEnterpriseCasesID == cases.MEnterpriseCasesID))
{
entity.MEnterpriseCases.Add(cases);
entity.SaveChanges();
}
}
public IHttpActionResult Put(ClassFeeViewModel mt)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new EMSEntities())
{
try
{
var existingClassFee = ctx.CLFEEMSTs.Where(s => s.TRNNO == mt.TRNNO)
.FirstOrDefault <CLFEEMST>();
if (existingClassFee != null)
{
existingClassFee.CLASS_TRNNO = mt.CLASS_TRNNO;
foreach (var dtl in mt.CLFEEDTLs)
{
var mkdetail = new CLFEEDTL
{
TRNNO = dtl.TRNNO,
SR = dtl.SR,
FEE = dtl.FEE,
ADT = dtl.ADT
};
ctx.Entry(mkdetail).State = System.Data.Entity.EntityState.Modified;
}
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(Ok());
}
public IHttpActionResult Put(SectionViewModel sec)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new EMSEntities())
{
try
{
var existingSection = ctx.SECMSTs.Where(s => s.TRNNO == sec.TRNNO)
.FirstOrDefault <SECMST>();
if (existingSection != null)
{
existingSection.CLASS_TRNNO = sec.CLASS_TRNNO;
existingSection.TRNNO = sec.TRNNO;
foreach (var secdtl in sec.SECDTLs)
{
var detailSection = new SECDTL
{
//BudgetId = Here i need to get id of the Budget table that i inserted before
TRNNO = sec.TRNNO,
SR = secdtl.SR,
SNAME = secdtl.SNAME,
STATUS = secdtl.STATUS,
};
ctx.SECDTLs.Add(detailSection);
}
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(Ok());
}
//insert method
public int saveClientDB(client client)
{
int flag = 0;
try
{
var result = db.clients.Where(c => c.client_nic.Equals(client.client_nic)).FirstOrDefault();
if (result == null)
{
db.clients.Add(client);
db.SaveChanges();
flag = 1;
}
}
catch (Exception)
{
throw;
}
return(flag);
}
public bool SaveEnquiry(EnquiryDetailViewModel ob)
{
var _enq = new EnquiryDetail();
_enq.FirstName = ob.FirstName.ToStringValue();
_enq.LastName = ob.LastName.ToStringValue();
_enq.DOB = ob.DOB.ToStringValue();
_enq.Mobile = ob.Mobile.ToStringValue();
_enq.Class = ob.Class.ToStringValue();
_enq.Address = ob.Address.ToStringValue();
_enq.Email = ob.Email.ToStringValue();
_enq.EntryTime = DateTime.Now;
_enq.ResolvedTime = null;
_enq.Dated = DateTime.Now;
_enq.Resolved = false;
_ety.EnquiryDetails.Add(_enq);
_ety.SaveChanges();
ob.ID = _enq.ID;
return(true);
}
/// <summary>
/// Saves context changes
/// </summary>
public void SaveChanges()
{
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
LogEntityValidationErrors(e.EntityValidationErrors);
throw;
}
}
public bool SetEnterpriseStatus(int id, bool status)
{
EMSEntities entity = new EMSEntities();
Enterprise enterprise = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == id);
if (enterprise != null)
{
enterprise.EnterpriseStatus = status;
return(entity.SaveChanges() != 0);
}
return(false);
}
public bool AddTemplate(string templateName, string templateFile)
{
EMSEntities entity = new EMSEntities();
Templates template = new Templates();
template.TemplateName = templateName;
template.Template = templateFile;
entity.Templates.Add(template);
return(entity.SaveChanges() != 0);
}
public bool SetEnterpriseBrief(int enterpriseID, string brief)
{
EMSEntities entity = new EMSEntities();
Enterprise enterprise = entity.Enterprise.SingleOrDefault(m => m.EnterpriseID == enterpriseID);
if (enterprise != null)
{
enterprise.EnterpriseBrief = brief;
return(entity.SaveChanges() != 0);
}
return(false);
}
//update method
public int updateTaskDB(int id, task task)
{
int flag = 0;
try
{
var result = db.tasks.Where(t => t.task_id == id && t.task_status == 1).FirstOrDefault();
if (result != null)
{
db.Entry(result).State = EntityState.Detached;
db.Entry(task).State = EntityState.Modified;
db.SaveChanges();
flag = 1;
}
}
catch (Exception)
{
throw;
}
return(flag);
}
public bool ChangeAdminPwd(string admin, string newpwd)
{
EMSEntities entity = new EMSEntities();
MEnterpriseAdmin _admin = entity.MEnterpriseAdmin.SingleOrDefault(m => m.AdminName == admin);
if (_admin == null)
{
return(false);
}
_admin.MEnterpriseAdminPassword = newpwd;
entity.SaveChanges();
return(true);
}
protected void Button2_Click(object sender, EventArgs e)
{
EMSEntities Context=new EMSEntities();
EntittyFramewordWebApplication4.StudentDetail stud1=new StudentDetail();
stud1.id = "67";
stud1.name = "ziauddin";
stud1.address = "chittagong";
stud1.marks = 88;
stud1.section = "C";
Context.StudentDetails.Add(stud1);
Context.SaveChanges();
Label1.Text = "added";
}
protected void Button3_Click(object sender, EventArgs e)
{
EMSEntities dbcontext = new EMSEntities();
EntittyFramewordWebApplication4.StudentDetail stud1 = new StudentDetail();
try
{
string idd = TextBox2.Text;
stud1 = dbcontext.StudentDetails.FirstOrDefault(xx => xx.id == idd);
stud1.marks = int.Parse(TextBox6.Text);
stud1.section = TextBox5.Text;
dbcontext.SaveChanges();
Label1.Text = "updated successfull";
}
catch(Exception e1)
{
Label1.Text = "not found";
}
}
protected void Button7_Click(object sender, EventArgs e)
{
//EMSEntities dbcontext = new EMSEntities();
//emp e1 = new emp();
//e1.empId = int.Parse(TextBox2.Text);
//e1.name = TextBox4.Text;
//e1.deptno = int.Parse(TextBox5.Text);
//e1.job = TextBox5.Text;
//e1.salary = int.Parse(TextBox6.Text);
//dbcontext.emps.Add(e1);
//dbcontext.SaveChanges();
//Label1.Text = "added from emp table";
EMSEntities dbcontext = new EMSEntities();
emp e1 = new emp();
e1.empId = 786;
e1.name = "pabel";
e1.deptno = 56;
e1.job = "hr";
e1.salary = 6700;
dbcontext.emps.Add(e1);
dbcontext.SaveChanges();
Label1.Text = "added from emp table";
}