public ActionResult DeleteDesignation(DesignationMaster designationMaster)
{
DesignationService delete = new DesignationService();
delete.DeleteDesignation(designationMaster.DesignationId);
return(RedirectToAction("AllDesignations"));
}
public long InsertUpdateDesignationDetails(CompanyBE.DesignationBE lst)
{
if (lst.DesignationID != 0)
{
var lstDepartment = _ObjEINS_RBMSEntities.DesignationMasters.FirstOrDefault(x => x.DesignationID == lst.DesignationID);
lstDepartment.DesignationName = lst.DesignationName;
lstDepartment.Description = lst.Description;
lstDepartment.Status = true;
lstDepartment.LastModifiedBy = lst.LastModifiedBy;
lstDepartment.LastModifiedOn = DateTime.Now;
_ObjEINS_RBMSEntities.SaveChanges();
return(lstDepartment.DesignationID);
}
else
{
DesignationMaster _Obj = new DesignationMaster();
_Obj.DesignationName = lst.DesignationName;
_Obj.Description = lst.Description;
_Obj.Status = true;
_Obj.AddedBy = lst.AddedBy;
_Obj.AddedOn = DateTime.Now;
_ObjEINS_RBMSEntities.AddToDesignationMasters(_Obj);
_ObjEINS_RBMSEntities.SaveChanges();
return(_Obj.DesignationID);
}
}
public List <DesignationMaster> GetDesignation()
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InstituteSystem"].ConnectionString);
SqlCommand comm = new SqlCommand("ReadDesignation", conn);
List <DesignationMaster> designations = new List <DesignationMaster>();
comm.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
comm.ExecuteNonQuery();
SqlDataReader dataReader = comm.ExecuteReader();
while (dataReader.Read())
{
DesignationMaster designationMaster = new DesignationMaster();
designationMaster.DesignationId = dataReader.GetInt32(0);
designationMaster.Designation = dataReader.GetString(1);
designations.Add(designationMaster);
}
}
catch (Exception e)
{
}
finally
{
conn.Close();
}
return(designations);
}
/// <summary>
/// Get Designation List
/// </summary>
/// <returns></returns>
public List <DesignationMaster> GetDesignations(int TenantID)
{
DataSet ds = new DataSet();
//MySqlCommand cmd = new MySqlCommand();
List <DesignationMaster> designationMasters = new List <DesignationMaster>();
try
{
conn = Db.Connection;
MySqlCommand cmd1 = new MySqlCommand("SP_getDesignationMaster", conn);
cmd1.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
cmd1.Parameters.AddWithValue("@Tenant_ID", TenantID);
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DesignationMaster designationMaster = new DesignationMaster();
designationMaster.DesignationID = Convert.ToInt32(ds.Tables[0].Rows[i]["DesignationID"]);
designationMaster.DesignationName = Convert.ToString(ds.Tables[0].Rows[i]["DesignationName"]);
designationMasters.Add(designationMaster);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(designationMasters);
}
public DesignationMaster GetDesignationMasterRecord(string recordID, string UserID)
{
DesignationMaster designationMaster = new DesignationMaster();
SqlDataReader dr = null;
try
{
SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", Convert.ToInt32(UserID)) };
dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordDesignationMaster", Parameters);
if (dr.Read())
{
designationMaster.SNo = Convert.ToInt32(dr["SNo"]);
designationMaster.Name = Convert.ToString(dr["Name"]);
designationMaster.IsActive = Convert.ToBoolean(dr["IsActive"]);
designationMaster.Hierarchy = Convert.ToString(dr["Hierarchy"]);
designationMaster.MaximumShiftHour = Convert.ToInt32(dr["MaximumShiftHour"]);
designationMaster.CreatedOn = Convert.ToString(dr["CreatedOn"]);
designationMaster.CreatedBy = Convert.ToString(dr["CreatedBy"]);
designationMaster.UpdatedBy = Convert.ToString(dr["UpdatedBy"]);
designationMaster.UpdatedOn = Convert.ToString(dr["UpdatedOn"]);
designationMaster.Active = Convert.ToString(dr["Active"]);
}
}
catch (Exception ex)// (Exception ex)
{
dr.Close();
}
return(designationMaster);
}
public ActionResult DesignationDeletePartial(DesignationMaster designation)
{
designation.Status = "InActive";
designation.ModifiedOn = DateTime.Now;
_DesignationMasterService.Update(designation);
return(RedirectToAction("DesignationUpdateDetails/" + designation.Id, "Designation"));
}
public ActionResult DesignationList(DesignationMaster designationMaster)
{
DesignationService add = new DesignationService();
add.AddDesignation(designationMaster);
return(RedirectToAction("AllDesignations"));
}
public async Task <ActionResult> Create(DesignationMasterModel model, bool continueEditing)
{
try
{
var designation = new DesignationMaster {
Designation = model.Designation,
Active = model.Active,
Deleted = false,
DateUpdated = DateTime.UtcNow,
DateCreated = DateTime.UtcNow
};
await _designationMasterService.InsertAsync(designation);
if (continueEditing)
{
return(RedirectToAction(nameof(Edit), new { id = designation.Id }));
}
TempData["UserMessageSuccess"] = "Record saved sucessfully.";
return(RedirectToAction(nameof(List)));
}
catch (Exception ex)
{
TempData["UserMessageError"] = ex.Message.ToString();
return(RedirectToAction(nameof(Create)));
}
}
public ActionResult DeleteConfirmed(int id)
{
DesignationMaster designationMaster = db.DesignationMasters.Find(id);
db.DesignationMasters.Remove(designationMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DesignationUpdateDetails(int id)
{
DesignationMaster designatn = new DesignationMaster();
TempData["DesignationList"] = _DesignationMasterService.getAllDesignation();
designatn = _DesignationMasterService.getById(id);
return(View(designatn));
}
public ActionResult Edit([Bind(Include = "DesignationId,DesignationName,DesignationCode")] DesignationMaster designationMaster)
{
if (ModelState.IsValid)
{
db.Entry(designationMaster).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(designationMaster));
}
public ActionResult Create([Bind(Include = "DesignationId,DesignationName,DesignationCode")] DesignationMaster designationMaster)
{
if (ModelState.IsValid)
{
db.DesignationMasters.Add(designationMaster);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(designationMaster));
}
public static string[] GetCompletionListDesg(string prefixText, int count, string contextKey)
{
DesignationMaster objquali = new DesignationMaster();
DataTable dt = new DataView(objquali.GetDesignationMaster(HttpContext.Current.Session["CompId"].ToString()), "Designation like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Designation"].ToString();
}
return(txt);
}
// GET: DesignationMasters/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DesignationMaster designationMaster = db.DesignationMasters.Find(id);
if (designationMaster == null)
{
return(HttpNotFound());
}
return(View(designationMaster));
}
/// <summary>
/// Get Reportee Designation
/// </summary>
/// <param name="DesignationID"></param>
/// <param name="HierarchyFor"></param>
/// <param name="TenantID"></param>
/// <returns></returns>
public List <DesignationMaster> GetReporteeDesignation(int DesignationID, int HierarchyFor, int TenantID)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <DesignationMaster> designationMasters = new List <DesignationMaster>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("SP_GetReporteeDesignation", conn);
cmd1.CommandType = CommandType.StoredProcedure;
MySqlDataAdapter da = new MySqlDataAdapter
{
SelectCommand = cmd1
};
cmd1.Parameters.AddWithValue("@Designation_ID", DesignationID);
cmd1.Parameters.AddWithValue("@Tenant_ID", TenantID);
cmd1.Parameters.AddWithValue("@Hierarchy_For", HierarchyFor);
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DesignationMaster designationMaster = new DesignationMaster();
designationMaster.DesignationID = Convert.ToInt32(ds.Tables[0].Rows[i]["DesignationID"]);
designationMaster.DesignationName = Convert.ToString(ds.Tables[0].Rows[i]["DesignationName"]);
designationMasters.Add(designationMaster);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(designationMasters);
}
public void AddDesignation(DesignationMaster designationMaster)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["InstituteSystem"].ConnectionString);
SqlCommand comm = new SqlCommand("AddDesignation", conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add(new SqlParameter("@designationName", SqlDbType.VarChar));
comm.Parameters["@designationName"].Value = designationMaster.Designation;
try
{
conn.Open();
comm.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e);
}
finally
{
conn.Close();
}
}
/// <summary>
/// Add and Edit Document
/// </summary>
/// <param name="data"></param>
/// <param name="userId"></param>
/// <returns></returns>
public CommonResponse AddAndEditDesignation(DesignationCustom data, long userId = 0)
{
CommonResponse obj = new CommonResponse();
try
{
var res = db.DesignationMaster.Where(m => m.DesignationId == data.designationId).FirstOrDefault();
if (res == null)
{
try
{
DesignationMaster item = new DesignationMaster();
item.DesignationName = data.designationName;
item.DesignationDescription = data.designationDescription;
item.IsActive = true;
item.IsDeleted = false;
item.CreatedBy = userId;
item.CreatedOn = DateTime.Now;
db.DesignationMaster.Add(item);
db.SaveChanges();
obj.response = ResourceResponse.AddedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
else
{
try
{
res.DesignationName = data.designationName;
res.DesignationDescription = data.designationDescription;
res.ModifiedBy = userId;
res.ModifiedOn = DateTime.Now;
db.SaveChanges();
obj.response = ResourceResponse.UpdatedSucessfully;
obj.isStatus = true;
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
}
}
catch (Exception ex)
{
log.Error(ex); if (ex.InnerException != null)
{
log.Error(ex.InnerException.ToString());
}
obj.response = ResourceResponse.ExceptionMessage;
obj.isStatus = false;
}
return(obj);
}
public void Update(DesignationMaster designation)
{
_DesignationMasterRepository.Update(designation);
_UnitOfWork.Commit();
}
public void Create(DesignationMaster designation)
{
_DesignationMasterRepository.Add(designation);
_UnitOfWork.Commit();
}
public ActionResult EditEmployee(string id)
{
Admin objEmp = new Admin();
Manager objmng = new Manager();
Country country = new Country();
DesignationMaster dm = new DesignationMaster();
RoleMaster rm = new RoleMaster();
State state = new State();
City city = new City();
List <SelectListItem> Countries = new List <SelectListItem>();
List <SelectListItem> States = new List <SelectListItem>();
List <SelectListItem> Cities = new List <SelectListItem>();
List <SelectListItem> Desig = new List <SelectListItem>();
List <SelectListItem> Role = new List <SelectListItem>();
objmng.EmployeeId = Convert.ToInt32(id);
if (id != null && id != "")
{
try
{
Countries = country.GetCountry();
objEmp.EmployeeID = Convert.ToInt32(id);
//dm.CompanyID = Convert.ToInt16(User.Identity.Name.Split('|')[0]);
Desig = dm.GetDesignation();
rm.CompanyID = Convert.ToInt16(User.Identity.Name.Split('|')[0]);
Role = rm.GetRoleName();
if (objEmp.GetEmployeeByID())
{
foreach (DataRow dr in objEmp.dtbl.Rows)
{
objEmp.EmployeeID = Convert.ToInt32(id);
if (!dr.IsNull("RoleID"))
{
objEmp.RoleID = Convert.ToInt32(dr["RoleID"]);
}
if (!dr.IsNull("FullName"))
{
objEmp.FullName = Convert.ToString(dr["FullName"]);
}
if (!dr.IsNull("CommunicationSkill"))
{
objEmp.CommunicationSkill = Convert.ToString(dr["CommunicationSkill"]);
}
if (!dr.IsNull("OfficeEmailID"))
{
objEmp.OfficeEmailID = Convert.ToString(dr["OfficeEmailID"]);
}
if (!dr.IsNull("PersonalMailId"))
{
objEmp.PersonalMailId = Convert.ToString(dr["PersonalMailId"]);
}
if (!dr.IsNull("ProfilePic"))
{
objEmp.ProfilePic = Convert.ToString(dr["ProfilePic"]);
}
if (!dr.IsNull("JobLocation"))
{
objEmp.JobLocation = Convert.ToString(dr["JobLocation"]);
}
if (!dr.IsNull("JobCountry"))
{
objEmp.JobCountry = Convert.ToInt32(dr["JobCountry"]);
}
if (!dr.IsNull("JobCity"))
{
objEmp.JobCity = Convert.ToInt32(dr["JobCity"]);
}
if (!dr.IsNull("JobState"))
{
objEmp.JobState = Convert.ToInt32(dr["JobState"]);
city.StateID = objEmp.JobState;
Cities = city.GetCityByStateID();
}
if (!dr.IsNull("JobCountry"))
{
objEmp.JobCountry = Convert.ToInt32(dr["JobCountry"]);
state.CountryID = objEmp.JobCountry;
States = state.GetStateByCountryID();
}
if (!dr.IsNull("ObjPinCode"))
{
objEmp.ObjPinCode = Convert.ToString(dr["ObjPinCode"]);
}
if (!dr.IsNull("Password"))
{
objEmp.Password = Convert.ToString(dr["Password"]);
}
if (!dr.IsNull("OfficeMobileNo"))
{
objEmp.OfficeMobileNo = Convert.ToString(dr["OfficeMobileNo"]);
}
if (!dr.IsNull("PersonalMobileNumber"))
{
objEmp.PersonalMobileNumber = Convert.ToString(dr["PersonalMobileNumber"]);
}
if (!dr.IsNull("Designation"))
{
objEmp.Designation = Convert.ToInt32(dr["Designation"]);
}
//if (!dr.IsNull("Qualification"))
//{
// objEmp.Qualification = Convert.ToString(dr["Qualification"]);
//}
if (!dr.IsNull("CommunicationAddress"))
{
objEmp.CommunicationAddress = Convert.ToString(dr["CommunicationAddress"]);
}
if (!dr.IsNull("PermanentAddress"))
{
objEmp.PermanentAddress = Convert.ToString(dr["PermanentAddress"]);
}
if (!dr.IsNull("PANNO"))
{
objEmp.PANNO = Convert.ToString(dr["PANNO"]);
}
if (!dr.IsNull("AdhaarNo"))
{
objEmp.AdhaarNo = Convert.ToString(dr["AdhaarNo"]);
}
//if (!dr.IsNull("AdhaarNo"))
//{
// objEmp.AdhaarNo = Convert.ToString(dr["AdhaarNo"]);
//}
}
}
}
catch (Exception ex)
{
ex.ToString();
}
finally
{
GC.Collect();
}
ViewData["Employee"] = objEmp;
ViewBag.Country = Countries;
ViewBag.States = States;
ViewBag.City = Cities;
ViewBag.Desig = Desig;
ViewBag.Role = Role;
}
else
{
RedirectToAction("Employees", "Company");
}
return(View());
}
public async Task DeleteAsync(DesignationMaster entity)
{
await _designationRepo.RemoveAsync(entity);
}
public async Task UpdateAsync(DesignationMaster entity)
{
await _designationRepo.UpdateAsync(entity);
}
public async Task InsertAsync(DesignationMaster entity)
{
await _designationRepo.AddAsync(entity);
}
