C# (CSharp) ppmapp.Models projectClass Exemples

Exemple #1

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

//Convert DataTable To object method
        public projectClass ConvertToOjbect(DataTable dt)
        {
            projectClass obj_project = new projectClass();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                if (Convert.ToString(dt.Rows[i]["Projectid"]) != "")
                {
                    obj_project.Projectid = Convert.ToInt32(dt.Rows[i]["Projectid"]);
                }
                else
                {
                    obj_project.Projectid = Convert.ToInt32("0");
                }

                if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "")
                {
                    obj_project.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]);
                }
                else
                {
                    obj_project.Buildingsystemid = Convert.ToInt32("0");
                }

                if (Convert.ToString(dt.Rows[i]["Projectname"]) != "")
                {
                    obj_project.Projectname = Convert.ToString(dt.Rows[i]["Projectname"]);
                }
                else
                {
                    obj_project.Projectname = Convert.ToString("");
                }
            }
            return(obj_project);
        }

Exemple #2

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

//create parameter
        public void createParameter(projectClass obj, DB_con.DBTrans trans)
        {
            try
            {
                obj_con.clearParameter();
                obj_con.addParameter("@Buildingsystemid", string.IsNullOrEmpty(Convert.ToString(obj.Buildingsystemid)) ? 0 : obj.Buildingsystemid);
                obj_con.addParameter("@Projectname", string.IsNullOrEmpty(Convert.ToString(obj.Projectname)) ? "" : obj.Projectname);
                obj_con.addParameter("@Projectid", obj.Projectid, trans);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

Exemple #3

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

//Select Constructor
        public projectCtl(Int32 id)
        {
            obj_con = new ConnectionCls();
            projectClass obj_pro = new projectClass();

            using (DataTable dt = selectdatatable(id))
            {
                if (dt.Rows.Count > 0)
                {
                    obj_pro.Projectid        = Convert.ToInt32(dt.Rows[0]["Projectid"]);
                    obj_pro.Buildingsystemid = Convert.ToInt32(dt.Rows[0]["Buildingsystemid"]);
                    obj_pro.Projectname      = Convert.ToString(dt.Rows[0]["Projectname"]);
                }
            }
        }

Exemple #4

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

 //insert data into database
 public Int32 insert(projectClass obj)
 {
     try
     {
         obj_con.clearParameter();
         createParameter(obj, DBTrans.Insert);
         obj_con.BeginTransaction();
         obj_con.ExecuteNoneQuery("sp_project_insert", CommandType.StoredProcedure);
         obj_con.CommitTransaction();
         return(obj.Projectid = Convert.ToInt32(obj_con.getValue("@Projectid")));
     }
     catch (Exception ex)
     {
         obj_con.RollbackTransaction();
         throw new Exception("sp_project_insert");
     }
 }

Exemple #5

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

//Convert DataTable To List method
        public List <projectClass> ConvertToList(DataTable dt)
        {
            List <projectClass> projectlist = new List <projectClass>();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                projectClass obj_project = new projectClass();

                if (Convert.ToString(dt.Rows[i]["Projectid"]) != "")
                {
                    obj_project.Projectid = Convert.ToInt32(dt.Rows[i]["Projectid"]);
                }
                else
                {
                    obj_project.Projectid = Convert.ToInt32("0");
                }

                if (Convert.ToString(dt.Rows[i]["Buildingsystemid"]) != "")
                {
                    obj_project.Buildingsystemid = Convert.ToInt32(dt.Rows[i]["Buildingsystemid"]);
                }
                else
                {
                    obj_project.Buildingsystemid = Convert.ToInt32("0");
                }

                if (Convert.ToString(dt.Rows[i]["Projectname"]) != "")
                {
                    obj_project.Projectname = Convert.ToString(dt.Rows[i]["Projectname"]);
                }
                else
                {
                    obj_project.Projectname = Convert.ToString("");
                }


                projectlist.Add(obj_project);
            }
            return(projectlist);
        }

Exemple #6

Fichier : project.cs Projet : kaushaldevluk/PPMBindablePickerIssue

//update edited object
        public projectClass updateObject(projectClass obj)
        {
            try
            {
                projectClass oldObj = selectById(obj.Projectid);
                if (obj.Buildingsystemid == null || obj.Buildingsystemid.ToString().Trim() == "0")
                {
                    obj.Buildingsystemid = oldObj.Buildingsystemid;
                }

                if (obj.Projectname == null || obj.Projectname.ToString().Trim() == "update")
                {
                    obj.Projectname = oldObj.Projectname;
                }

                return(obj);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }