示例#1
0
        public static void Add(ORM orm)
        {
            Console.Write("\nFirstName: ");
            string fn = Console.ReadLine();

            Console.Write("LastName: ");
            string ln = Console.ReadLine();

            Console.Write("Age: ");
            int age = Convert.ToInt32(Console.ReadLine());

            Console.Write("PhoneNumber: ");
            string pn = Console.ReadLine();

            Console.Write("Email: ");
            string em = Console.ReadLine();

            orm.Add(new People
            {
                FirstName   = fn,
                LastName    = ln,
                Age         = age,
                PhoneNumber = pn,
                Email       = em
            });
        }
示例#2
0
        public override FlowStepToolboxInformation[] GetStepsInformation(string[] nodes, string flowId, string folderId)
        {
            // return step info
            if (nodes == null || nodes.Length != 4 || nodes[0] != "Data" || nodes[1] != PARENT_NODE)
            {
                return(new FlowStepToolboxInformation[0]);
            }

            List <FlowStepToolboxInformation> list = new List <FlowStepToolboxInformation>();
            CRM2011Connection connection           = CRM2011Connection.GetCRMConnectionForName(nodes[2]);

            if (connection == null)
            {
                return(new FlowStepToolboxInformation[0]);
            }

            ORM <CRM2011Entity> orm = new ORM <CRM2011Entity>();

            CRM2011Entity[] crmEntities = orm.Fetch(new WhereCondition[] {
                new FieldWhereCondition("connection_id", QueryMatchType.Equals, connection.connectionId),
                new FieldWhereCondition("crm_entity_display_name", QueryMatchType.Equals, nodes[3])
            });

            foreach (CRM2011Entity entity in crmEntities)
            {
                list.Add(new FlowStepToolboxInformation("Get All Entities", nodes, string.Format(GET_ALL_STEP_INFO + "${0}", entity.entityId)));
                list.Add(new FlowStepToolboxInformation("Get Entity By Id", nodes, string.Format(GET_STEP_INFO + "${0}", entity.entityId)));
                list.Add(new FlowStepToolboxInformation("Add Entity", nodes, string.Format(ADD_STEP_INFO + "${0}", entity.entityId)));
                list.Add(new FlowStepToolboxInformation("Update Entity", nodes, string.Format(UPDATE_STEP_INFO + "${0}", entity.entityId)));
                list.Add(new FlowStepToolboxInformation("Delete Entity", nodes, string.Format(DELETE_STEP_INFO + "${0}", entity.entityId)));
            }
            return(list.ToArray());
        }
示例#3
0
 private static void Initiate()
 {
     Console.CursorVisible = false;
     ORM.FetchData(ref passengers, ref trains, ref stations, ref timeTables);
     PrintHeader();
     worldTime = DateTime.Parse(GENESIS_TIME);
 }
示例#4
0
        public override SiteMapNode BuildSiteMap()
        {
            const string queryRootNode = "ELEMENT (SELECT o FROM SiteMapExtent AS o WHERE o.ParentSiteMap = nil )";

            if (rootNode == null)
            {
                lock (this)
                {
                    UO_Model.Execution.SiteMap rt;
                    using (IQueryResult result = ORM.ObjectScope().GetOqlQuery(queryRootNode).Execute())
                    {
                        if (result.Count > 0)
                        {
                            rt = result[0] as UO_Model.Execution.SiteMap;
                        }
                        else
                        {
                            throw new ApplicationException(MSG.SiteMap_Root_Not_Fould);
                        }
                    }
                    rootNode = new SiteMapNode(this, rt.SiteMap_ID.ToString(), rt.URL, rt.Title, rt.Description);
                    AddNode(rootNode);
                    AddChildSiteMaps(rt, rootNode);
                }
            }
            return(rootNode);
        }
        public void Initialize()
        {
            ORM <Folder> orm = new ORM <Folder>();

            if (orm.Fetch("OPCBaseFolder") == null)
            {
                Folder f = new Folder();
                f.FolderID           = "OPCBaseFolder";
                f.CanBeRoot          = true;
                f.EntityName         = "OPC Servers";
                f.FolderBehaviorType = typeof(OPCServersFolderBehavior).FullName;
                f.Store();
            }

            ORM <PageData> pageDataOrm = new ORM <PageData>();
            PageData       pageData    = pageDataOrm.Fetch(new WhereCondition[] {
                new FieldWhereCondition("configuration_storage_id", QueryMatchType.Equals, SERVERS_PAGE_ID),
                new FieldWhereCondition("entity_folder_id", QueryMatchType.Equals, "OPCBaseFolder")
            }).FirstOrDefault();

            if (pageData == null)
            {
                pageDataOrm.Store(new PageData
                {
                    EntityFolderID         = "OPCBaseFolder",
                    ConfigurationStorageID = SERVERS_PAGE_ID,
                    EntityName             = "Servers",
                    Order = -1
                });
            }

            LookupListRegistration.Instance.RegisterObjectForType(typeof(OPCDataProvider), new OPCLookupListProvider());
        }
示例#6
0
        /// <summary>
        /// Validate the user based upon username and password.
        /// </summary>
        /// <param name="username">User name.</param>
        /// <param name="password">Password.</param>
        /// <returns>T/F if the user is valid.</returns>
        public override bool ValidateUser(string username, string password)
        {
            IObjectScope objScope = ORM.GetNewObjectScope();
            bool         isValid  = false;

            Employee e = ResolveEmployeeByName(objScope, username);

            if (e == null)
            {
                return(false);
            }

            if (CheckPassword(password, e.Password))
            {
                if (e.IsApproved)
                {
                    isValid = true;

                    objScope.Transaction.Begin();
                    e.LastLoginDate = DateTime.Now;
                    objScope.Transaction.Commit();
                }
            }
            else
            {
                UpdateFailureCount(objScope, e, FailureType.Password);
            }
            return(isValid);
        }
示例#7
0
        public static void Add(ORM orm)
        {
            Console.Write("\nCountry: ");
            string country = Console.ReadLine();

            Console.Write("City: ");
            string city = Console.ReadLine();

            Console.Write("Oblast: ");
            string oblast = Console.ReadLine();

            Console.Write("Region: ");
            string region = Console.ReadLine();

            Console.Write("Street: ");
            string street = Console.ReadLine();

            Console.WriteLine("House: ");
            int house = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Flat: ");
            int flat = Convert.ToInt32(Console.ReadLine());

            orm.Add(new Addresses
            {
                Country = country,
                City    = city,
                Oblast  = oblast,
                Region  = region,
                Street  = street,
                House   = house,
                Flat    = flat
            });
        }
示例#8
0
        /// <summary>
        /// Find all users matching a search string of their email.
        /// </summary>
        /// <param name="emailToMatch">Search string of email to match.</param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="totalRecords">Total records found.</param>
        /// <returns>Collection of MembershipUser objects.</returns>
        public override MembershipUserCollection FindUsersByEmail(string emailToMatch, int pageIndex, int pageSize, out int totalRecords)
        {
            IObjectScope objScope = ORM.GetNewObjectScope();
            const string queryEmployeesByEMail = @"SELECT * FROM  EmployeeExtent AS o WHERE o.EMail LIKE $1";

            return(QueryMembershipUsers(objScope, queryEmployeesByEMail, emailToMatch, pageIndex, pageSize, out totalRecords));
        }
示例#9
0
        /// <summary>
        /// Get a user based upon provider key and if they are on-line.
        /// </summary>
        /// <param name="userID">Provider key.</param>
        /// <param name="userIsOnline">T/F whether the user is on-line.</param>
        /// <returns></returns>
        public override MembershipUser GetUser(object userID, bool userIsOnline)
        {
            IObjectScope objScope = ORM.GetNewObjectScope();
            Employee     e        = ResolveEmployeeByID(objScope, userID.ToString());

            return(GetMembershipUser(objScope, userIsOnline, e));
        }
示例#10
0
        /// <summary>
        /// Get a collection of users.
        /// </summary>
        /// <param name="pageIndex">Page index.</param>
        /// <param name="pageSize">Page size.</param>
        /// <param name="totalRecords">Total # of records to retrieve.</param>
        /// <returns>Collection of MembershipUser objects.</returns>
        public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
        {
            IObjectScope objScope         = ORM.GetNewObjectScope();
            const string queryAllEmployee = @"SELECT * FROM  EmployeeExtent AS o";

            return(QueryMembershipUsers(objScope, queryAllEmployee, null, pageIndex, pageSize, out totalRecords));
        }
示例#11
0
        /// <summary>
        /// Change the user password.
        /// </summary>
        /// <param name="username">UserName</param>
        /// <param name="oldPwd">Old password.</param>
        /// <param name="newPwd">New password.</param>
        /// <returns>T/F if password was changed.</returns>
        public override bool ChangePassword(string username, string oldPwd, string newPwd)
        {
            if (!ValidateUser(username, oldPwd))
            {
                return(false);
            }

            ValidatePasswordEventArgs args = new ValidatePasswordEventArgs(username, newPwd, true);

            OnValidatingPassword(args);

            if (args.Cancel)
            {
                if (args.FailureInformation != null)
                {
                    throw args.FailureInformation;
                }
                else
                {
                    throw new Exception("Change password canceled due to new password validation failure.");
                }
            }

            IObjectScope objScope = ORM.GetNewObjectScope();

            objScope.Transaction.Begin();
            Employee e = ResolveEmployeeByName(objScope, username);

            e.Password = EncodePassword(newPwd);
            e.LastPasswordChangedDate = DateTime.Now;
            objScope.Transaction.Commit();
            return(true);
        }
示例#12
0
        static void Main(string[] args)
        {
            try
            {
                UpdateConfigs(args);
                PrintConfigValues();

                ORM.Init();
                Console.WriteLine("DB connected successfully\n");
                if (args.Contains("-clear"))
                {
                    ORM.Storage.Clear();
                    Console.WriteLine("Storage table cleared");
                    return;
                }
                Console.WriteLine("Files parsing starting...");
                var parser        = new DataParser();
                var storageValues = parser.ParseAll();
                Console.WriteLine("Files parsing finished\n");

                Console.WriteLine("Storage table inserting...");
                ORM.Storage.Insert(storageValues);
                Console.WriteLine("Inserting finished\n");
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
//测试实例
        private void btnSample_Click(object sender, EventArgs e)
        {
            messageFactory factory = new messageFactory();
            ACK            msg     = factory.Create(null, enumMessage.ACK, "ACK") as ACK;

            msg.msh.FieldSeparator.Value               = "|";
            msg.msh.EncodingCharacters.Value           = "^~\\&";
            msg.msh.DateOrTimeOfMessage.Value          = DateTime.Now.ToString("yyyyMMddhhmmss.fff");
            msg.msh.MessageType.messagecode.Value      = "ACK";
            msg.msh.MessageType.triggerevent.Value     = "A01";
            msg.msh.MessageType.messagestructure.Value = "ACK_A01";
            //msg.msh.MessageType.Value = "ACK^A01^ACK_A01";
            msg.msh.MessageControlID.Value          = "A00002";
            msg.msh.ProcessingID.processingID.Value = "P";
            msg.msh.VersionID.versionID.Value       = "2.4";
            msg.msa.AcknowledgmentCode.Value        = "AA";
            msg.msa.MessageControlID.Value          = "MSG00001";
            msg.msa.TextMessage.Value = "Success";

            txMessage.Text = msg.ToString() + "\n";
            ORM orm = factory.Create(null, enumMessage.ORM, "ORM") as ORM;

            orm.msh.FieldSeparator.Value               = "|";
            orm.msh.EncodingCharacters.Value           = "^~\\&";
            orm.msh.DateOrTimeOfMessage.Value          = DateTime.Now.ToString("yyyyMMddhhmmss.fff");
            orm.msh.MessageType.messagecode.Value      = "ORM";
            orm.msh.MessageType.triggerevent.Value     = "001";
            orm.msh.MessageType.messagestructure.Value = "ORM_001";
            orm.pid.PatientName.Value = "Wangzifu";
            txMessage.Text           += orm.ToString();
        }
 public static Node MapFromDb(ORM.Node sqlNode)
 {
     if (sqlNode.AdjacentNodes != null)
     {
         return new Node(sqlNode.Id, sqlNode.Label, sqlNode.AdjacentNodes1.Select(adj => adj.AdjacentId).ToList());
     }
     return new Node(sqlNode.Id, sqlNode.Label);
 }
示例#15
0
 public static void GetAll(ORM ado)
 {
     Console.WriteLine();
     foreach (var s in ado.GetAllStatus())
     {
         Console.WriteLine("{0}\t{1}", s.Id, s.Status);
     }
 }
示例#16
0
 public static void GetAll(ORM orm)
 {
     Console.WriteLine();
     foreach (var a in orm.GetAllAddresses())
     {
         Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t{6}\t{7}", a.Id, a.Country, a.City, a.Oblast, a.Region, a.Street, a.House, a.Flat);
     }
 }
示例#17
0
 public static void GetAll(ORM ado)
 {
     Console.WriteLine();
     foreach (var p in ado.GetAllPeople())
     {
         Console.WriteLine("{0}\t{1}\t{2}\t{3}\t{4}\t{5}", p.Id, p.FirstName, p.LastName, p.Age, p.PhoneNumber, p.Email);
     }
 }
示例#18
0
 public bool Register(ORM.PatientBasicInfo oPatient)
 {
     oDataContext.PatientBasicInfos.InsertOnSubmit(oPatient);
     oDataContext.SubmitChanges();
     //oDataContext.PatientBasicInfos.su
     //check exception here
     return true;
 }
示例#19
0
 public static void GetAll(ORM orm)
 {
     Console.WriteLine();
     foreach (var car in orm.GetAllCars())
     {
         Console.WriteLine("{0}\t{1}\t{2}\t{3}", car.Id, car.Brand, car.Number, car.Year);
     }
 }
示例#20
0
    private void CarregarGridTotesSeries()
    {
        series = ORM.retornarSeriesSearch("");

        GridViewSeries.Columns[6].Visible = false;
        GridViewSeries.DataSource         = series;
        GridViewSeries.DataBind();
    }
示例#21
0
 public void PlaceOrder(List <cart> list)
 {
     if (list.Count != 0)
     {
         DataTable dt = ORM.ConvertIntoTable <cart>(list);
         DataBase.InsertIntoDB("PlaceOrder", dt, "@carttb", new SqlParameter[] { new SqlParameter("@uid", this.UserID) });
     }
 }
示例#22
0
 public static void GetAll(ORM ado)
 {
     Console.WriteLine();
     foreach (var t in ado.GetAllTypes())
     {
         Console.WriteLine("{0}\t{1}", t.Id, t.Name);
     }
 }
示例#23
0
    //Funció per a loguejar
    protected void ButtonEntrar_Click(object sender, EventArgs e)
    {
        _usuari = null;
        string nomUsuari = TextBoxNomUsuari.Text;
        string pwd       = TextBoxContrasenya.Text;
        String regexPwd  = "(?=^.{6,255}$)((?=.*\\d)(?=.*[A-Z])(?=.*[a-z])|(?=.*\\d)(?=.*[^A-Za-z0-9])(?=.*[a-z])|(?=.*[^A-Za-z0-9])(?=.*[A-Z])(?=.*[a-z])|(?=.*\\d)(?=.*[A-Z])(?=.*[^A-Za-z0-9]))^.*";

        if (Regex.IsMatch(pwd, regexPwd))
        {
            if (Regex.IsMatch(nomUsuari, "^[a-zA-Z]{4,9}$"))
            {
                _usuari = ORM.buscarUsuariContrasenya(nomUsuari, pwd);

                if (_usuari != null)
                {
                    ScriptManager.RegisterStartupScript(this, typeof(Page), "script", "document.getElementById('alertError').style.display = 'none';", true);

                    Session["usuari"] = _usuari;
                    _usuari           = (Usuaris)Session["usuari"];

                    Response.Redirect("index.aspx");
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, typeof(Page), "script", "document.getElementById('alertError').style.display = 'inline-block';", true);
                    LabelError.Text = "Wrong user or password. Please check out again your credentials.";
                }
            }
            else
            {
                ScriptManager.RegisterStartupScript(this, typeof(Page), "script", "document.getElementById('alertError').style.display = 'inline-block';", true);
                LabelError.Text = "Invalid username.";
            }
        }
        else
        {
            ScriptManager.RegisterStartupScript(this, typeof(Page), "script", "document.getElementById('alertError').style.display = 'inline-block';", true);
            LabelError.Text = "Invalid password." + "<br/>" + "- Must not contain username." + "<br/>" + "- It must be between 6 and 10 characters, contain at least one digit and one alphabetic character, and must not contain special characters.";
        }

        try
        {
            _usuari = ORM.buscarUsuariContrasenya(nomUsuari, pwd);
        }
        catch {}

        if (_usuari != null)
        {
            ScriptManager.RegisterStartupScript(this, typeof(Page), "script", "document.getElementById('alertError').style.display = 'none';", true);

            Session["usuari"] = _usuari;
            _usuari           = (Usuaris)Session["usuari"];

            Response.Redirect("index.aspx");
        }

        netejarDades();
    }
        public string GetStatus(AbstractUserContext userContext, string externalEntityInvocationId)
        {
            ORM <ExternalInvocationEntity> externalInvocationEntityOrm = new ORM <ExternalInvocationEntity>();
            ExternalInvocationEntity       externalInvocationEntity    = externalInvocationEntityOrm.Fetch(externalEntityInvocationId);

            Log.Warn("Get Status Operation Successfully Invoked");

            return(externalInvocationEntity.Status);
        }
示例#25
0
        private void SetObjectData(JObject objectData)
        {
            this.connectStr = (String)(objectData["connectStr"]);
            this.tableName  = objectData["tableName"] == null ? String.Empty : (String)objectData["tableName"];
            this.codeType   = objectData["codeType"] == null ? String.Empty : (String)objectData["codeType"];
            var ormval = objectData["ORM"] == null ? "None" : (String)objectData["ORM"];

            orm = Enum.Parse <ORM>(ormval, true);
        }
示例#26
0
        public void SetUp()
        {
            sessionFactory = ORM <Adherent> .CreateSessionFactory(true);

            dataAccess   = new DataAccess(sessionFactory);
            servicePrets = new ServicePrets(dataAccess);
            CreateFixtures();
            PopulateDatabase();
        }
示例#27
0
        public string GetCode(string tableName, ORM ORMType, DataTable dtTables, DataTable dtColumns)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("export class " + tableName);
            sb.AppendLine(" {");
            appendProperty(ref sb, dtColumns);
            sb.AppendLine("}");
            return(sb.ToString());
        }
示例#28
0
        public static void Remove(ORM orm)
        {
            Console.Write("\nEnter the id you want to remove: ");
            int id = Convert.ToInt32(Console.ReadLine());

            orm.Remove(new Cars
            {
                Id = id
            });
        }
示例#29
0
        public static void Add(ORM orm)
        {
            Console.Write("\nName: ");
            string name = Console.ReadLine();

            orm.Add(new Types
            {
                Name = name
            });
        }
示例#30
0
        public static void Add(ORM orm)
        {
            Console.Write("\nStatus: ");
            string status = Console.ReadLine();

            orm.Add(new DeliveryStatus
            {
                Status = status
            });
        }
        //Fetch all the steps using a specified Database Connection Name.
        //The databaseConnectionName parameter will become a step input.
        //The step will return an array of step names and the table they connect to
        public string[] FetchStepsUsingDbConnection(string databaseConnectionName)
        {
            //Create the results list to return
            List<string> stepResultsList = new List<string>();

            //Use the ORM to get all FLOW element registrations
            ElementRegistration[] allFlows = new ORM<ElementRegistration>().Fetch(new WhereCondition[]
            {
                new FieldWhereCondition("is_flow", QueryMatchType.Equals, true),
            });
            
            //Loop through each flow
            foreach (ElementRegistration reg in allFlows)
            {
                //Open the flow 
                Flow flow = FlowEngine.LoadFlowByID(reg.ComponentRegistrationId, false, true);
                FlowStep currentStep = null;
                try
                {
                    //Loop through each step in the current flow
                    foreach (FlowStep step in flow.Steps)
                    {
                        currentStep = step;
                        
                        //If the step is a GetAllStep, Process it 
                        if (step.FlowStepType.Equals("GetAllStep`1"))
                        {
                            //Cast the step.WrappedStep into the appropriate step type.
                            GetAllStep<DatabaseTableDefinition> getAllStep = (GetAllStep<DatabaseTableDefinition>) step.WrappedStep;
                            
                            //If the step is on the appropriate connection, add it to the results.
                            if (string.Equals(getAllStep.DBConnectionName, databaseConnectionName))
                            {
                               stepResultsList.Add("Flow Name: " + flow.Name + " | Step Name: " + step.Name 
                                                   + " | DB Connection Name: " + getAllStep.DBConnectionName + " | Table Name: " + getAllStep.TableName);
                            }
                        }
                    }
                }
                catch (Exception ex)
                {
                    if (flow != null && currentStep != null)
                    {
                        stepResultsList.Add("Failed | Flow Name: " + flow.Name + " | Step Name: " + currentStep.Name);
                    }

                    if (flow != null)
                    {
                        _log.Error(ex, "Error processing steps for Flow: " + flow.Name + " with ID: " + flow.Id);
                    }
                }
            }

            return stepResultsList.ToArray();
        }
示例#32
0
    //Funció per seguir/deixar de seguir serie
    protected void FollowButton_Click(object sender, EventArgs e)
    {
        //Si l'usuari segueix serie seleccionada el botó cambia a default/primary amb text = unfollow
        String nomSerie = LabelNomSerie.Text;

        //Series serie = ORM.buscarSerie(nomSerie);
        ORM.afegirEliminarSerie(_usuari, nomSerie);
        comprobarSeguimentSerie(_usuari, nomSerie);

        initialize();
    }
示例#33
0
        public void BasicTest()
        {
            var target = new ORM("Library.mdb");

            var expected = new List<Book>
                {
                    new Book { Author = "Asimov", Title = "Pebble In The Sky", Pages = 235},
                    new Book { Author = "Asimov", Title = "Foundation and Empire", Pages = 325},
                    new Book { Author = "Asimov", Title = "Foundation", Pages = 466},
                    new Book { Author = "Asimov", Title = "Second Foundation", Pages = 388},
                    new Book { Author = "Asimov", Title = "The Caves of Steel ", Pages = 989},
                    new Book { Author = "Asimov", Title = "The End of Eternity", Pages = 234},
                };

            var actual = target.Get<Book>( book => book.Author == "Asimov" );

            Assert.That(actual, Is.EqualTo(expected));
        }
示例#34
0
文件: Mail.cs 项目: hieuuk/pingpoong
 /// <summary>
 /// Send an forget password email to user
 /// </summary>
 /// <param name="user">User who forget the password</param>
 /// <returns></returns>
 public static bool sendForgetPassword(ORM.User user)
 {
     string Content = string.Format(getMailTemplate("Template_ForgetPassword"),user.UserName, user.Password);
     sendHTMLMail("*****@*****.**", user.Email, "Quên mật khẩu", Content);
     return true;
 }
示例#35
0
 public ActionResult Edit(ORM.Pictures pictures)
 {
     try
     {
         if (ModelState.IsValid)
         {
             _repository.UpdatePicture(pictures.ToBllPicture());
             return RedirectToAction("Index");
         }
         ModelState.AddModelError("", "Произошла ошибка!");
         return View(pictures);
     }
     catch (Exception exception)
     {
         return PartialView("_Error", exception);
     }
 }
示例#36
0
        public string Verify(ORM.PatientBasicInfo oPatient)
        {
            string sErrorInfo = string.Empty;

            //var tmpPat = from BasicInfo in oDataContext.PatientBasicInfos
            //               let ConValue=(BasicInfo.NationalID==oPatient.NationalID) ? "Duplicate NID" : "Duplicate Parents"
            //             where (BasicInfo.NationalID == oPatient.NationalID ) select

            //                 new  { BasicInfo.PatientID,BasicInfo.PatientName,BasicInfo.NationalID,
            //                       VerfyField=ConValue};

            //if (tmpPat.Count() > 0)
            //{

            //    sErrorInfo = BL.LocalResourse.ErrorMessages.DuplicateNID;
            //    return sErrorInfo;

            //}

            //Notes: oDataContext ORM SQL data object & oPatient from valu object
            //var varDupLicateFMName = from BasicInfo in oDataContext.PatientBasicInfos

            //            where (BasicInfo.Relationship==oPatient.Relationship &&
            //            BasicInfo.PatientName==oPatient.PatientName &&
            //            BasicInfo.FatherName==oPatient.FatherName)
            //              select new
            //              {
            //                  BasicInfo.PatientID,
            //                  BasicInfo.PatientName,
            //                  BasicInfo.NationalID
            //              };

            //if (varDupLicateFMName.Count() > 0 && oPatient.PatientType==3)
            //{
            //    sErrorInfo = BL.LocalResourse.ErrorMessages.InvalidInfo;
            //    return sErrorInfo;
            //}

            //Added by shahed: Regular
            var varRegAndStaff = from BasicInfo in oDataContext.PatientBasicInfos

                                 where (BasicInfo.PatientType==oPatient.PatientType &&
                         BasicInfo.RelCode==oPatient.RelCode &&
                         BasicInfo.PatientName==oPatient.PatientName &&
                         BasicInfo.FatherName==oPatient.FatherName
                         )
                          select new
                          {
                              BasicInfo.PatientID,
                              BasicInfo.PatientName,
                              BasicInfo.NationalID
                          };

            if (varRegAndStaff.Count() > 0 && oPatient.PatientType!=2)
            {
                sErrorInfo = BL.LocalResourse.ErrorMessages.InvalidInfo;
                return sErrorInfo;
            }

            //Added by shahed: Respondant
            var varRespondant = from BasicInfo in oDataContext.PatientBasicInfos

                              where (BasicInfo.StudyName==oPatient.StudyName &&
                              BasicInfo.StudyID==oPatient.StudyID &&
                              BasicInfo.RelCode == oPatient.RelCode &&
                              BasicInfo.PatientName==oPatient.PatientName &&
                              BasicInfo.FatherName==oPatient.FatherName
                         )
                          select new
                          {
                              BasicInfo.PatientID,
                              BasicInfo.PatientName,
                              BasicInfo.NationalID
                          };

            if (varRespondant.Count() > 0 && oPatient.PatientType==2)
            {
                sErrorInfo = BL.LocalResourse.ErrorMessages.InvalidInfo;
                return sErrorInfo;
            }

            return sErrorInfo;
        }