Beispiel #1
0
        public string SaveAppLog([FromBody]  JObject jobj)
        {
            AppLog         jobjdata = new AppLog();
            Document       doc = new Document();
            BLReturnObject objBLReturnObject = new BLReturnObject(); Master master = new Master();
            string         message = "";
            DS_AppLog      ds_app  = new DS_AppLog();
            List <AppLog>  tload   = new List <AppLog>();

            tload = jobj["log"].ToObject <List <AppLog> >();
            DataTable dt_log = new DataTable(); string LogDocID = "";

            dt_log = BLGeneralUtil.ToDataTable(tload);
            try
            {
                if (jobj != null)
                {
                    if (dt_log != null && dt_log.Rows.Count > 0)
                    {
                        DBConnection.Open();
                        DBCommand.Transaction     = DBConnection.BeginTransaction();
                        ds_app.EnforceConstraints = false;
                        if (!doc.W_GetNextDocumentNo(ref DBCommand, "APL", "", "", ref LogDocID, ref message)) // New Driver Notification ID
                        {
                            return(BLGeneralUtil.return_ajax_string("0", message));
                        }
                        ds_app.AppLog.ImportRow(dt_log.Rows[0]);
                        ds_app.AppLog[0].log_id       = LogDocID;
                        ds_app.AppLog[0].log_date     = System.DateTime.UtcNow;
                        ds_app.AppLog[0].created_date = System.DateTime.UtcNow;
                        ds_app.AppLog[0].AcceptChanges();
                        ds_app.AppLog[0].SetAdded();
                        ds_app.EnforceConstraints = true;
                        objBLReturnObject         = master.UpdateTables(ds_app.AppLog, ref DBCommand);
                        if (objBLReturnObject.ExecutionStatus != 1)
                        {
                            ServerLog.Log(objBLReturnObject.ServerMessage.ToString());
                            DBCommand.Transaction.Rollback();
                            if (DBConnection.State == ConnectionState.Open)
                            {
                                DBConnection.Close();
                            }
                            return(BLGeneralUtil.return_ajax_string("0", objBLReturnObject.ServerMessage));
                        }
                        DBCommand.Transaction.Commit();
                        if (DBConnection.State == ConnectionState.Open)
                        {
                            DBConnection.Close();
                        }
                        objBLReturnObject.ExecutionStatus = 1;
                        ServerLog.SuccessLog("App Log Entry Saved : " + LogDocID);
                    }
                }
            }
            catch (Exception ex)
            {
                ServerLog.Log(ex.Message + ex.StackTrace);
                DBCommand.Transaction.Rollback();
                if (DBConnection.State == ConnectionState.Open)
                {
                    DBConnection.Close();
                }
                return(BLGeneralUtil.return_ajax_string("0", ex.Message));
            }
            return(BLGeneralUtil.return_ajax_string("1", "App Log Entry Saved : " + LogDocID));
        }