Ejemplo n.º 1
0
        public Guid Save_LabFileDataHeader(TRSTGLabFileDataHeader model)
        {
            var  currentDateTime = DateTime.Now;
            Guid objReturn       = Guid.Empty;

            using (var _db = new LabDataContext())
            {
                using (var trans = _db.Database.BeginTransaction())
                {
                    try
                    {
                        _db.TRSTGLabFileDataHeaders.Add(model);

                        _db.SaveChanges();

                        trans.Commit();
                    }
                    catch (Exception ex)
                    {
                        // TODO: Handle failure
                        trans.Rollback();
                    }
                    finally
                    {
                        trans.Dispose();
                    }
                }
            }

            return(objReturn);
        }
Ejemplo n.º 2
0
        public int Get_CheckExistingHeader(TRSTGLabFileDataHeader model, string mp_program, string mp_filetype)
        {
            int objReturn       = 1;
            var currentDateTime = DateTime.Now;

            using (var _db = new LabDataContext())
            {
                using (var trans = _db.Database.BeginTransaction())
                {
                    try
                    {
                        //var objResult2 = _db.TRSTGLabFileDataHeaders.FirstOrDefault(x => x.ldh_hos_code == model.ldh_hos_code
                        //                                                  && x.ldh_lab == model.ldh_lab
                        //                                                  && x.ldh_labno == model.ldh_labno
                        //                                                  && x.ldh_organism == model.ldh_organism
                        //                                                  //&& x.ldh_specimen == model.ldh_specimen
                        //                                                  && x.ldh_date == model.ldh_date
                        //                                                  && x.ldh_lfu_id != model.ldh_lfu_id
                        //                                                  && x.ldh_flagdelete == false);

                        var objResult = _db.TRSTGLabFileDataHeaders.FromSqlRaw <TRSTGLabFileDataHeader>("sp_UPLOAD_CheckExistingHeader {0},{1},{2},{3},{4},{5},{6},{7}",
                                                                                                        model.ldh_hos_code,
                                                                                                        model.ldh_lab,
                                                                                                        model.ldh_labno,
                                                                                                        model.ldh_organism,
                                                                                                        model.ldh_date,
                                                                                                        model.ldh_lfu_id,
                                                                                                        mp_program,
                                                                                                        mp_filetype
                                                                                                        ).AsEnumerable().FirstOrDefault();


                        if (objResult != null)
                        {
                            objReturn = objResult.ldh_sequence + 1;

                            objResult.ldh_status     = 'D';
                            objResult.ldh_flagdelete = true;
                            objResult.ldh_updateuser = "******";
                            objResult.ldh_updatedate = currentDateTime;
                            _db.SaveChanges();
                        }

                        trans.Commit();
                    }
                    catch (Exception ex)
                    {
                        // TODO: Handle failure
                        trans.Rollback();
                    }
                    finally
                    {
                        trans.Dispose();
                    }
                }
            }

            return(objReturn);
        }
Ejemplo n.º 3
0
        public Guid Get_HeaderIdForMultipleline(TRSTGLabFileDataHeader model)
        {
            Guid objReturn = Guid.Empty;

            using (var _db = new LabDataContext())
            {
                using (var trans = _db.Database.BeginTransaction())
                {
                    try
                    {
                        var objResult = _db.TRSTGLabFileDataHeaders.FirstOrDefault(x => x.ldh_lfu_id == model.ldh_lfu_id &&
                                                                                   x.ldh_hos_code == model.ldh_hos_code &&
                                                                                   x.ldh_lab == model.ldh_lab &&
                                                                                   x.ldh_labno == model.ldh_labno &&
                                                                                   x.ldh_organism == model.ldh_organism
                                                                                   //&& x.ldh_specimen == model.ldh_specimen
                                                                                   && x.ldh_date == model.ldh_date &&
                                                                                   x.ldh_flagdelete == false);

                        if (objResult != null)
                        {
                            objReturn = objResult.ldh_id;
                        }
                    }
                    catch (Exception ex)
                    {
                        // TODO: Handle failure
                        trans.Rollback();
                    }
                    finally
                    {
                        trans.Dispose();
                    }
                }
            }

            return(objReturn);
        }