Ejemplo n.º 1
0
        public void DeleteTechnology(int technology)
        {
            try
            {
                if (ValidationHelper.IfTechnologyExist(technology))
                {
                    CompanyDBDataContext dc = new CompanyDBDataContext();

                    List <TechProjectMap> techProjectList = (from techProject in dc.TechProjectMaps where techProject.TechID == technology select techProject).ToList();

                    List <TechTaskMap> techTaskList       = (from techTask in dc.TechTaskMaps where techTask.TechID == technology select techTask).ToList();
                    TechnologyMaster   technologyToDelete = (from tech in dc.TechnologyMasters where tech.TechID == technology select tech).First();
                    dc.TechTaskMaps.DeleteAllOnSubmit(techTaskList);
                    dc.TechProjectMaps.DeleteAllOnSubmit(techProjectList);
                    dc.TechnologyMasters.DeleteOnSubmit(technologyToDelete);
                    dc.SubmitChanges();
                    Console.WriteLine("Technology Deleted Sucessfully");;
                }
                else
                {
                    throw new Exception(QueryResource.TechnologyNotexist);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 2
0
        public void DeleteTechnology(int technologyID)
        {
            try
            {
                List <ProjectTechnology> projectTechnologies = (from projectTech in dataContext.ProjectTechnologies
                                                                where projectTech.TechnologyId == technologyID
                                                                select projectTech).ToList();
                if (projectTechnologies.Count > 0)
                {
                    dataContext.ProjectTechnologies.DeleteAllOnSubmit(projectTechnologies);
                    dataContext.SubmitChanges();
                }
                List <TaskTechnology> taskTechnology = (from taskTech in dataContext.TaskTechnologies
                                                        where taskTech.TechnologyId == technologyID
                                                        select taskTech).ToList();
                if (taskTechnology.Count > 0)
                {
                    dataContext.TaskTechnologies.DeleteAllOnSubmit(taskTechnology);
                    dataContext.SubmitChanges();
                }

                TechnologyMaster technology = (from tech in dataContext.TechnologyMasters
                                               where tech.TechnologyId == technologyID
                                               select tech).FirstOrDefault();
                if (technology != null)
                {
                    dataContext.TechnologyMasters.DeleteOnSubmit(technology);
                    dataContext.SubmitChanges();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 3
0
        public ActionResult DeleteConfirmed(int id)
        {
            TechnologyMaster technologyMaster = db.TechnologyMasters.Find(id);

            db.TechnologyMasters.Remove(technologyMaster);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public static BOTechnology ConvertTechnologyToBOTechnology(TechnologyMaster technology)
        {
            BOTechnology boTechnology = new BOTechnology();

            boTechnology.TechnologyId   = technology.TechnologyId;
            boTechnology.TechnologyName = technology.TechnologyName;

            return(boTechnology);
        }
        public static TechnologyMaster ConvertBOTechnologyToTechnology(BOTechnology boTechnology)
        {
            TechnologyMaster technology = new TechnologyMaster();

            technology.TechnologyId   = boTechnology.TechnologyId;
            technology.TechnologyName = boTechnology.TechnologyName;

            return(technology);
        }
Ejemplo n.º 6
0
 public ActionResult Edit([Bind(Include = "TechId,TechName")] TechnologyMaster technologyMaster)
 {
     if (ModelState.IsValid)
     {
         db.Entry(technologyMaster).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(technologyMaster));
 }
 public static string CheckCompulsoryTechnologyColumn(TechnologyMaster technology)
 {
     if (string.IsNullOrEmpty(technology.TechnologyName))
     {
         return(CMResources.TechnologyNameMissing);
     }
     else
     {
         return(CMResources.AllFieldsPresent);
     }
 }
Ejemplo n.º 8
0
 public void AddTechnology(BOTechnology boTechnology)
 {
     try
     {
         TechnologyMaster technology = BusinessLayerHelper.ConvertBOTechnologyToTechnology(boTechnology);
         dataLayer.AddTechnology(technology);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 9
0
        public string checkCompulsoryTechnologyColumn()
        {
            TechnologyMaster tech = new TechnologyMaster();

            if (string.IsNullOrEmpty(tech.TechName))
            {
                return("Tech Name Missing");
            }
            else
            {
                return("All field present");
            }
        }
Ejemplo n.º 10
0
        // GET: admin/TechnologyMasters/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TechnologyMaster technologyMaster = db.TechnologyMasters.Find(id);

            if (technologyMaster == null)
            {
                return(HttpNotFound());
            }
            return(View(technologyMaster));
        }
Ejemplo n.º 11
0
 public static string CheckCompulsoryTechnologyColumn(TechnologyMaster technology)
 {
     if (string.IsNullOrEmpty(technology.TechName))
     {
         return(QueryResource.TechNameMissing);
     }
     else if (technology.TechID == 0)
     {
         return(QueryResource.TechIdMissing);
     }
     else
     {
         return(QueryResource.AllFieldsPresent);
     }
 }
Ejemplo n.º 12
0
        public void AddTechnology(TechnologyMaster technology)
        {
            CompanyDBDataContext dc = new CompanyDBDataContext();

            string dataValidate = ValidationHelper.CheckCompulsoryTechnologyColumn(technology);

            if (dataValidate != QueryResource.AllFieldsPresent)
            {
                throw new Exception(dataValidate);
            }
            else
            {
                dc.TechnologyMasters.InsertOnSubmit(technology);
                dc.SubmitChanges();
            }
        }
Ejemplo n.º 13
0
        public void insertTechnology(int id, string name, int cost)
        {
            DataClasses1DataContext dc = new DataClasses1DataContext();
            TechnologyMaster        technologyMaster = new TechnologyMaster();

            technologyMaster.TechID   = id;
            technologyMaster.TechName = name;
            technologyMaster.TechCost = cost;
            string checkColumn = checkCompulsoryTechnologyColumn();

            if (checkColumn != "All field present")
            {
                throw new Exception(checkColumn);
            }
            dc.TechnologyMasters.InsertOnSubmit(technologyMaster);
            dc.SubmitChanges();
        }
Ejemplo n.º 14
0
        public void AddTechnology(TechnologyMaster technology)
        {
            try
            {
                string checkCompulsoryFields = DataLayerHelper.CheckCompulsoryTechnologyColumn(technology);
                if (checkCompulsoryFields != CMResources.AllFieldsPresent)
                {
                    throw new Exception(checkCompulsoryFields);
                }

                dataContext.TechnologyMasters.InsertOnSubmit(technology);
                dataContext.SubmitChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 15
0
        public ActionResult Create([Bind(Include = "TechId,TechName")] TechnologyMaster technologyMaster)
        {
            try
            {
                var tech = db.TechnologyMasters.OrderByDescending(a => a.TechId).ToList();

                int id = 1;
                if (tech.Count > 0)
                {
                    id = tech[0].TechId + 1;
                }
                technologyMaster.TechId = id;
                db.TechnologyMasters.Add(technologyMaster);
                db.SaveChanges();
                TempData["Message"] = "Technology Name Saved!";
            }
            catch (Exception ex)
            {
                TempData["Error"] = ex.Message;
            }


            return(RedirectToAction("Index"));
        }