예제 #1
0
        /// <summary>
        /// Create/Update MobileBriefcase data
        /// </summary>
        /// <param name="objId"></param>
        /// <param name="data"></param>
        /// <param name="staffId"></param>
        /// <param name="briefcaseType"></param>
        public static void CreateUpdateBriefcase(int objId,object data, int staffId, int briefcaseType)
        {
            if (data != null)
            {
                if (!_ctx.MobileBriefcase.Any(b => b.BreifcaseTypeId == objId && b.StaffId == staffId && b.BreifcaseType == briefcaseType))
                {
                    MobileBriefcase bc = new Data.MobileBriefcase();
                    bc.BreifcaseType = briefcaseType;
                    bc.BreifcaseTypeId = objId;
                    bc.BriefcaseData = Newtonsoft.Json.JsonConvert.SerializeObject(data, Newtonsoft.Json.Formatting.Indented);
                    bc.StaffId = staffId;
                    bc.CreatedBy = GetCurrentUser(staffId);
                    bc.CreatedDate = DateTime.Now;
                    bc.ModifiedBy = GetCurrentUser(staffId);
                    bc.ModifiedDate = DateTime.Now;

                    _ctx.MobileBriefcase.Add(bc);
                    _ctx.SaveChanges();
                }
                else
                {
                    var obj = _ctx.MobileBriefcase.Where(b => b.BreifcaseTypeId == objId && b.StaffId == staffId && b.BreifcaseType == briefcaseType)
                           .FirstOrDefault();

                    obj.BriefcaseData = Newtonsoft.Json.JsonConvert.SerializeObject(data, Newtonsoft.Json.Formatting.Indented);

                    _ctx.SaveChanges();
                }
            }
        }
예제 #2
0
        /// <summary>
        /// Save MyPreference Screen Data.
        /// </summary>
        /// <param name="stf"></param>
        /// <param name="loggedInUser"></param>
        /// <returns></returns>
        public async Task <_SCResult <Models.StaffPreferenceModel> > Save(StaffPreferences stf, int loggedInUser)
        {
            try
            {
                var _Ce = new _SCResult <Models.StaffPreferenceModel>();

                IBriefcaseRepository _repo       = new BriefcaseRepositiry(new SCMobile());
                List <Difference>    differences = new List <Difference>();
                bool modified = IsDataModified(stf.StaffPreferenceId, loggedInUser, CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "MYPREFERENCE"), stf, out differences);

                if (modified)
                {
                    var original = _scEntity.StaffPreferences
                                   .Where(s => s.StaffPreferenceId == stf.StaffPreferenceId).FirstOrDefault();


                    foreach (var difference in differences)
                    {
                        string[] changedPprts = difference.PropertyName.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries);

                        //Handled only objects which doesn't have sibling object
                        if (string.IsNullOrEmpty(difference.ParentPropertyName))
                        {
                            foreach (PropertyInfo propertyInfo in original.GetType().GetProperties())
                            {
                                if (changedPprts.Contains(propertyInfo.Name))
                                {
                                    propertyInfo.SetValue(original, propertyInfo.GetValue(stf, null), null);
                                }
                            }
                        }
                    }

                    _scEntity.SaveChanges();
                }
                _Ce.SavedResult = await _repo.GetMyPreference(stf.StaffId);

                _Ce.LocalstoreName       = "mypreference";
                _Ce.UnsavedId            = _Ce.SavedId = _Ce.SavedResult.StaffPreferenceId;
                _Ce.DeleteUnsavedChanges = true;
                _Ce.ShowDetails          = false;
                _Ce.Details     = null;
                _Ce.SavedResult = await FindMobileUser(stf.StaffId);

                if (stf != null)
                {
                    CommonFunctions <Models.StaffPreferenceModel> .CreateUpdateBriefcase(stf.StaffPreferenceId, _Ce.SavedResult, loggedInUser, CommonDBFunctions.GetGlobalCodeId("BRIEFCASETYPE", "MYPREFERENCE"));
                }

                return(_Ce);
            }
            catch (Exception ex)
            {
                Exception excep = new Exception("Exception occured in MobileStaffRepositiry.Save method." + ex.Message);
                throw excep;
            }
        }
예제 #3
0
        /// <summary>
        /// UpdateSignature
        /// </summary>
        /// <param name="sig"></param>
        /// <returns></returns>
        public _SCResult <ClientDocumentsModel> UpdateSignature(ClientDocumentsModel sig)
        {
            var _Ce = new _SCResult <ClientDocumentsModel>();

            if (!string.IsNullOrEmpty(sig.Signature.SignatureString))
            {
                //1
                _sqlConnection = new SqlConnection(_ctx.Database.Connection.ConnectionString);
                _sqlConnection.Open();

                _sqlTransaction = _sqlConnection.BeginTransaction(IsolationLevel.ReadUncommitted, "_sqlTransaction");
                sig.Signature.SignatureString = sig.Signature.SignatureString.Replace("data:image/png;base64,", "");

                var signatureImageBytes = Convert.FromBase64String(SC.Base.CommonFunctions.EncodeBase64(sig.Signature.SignatureString));



                //var path = "C:\\Users\\pradeepa\\AppData\\Local\\Microsoft\\Windows\\INetCache\\test123.jpeg";
                //System.Drawing.Image newImage;
                //using (MemoryStream stream = new MemoryStream(signatureImageBytes))
                //{
                //    newImage = System.Drawing.Image.FromStream(stream, true);
                //    newImage.Save(path);
                //    //img.Attributes.Add("src", strFileName);
                //}

                ScreenModel sModel = _commonRepository.GetScreenDetail(sig.DocumentCodeId);

                var userCode = _ctx.Documents
                               .Where(d => d.DocumentId == sig.DocumentId)
                               .Select(d => d.ModifiedBy).FirstOrDefault();
                var ClientId = sig.IsClient == "Y" ? sig.ClientId : 0;

                SignedByClient(ClientId, sig.DocumentId, signatureImageBytes, sig.SignatureId, sig.DocumentVersionId, userCode, _sqlTransaction);

                DataSet dataset = ExecuteUpdateStoredProcedure(_sqlTransaction, sModel.PostUpdateStoredProcedure, sig.DocumentId, sig.AuthorId, userCode, "");

                if (dataset.Tables.Count > 0 && dataset.Tables["PostUpdateErrorDetails"].Rows.Count > 0)
                {
                    _sqlTransaction.Rollback();
                    _Ce.NoteValidationMessages = JsonConvert.DeserializeObject(JsonConvert.SerializeObject(dataset));
                }
                else
                {
                    _sqlTransaction.Commit();

                    DocumentPDFGenerationQueue queue = new DocumentPDFGenerationQueue();
                    queue.DocumentPDFGenerationQueueId = -1;
                    queue.CreatedBy         = "APIDocumentRepository";
                    queue.CreatedDate       = DateTime.Now;
                    queue.ModifiedBy        = "APIDocumentRepository";
                    queue.ModifiedDate      = DateTime.Now;
                    queue.DocumentVersionId = Convert.ToInt32(sig.DocumentVersionId);

                    _ctx.DocumentPDFGenerationQueue.Add(queue);

                    _ctx.SaveChanges();

                    _Ce.SavedResult           = GetDocumentModel(sig.DocumentVersionId);
                    _Ce.DeleteObjectStoreData = true;
                    _Ce.DeleteUnsavedChanges  = true;
                    _Ce.SavedId   = _Ce.SavedResult.DocumentVersionId;
                    _Ce.UnsavedId = _Ce.SavedResult.DocumentVersionId;
                }

                //Call SignDocument Function
                //1. Convert Signature String to Bytes
                //2. Call SignedbyClient
                //3. Pass DocumentId and get ssp_SCGetDocumentDetailOfDocumentID Documents table data using ssp_SCGetDocumentDetailOfDocumentID (TNOT REQUIRED) - Get CurrentUser From Modified By ModifiedBy
                //4. Call ssp_SCSignatureSignedByClient passig parameters Transaction
                //5. Call DocumentPostSignatureUpdates- StaffId,DocumentId,Transaction,
                //6. Call DocumentPostSignatureUpdates ssp_SCDocumentPostSignatureUpdates Pass UserId and DocumentId
                //7. Call ExceutePostUpdateScreenStoredProcedureCore GetSP name from Screens.PostUpdateScreenStoredProcedureCore for the DocumentCodeId and rerurn PostUpdateErrorDetails Table
                //8. If record found in PostUpdateErrorDetails, Rollback transaction Otherwise call ExecuteUpdateStoredProcedure With Screens .PostUpdateStoredProcedure.
                //9. If records found PostUpdateErrorDetails in Rollback Otherwise Commit
            }
            return(_Ce);
        }