public ActionResult Signup(user User, string Department, string Designation, string gender)
{
if (User.UserName != "" || User.Name != "" || User.Password != "" || User.Email != "")
{
try
{
int depid = int.Parse(Department);
int desid = int.Parse(Designation);
department dep = db.Departments.FirstOrDefault(p => p.DepartmentId == depid);
designation des = db.Designations.FirstOrDefault(p => p.DesignationId == desid);
status st = db.States.FirstOrDefault(p => p.StatusId == 1);
string role = "Employ";
User.Role = role;
User.Status = st;
User.Department = dep;
User.Designation = des;
db.Users.Add(User);
db.SaveChanges();
return(Redirect("dashboard"));
}
catch (Exception ex)
{
ViewBag.errormsg = "Some Thing Went Wrong";
return(Signup());
}
}
return(Signup());
}
public HttpResponseMessage SaveChangeReason(designation obj)
{
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand command;
try
{
connection.Open();
command = new OracleCommand("HCI_SP_CHANGE_REASON_INSERT");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.Add("V_ID", OracleType.Number).Value = obj.Id;
command.Parameters.Add("V_CODE", OracleType.VarChar).Value = obj.Code;
command.Parameters.Add("V_DESCRIPTION", OracleType.VarChar).Value = obj.Description;
command.Parameters.Add("V_CREATED_BY", OracleType.VarChar).Value = obj.CreatedBy;
command.Parameters.Add("V_ACTIVE_STATUS", OracleType.Number).Value = obj.ActiveStatus;
command.ExecuteNonQuery();
connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception exception)
{
connection.Close();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
public IHttpActionResult Putdesignation(int id, designation designation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != designation.id)
{
return(BadRequest());
}
db.Entry(designation).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!designationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public long AddDesignation(designation designation)
{
try
{
designation insertDesignation = new designation
{
sales_designation = designation.sales_designation,
sales_person_type_code = designation.sales_person_type_code,
parent_designation_id = designation.parent_designation_id,
sales_type_id = designation.sales_type_id,
created_by = designation.created_by,
updated_by = designation.updated_by,
created_date = designation.created_date,
updated_date = designation.updated_date
};
_entities.designations.Add((insertDesignation));
_entities.SaveChanges();
long lastInsertId = insertDesignation.sales_designation_id;
return(lastInsertId);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult DeleteConfirmed(int id)
{
designation dsg = db.designations.Find(id);
db.designations.Remove(dsg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public designation Get(int id)
{
designation designation = new designation();
OracleDataReader dataReader = null;
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand command;
string sql = " SELECT " +
" CASE WHEN t.ID IS NULL THEN 0 ELSE t.ID END, " +
" CASE WHEN t.CODE IS NULL THEN '' ELSE t.CODE END, " +
" CASE WHEN t.DESCRIPTION IS NULL THEN '' ELSE t.DESCRIPTION END, " +
" CASE WHEN t.CREATED_BY IS NULL THEN '' ELSE t.CREATED_BY END, " +
" CASE WHEN t.CREATED_DATE IS NULL THEN to_date('01/01/1900', 'DD/MM/RRRR') ELSE to_date(t.CREATED_DATE, 'DD/MM/RRRR') END, " +
" T.ACTIVE_STATUS, " +
" CASE WHEN t.EFFECTIVE_END_DATE IS NULL THEN to_date('01/01/1900', 'DD/MM/RRRR') ELSE to_date(t.EFFECTIVE_END_DATE, 'DD/MM/RRRR') END " +
" FROM HCI_TBL_DESIGNATION t WHERE t.ID=:V_ID";
command = new OracleCommand(sql, connection);
command.Parameters.Add(new OracleParameter("V_ID", id));
connection.Open();
try
{
dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
dataReader.Read();
designation.Id = Convert.ToInt32(dataReader[0].ToString());
designation.Code = dataReader[1].ToString();
designation.Description = dataReader[2].ToString();
designation.CreatedBy = dataReader[3].ToString();
designation.CreatedDate = dataReader[4].ToString();
designation.ActiveStatus = Convert.ToInt16(dataReader[5].ToString());
designation.EffectiveEndDate = dataReader[6].ToString();
dataReader.Close();
connection.Close();
}
else
{
return(null);
}
}
catch (Exception exception)
{
if (dataReader != null || connection.State == ConnectionState.Open)
{
dataReader.Close();
connection.Close();
}
}
finally
{
connection.Close();
}
return(designation);
}
public ActionResult Edit([Bind(Include = "designationId,designation1,level,parentDesignationId")] designation designation)
{
if (ModelState.IsValid)
{
db.Entry(designation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.parentDesignationId = new SelectList(db.designations, "designationId", "designation1", designation.parentDesignationId);
return(View(designation));
}
public IHttpActionResult Getdesignation(int id)
{
designation designation = db.designations.Find(id);
if (designation == null)
{
return(NotFound());
}
return(Ok(designation));
}
public IHttpActionResult Postdesignation(designation designation)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.designations.Add(designation);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = designation.id }, designation));
}
public ActionResult Create([Bind(Include = "designationId,designation1,level,parentDesignationId")] designation designation)
{
if (ModelState.IsValid)
{
db.designations.Add(designation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.parentDesignationId = new SelectList(db.designations, "designationId", "designation1", designation.parentDesignationId);
return(View(designation));
}
public bool DeleteDesignation(long sales_designation_id)
{
try
{
designation oDesignation = _entities.designations.Find(sales_designation_id);
_entities.designations.Remove(oDesignation);
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
// GET: designation/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
designation des = db.designations.Find(id);
if (des == null)
{
return(HttpNotFound());
}
return(View(des));
}
public IHttpActionResult Deletedesignation(int id)
{
designation designation = db.designations.Find(id);
if (designation == null)
{
return(NotFound());
}
db.designations.Remove(designation);
db.SaveChanges();
return(Ok(designation));
}
// GET: /Designation/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
designation designation = db.designations.Find(id);
if (designation == null)
{
return(HttpNotFound());
}
ViewBag.parentDesignationId = new SelectList(db.designations, "designationId", "designation1", designation.parentDesignationId);
return(View(designation));
}
public HttpResponseMessage Post([FromBody] Models.designation designation)
{
try
{
if (string.IsNullOrEmpty(designation.sales_designation))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Designation Name is Empty"
}, formatter));
}
if (string.IsNullOrEmpty(designation.sales_person_type_code))
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = "Code is Empty"
}, formatter));
}
else
{
designation insertDesignation = new designation
{
sales_designation = designation.sales_designation,
sales_person_type_code = designation.sales_person_type_code,
parent_designation_id = designation.parent_designation_id,
sales_type_id = designation.sales_type_id,
created_by = designation.created_by,
updated_by = designation.updated_by,
created_date = DateTime.Now,
updated_date = DateTime.Now
};
designationRepository.AddDesignation(insertDesignation);
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "success", msg = "Save successfully"
}, formatter));
}
}
catch (Exception ex)
{
var formatter = RequestFormat.JsonFormaterString();
return(Request.CreateResponse(HttpStatusCode.OK, new Confirmation {
output = "error", msg = ex.ToString()
}, formatter));
}
}
public ActionResult Edit(designation dsg)
{
try
{
if (ModelState.IsValid)
{
db.Entry(dsg).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dsg));
}
catch
{
return(View());
}
}
public bool EditDesignation(designation designation)
{
try
{
designation data = _entities.designations.Find(designation.sales_designation_id);
data.sales_designation = designation.sales_designation;
data.sales_person_type_code = designation.sales_person_type_code;
data.parent_designation_id = designation.parent_designation_id;
data.sales_type_id = designation.sales_type_id;
data.updated_by = designation.updated_by;
data.updated_date = designation.updated_date;
_entities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Create(designation desg)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
db.designations.Add(desg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(desg));
}
catch
{
return(View());
}
}
public static bool StaFunc(List <Staff> stfLi)
{
string stfMnu = "---------Staff Menu---------S\n" +
"Press 1 to list all staff\n" +
"Press 2 to add a new staff member\n" +
"Press 3 to update an existing staff member\n" +
"Press 4 to delete a staff member\n" +
"Press 5 to return to main menu\n";
string StuChoice = null;
Console.WriteLine(stfMnu);
while (StuChoice != "5")
{
StuChoice = Console.ReadLine();
switch (StuChoice)
{
case "1":
Modify.showAll <Staff>(stfLi);
Console.WriteLine("\n" + stfMnu);
break;
case "2":
Console.WriteLine("Please enter in new details in the following order: Name,Residence and email.\n");
Console.WriteLine("Name");
string Name = Console.ReadLine();
Console.WriteLine("Address one,two and City");
string Address1 = Console.ReadLine();
string Address2 = Console.ReadLine();
string City = Console.ReadLine();
Console.WriteLine("Email:");
string newEmail = Console.ReadLine();
Console.WriteLine("Hire Date:(MM-DD-YYYY)");
string newDate = Console.ReadLine();
DateTime UpdatedDate = Convert.ToDateTime(newDate);
Console.WriteLine("Enter number to chose Designation\n 0 = Clerk \n 1 =Office_Assistance\n 2= Secretary \n 3= Maintainance");
Console.WriteLine("Rank");
string DesigS = Console.ReadLine();
int tr = Convert.ToInt32(DesigS);
Console.WriteLine("Salary");
string sall = Console.ReadLine();
Double newSal = Convert.ToDouble(sall);
designation Deisg = (designation)tr;
Modify.Add <Staff>(stfLi, new Staff(Name, new Address(Address1, Address2, City), newEmail, newSal, UpdatedDate, Deisg));
Console.WriteLine("\nNew List\n");
Modify.showAll <Staff>(stfLi);
Console.WriteLine("\n" + stfMnu);
break;
case "3":
Console.WriteLine("Enter the name and email of the student youd like to update\n");
Console.WriteLine("Name");
string findName = Console.ReadLine();
Console.WriteLine("Email:");
string findEmail = Console.ReadLine();
UpdateStaff(findName, findEmail, stfLi);
Console.WriteLine("New List");
Modify.showAll <Staff>(stfLi);
Console.WriteLine("\n" + stfMnu);
break;
case "4":
Modify.showAll <Staff>(stfLi);
Console.WriteLine("Please enter the name and email of the Staff member you'd like to delete\n");
Console.WriteLine("\nName");
string name = Console.ReadLine();
Console.WriteLine("\nEmail");
string email = Console.ReadLine();
Del(name, email, stfLi);
Console.WriteLine("\nNew List\n");
Modify.showAll <Staff>(stfLi);
Console.WriteLine("\n" + stfMnu);
break;
case "5":
break;
}
}
return(true);
}
public Staff(string Name, Address Residence, string email, double salary, DateTime hiredate, designation designation) : base(Name, Residence, email, salary, hiredate)
{
this.designation = designation;
}
